|Currently I've been experimenting with GoogleFinance function in Google Docs. =googlefinance(D$3,$A$5)|
Let us know if you learn how to replace this functionality.I was also using it and it's a big loss. It is superior to the old MSN lookup as it :
- is a function that you call in a cell not some special look-up that is buggy and often freezes worksheets.
- seems to update every minute with real time data AND
- it will pull down a quote for the Dow which an add-on I have as a workaround doesn't pull.
I'm not a big fan of having to use Chrome to do spreadsheets, but since my spreadsheets are already backed up in the Cloud at Google (since MSFT was too unreliable and kept making changes, I only trust MSFT for backing up my music which is also backed up by Google) I can live with Chrome/Google knowing what stocks I'm interested in...
I'm writing my newsletter this week so quite consumed, but next week I'll see if I can port some of my more complex and important sheets to Google Docs and if the charts I generate from the data still work.