New Monitoring Tool

I've recently put two and two together and have improved my ability to monitor stocks via GoogleDocs.  In the past I've been limited to the capability of the GoogleFinance function, manual entry and related calculations.  And GoogleFinance has some distinct limitations, so this has been quite time consuming and perhaps not as effective as it could be.

The manual entries were quite a pain as I had to navigate to another URL, find the data of interest, then paste or type it into the GoogleDocs spreadsheet.

I've now been able to use the Import function as a substitute for these manual actions.  It also requites some other embedded functions to create the desired URL and parse the data.  But the result is a much easier process that I'm able to update more frequently.

A given spreadsheet is limited to 50 imports, so I'm not able to keep live data at all times, but it's much quicker to update the data now than before (using the import formula, then copying to the same cell using "Paste Value").  I update these fields more frequently now.