MicrosoftThe STOCKS option under the Data Toolbar might be a great help for me in keeping track of my investments. I do not have any individuas stocks, but it appear to be able to handle all my mutal funds. Currently I am using an Internet posted Google spread sheet to move the price data into my Excel sheet, but I will go over to use the Stocks option later when I feel that it is stable enough.
I would like for the STOCKS to handle Currency Exchange Rates as well, but I have not been able to make it work. I have entered the currencies in the standard ISO format, such as USD/EUR, but will get a USD stock tickersymbol for 'ProShares Ultra Semiconductors', and if I enter USDEUR I will get a #FIELD! error. Are there any plans to include currency rates in STOCKS, or to add another function, such as CURRENCIES under the Data Toolbar?
In the meantime I will use Google or import data from X-rates.com.
