Today is a testing day for naive investors in the Indian stock market. Index advanced and declined at 1:14 and it touched 700 negative in late trading. I wanted to make some quick bugs by investing in a loser and selling it when the market bounces back. So I shortlisted five such stocks using the BSE trends worksheet. As I also wanted to track few other stocks that are not in the index, I added all of them in my watch list.
But that didn’t help me tracking my favorite losers. Charts in Google Spreadsheets came handy at that moment and I created a new worksheet for the Gain-Loss chart which shows only the items in the watch list.
BSE and NSE entries are grouped in the chart. This is a published version of the chart which keeps on updating in every 5 minutes (Refresh the page to see the latest).
The chart may not be useful in the published version of the spreadsheet, but in the editable version, it’s interactive and shows a tool tip upon clicking the bar.
