Download your portfolio

1. Go to
2. Tap or click Your stocks.
3. Next to “Your stocks,” tap or click Add from Portfolios. Download portfolios.
4. Tap or click Spreadsheets.
5. Your portfolio downloads as a CSV file.

How do I create a portfolio in Google Finance?

To create a portfolio, you simply click on the Portfolios link at top of the Google Finance home page. Then click Create a Portfolio. As soon as you have created and named your portfolio, you can start adding stocks and mutual funds.

Does Google Finance have a portfolio?

Although Google Finance is eliminating the portfolio, it doesn’t mean their entire finance site will be shut down. If you are looking for free portfolio software only, you can create a stock portfolio tracking spreadsheet using Google sheets.

How do I download data from Google Finance?

This will take only a few minutes to download and import your stock data.

1. Log in to Google Finance at
2. Click on “Portfolios.” If you have multiple portfolios, select the portfolio you want to export.
3. Click on “Download to spreadsheet.”
4. Open Excel.
5. Click on “File” and then click on “Open.”

What happened to my Google Finance portfolio?

Google Finance will discontinue its portfolio feature as part of an overhaul that will occur this month. Google says the new site will let customers monitor industry news and market trends, and maintain a watchlist, but will no longer perform any portfolio analysis.

How do I get Google Finance data into Google Sheets?

Use the GOOGLEFINANCE function

1. In Sheets, open a spreadsheet.
2. In an empty cell, type =GOOGLEFINANCE.
3. In parenthesis, add any of the following, separated by a comma: A ticker symbol in quotation marks. (Optional) The attribute you want to show, such as price, in quotation marks.
4. Press Enter.

Does Google have a stock app?

While Google doesn’t supply a standalone stocks app in Android, it does provide a way to track stocks in Google Now (or, if you prefer, the Google app). To monitor a particular stock, tap the menu button in the top left corner, then select Customize, and finally, Stocks.

How to track stock portfolio with Google Sheet?

I use a Google Sheet to track my stock portfolio. This is an example of what the spreadsheet looks like. If you just want to download a copy scroll to the bottom of this page.

How to get real time stock quotes on Google Finance?

Google Finance. Get real-time stock quotes & charts, financial news, currency conversions, or track your portfolio with Google Finance.

What do you need to know about Google Finance?

Google Finance provides real-time market quotes, international exchanges, up-to-date financial news, and analytics to help you make more informed trading and investment decisions.

How to use Google Finance in a spreadsheet?

So if we want to use the GoogleFinance function to display one of these attributes we use the following formula in the spreadsheet cell: For example, if we want to display the current P/E ratio for Apple, we use this formula in the spreadsheet cell: Easy enough, right? Across the top of the spreadsheet there are 14 column headers.