Download the file from, We created an Excel spreadsheet which pulls stock data by Yahoo Finance API and place it on a sheet.
Zoho Sheet stands out from the free spreadsheet pack by offering a host of features in a nice package with great performance. The ability to import from and export to many different formats makes it easy to get up and running, and a feature set that rivals desktop applications make the choice an easy one. Zoho Sheet is part of the Zoho Office Suite of online applications, which includes Zoho Writer, a great online word processor. Features include cloud storage, a full audit trail, and great support.
The tools finance professionals use to screen securities, gather statistics and analyze market intelligence are invaluable. Unfortunately they can be so expensive that the individual investor typically cannot access them; that’s where Yahoo!
Finance can help. Yahoo has a set of tools that rival the professional ones so that individuals will not be at a disadvantage. To use these tools there is an enormous amount of data to go through, so we've provided a guide to help steer users to the top tools for investors. 2. My Portfolio (NOTE: You have to have a Yahoo account to access this, as it requires you to log it): After utilizing all the resources provided in the Stock Research Center, 'My Portfolio' is perhaps the next most useful tool. It allows investors to track portfolios or securities of interest, customize the screen view, choose fields based on investor interest, such as valuation metrics, estimates and price movements, among others. It even allows investors to input the number of shares purchased and the purchase price to track gains or losses. Not only can investors maintain current information, Yahoo!
Finance turns that list of tickers into the news feeds for users, tailoring which news stories the user receives based on the tickers in the portfolios. Finally the tool allows users to sync up with other sites to their actual portfolios.