diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)

Aug132010

Tips To Use GoogleFinance function In Google Spreadsheets

Did you know, you can use GoogleFinance function in Spreadsheets to automatically pull up-to-date information into your spreadsheet to create a one-stop shop for your stock data. “To use GoogleFinance, enter the formula into a desired cell: =GoogleFinance(“Symbol”, “Attribute”) where “symbol” represents stock symbol of the company or mutual fund you’re looking for and “attribute” represents type of market data that you want information about. If attribute is left blank, stock price is populated into the cell by default.”

You can also apply formula to a larger list of symbols and attributes in order to get data for multiple different stock/mutual fund listings across various types of data.

GoogleFinance also allows you to show historical stock data, allowing you to track the performance of any stock across a certain time period. To show historical data, type =GoogleFinance(“symbol”, “attribute”, “start_date”, “num_days|end_date”, “interval”) into a spreadsheet cell.

[Source]

Share This Story, Choose Your Platform!