interval (Optional) - The frequency of returned data either "DAILY" or "WEEKLY".end_date|num_days (optional) - The end date when fetching historical data, or the number of days from start_date for which to return data.start_date (Optional) – The start date when fetching historical data.attribute (Optional) – The attribute is the information you want to fetch, for example, price, marketcap, volume, etc.ticket (Optional) – The first parameter is the ticker symbol of the security for which you want the information.The full format of the function is given below: GOOGLEFINANCE(ticker,, ,, ) The GoogleFinance function can be used to retrieve both current and historical information about the securities. The above function will fetch the current price for Apple stock from Google Finance. In a cell type =GoogleFinance("AAPL","price") Let’s say you want to retrieve the last stock price for Apple. Open a new google spreadsheet and following the following steps. Let’s look at the different ways to do so. Just like in excel, you can import data from external sources into google spreadsheets. Google Spreadsheets have become quite powerful and can be used to perform complex calculations and create dynamic dashboards. This post provides an alternative to downloading stock prices in excel, for those who prefer to manage their portfolio in Google Spreadsheets.
0 Comments
Leave a Reply. |