The idea is a user of the website will pick up to 5 stocks which they will all continuously update on whether it will gain or lose value from? its current position.? I will not provide a live stock tick on my site.? Rather, I will provide the number? of users who think whether it is going up or down at any given time, accurately to the current second..? The page will be updated every second. ? I expect about 500 to 1000 users at any given time during trading hours, all of the getting an update per second.? The solution must be lightweight in term of traffic? overhead as it is a concern both for my server and my users' internet connection.
For this project you may substitute the database with Microsoft Access. Create the? very s? however simple you like. Simply create 5 dummy stock symbol. And make the live user sentiment tracking work. Do not worry about the aesthetics.