Some of The Inner Workings

Let's take a look at the program behind all this. Columns B through G obviously hold the days action....change,open, high, low, close and volume. Standard stuff. This information is brought into the excel workbook by a web query that is run from a macro developed by: excelhero.com Its a rather complex macro that the writer allows anyone to use as long as his copyright material in the macro itself is not removed. Easy enough, and for all the work and talent he put into that macro, he deserves all the recognition he can get...believe me.

So, one can either enable or disable the worksheet to go out to yahoo and retrieve data. In fact, these 5 columns of data (COHLCV) are just the tip of the iceberg as to what can be retrieved automatically and dumped onto the sheet, due to the beauty of this macro. And, you can setup the worksheet to refresh information at any minute interval you want. So, at work I just have this worksheet running in the background (minimized) and refreshing every 5 minutes or so and I can immediately check on my entire portfolio by maximizing the window in a flash. Very nice and handy.

So, in summary, columns B through G are changing automatically as the information is refreshed which in turn is dependant upon the number minutes between refresh intervals. Column A is a listing of the stock symbols that are hyperlinked to the actual backup worksheets. By hyperlinked, I mean when you click on the symbol, the backup worksheet is automatically opened, allowing you to look at the details of that stock symbol in more detail. No need to go hunting for the worksheet tab at the bottom....just click and go.

Thats it for now...much more on the flexibility of this workbook at a later time.