


The first is Portfolio and second is Scripts. The VBA macro will extract or fetch data (current stock price with changes) from Rediff Money every few seconds and show the figures against a given list of scripts or company (multiple scripts).

The above image gives you an idea about what this example here is going to show you. However, if you are still actively investing in the stock market and use Ms-Excel, then here’s an example on how to get current stock quotes, every few seconds, in your Excel worksheet from a Web page using VBA Macro. Ok, I did maintain a small portfolio in the past, until the market came crashing in the year 2008. I am not a stockbroker, neither have I invested in stocks in recent years.
