Police said in a news release that K9 Lando recently became unexpectedly ill and was found to have an autoimmune disease, Myasthenia Gravis. UPDATE July 6th 2017: The old Yahoo Finance API was discontinued, so the spreadsheet stopped working for a while.OSHKOSH - Oshkosh Police Department recently announced the passing of K9 Lando. Disclaimer: the link to MarketXLS is an affiliate link, but this has not influenced my opinion of the tool. You just use one of 80 new functions together with your chosen ticker. It’s a rock-solid route to getting live stock data inside Excel. UPDATE 5th January 2014: I’ve just evaluated a financial data add-in for Excel MarketXLS. UPDATE 14th February 2013: Download historical quotes into Excel for multiple stock tickers here

UPDATE 18th August 2011: Here’s a Mathcad worksheet to download stock quotes from Yahoo Finance UPDATE July 17th 2011: Here’s an Excel spreadsheet that downloads historical Forex rates for two currency pairs between two dates You’ll need to enable macros before you use the spreadsheet (Excel may warn you that you’re importing a macro-enabled worksheet). It can be modified to download other data found on the web. The VBA that retrieves the data from Yahoo was adapted from code found at mathfinance.cn. Sharpe, Sortino and Treynor Ratios), plot histograms of daily returns to check if they’re normally distributed, identified stocks with my desired risk characteristics, and calculate mean-variance optimal portfolios. For example, I’ve used this variations of this spreadsheet to calculate investment ratios (e.g. You could also perform far more advanced analyses (which I’ll discuss in future blog posts).

Download yahoo currency