Portfolio Tracking Spreadsheet

[tweet737]

I built a Google Sheets spreadsheet to track/manage my portfolio.

I am finding the price that populates from Google Finance is often different than what is shown on my online account at my custodians (Schwab/Vanguard).

This is the formula I am using:

=GOOGLEFINANCE(C10, "price")

I realize that while the market is open, the price will change. However, after market close, shouldn't the prices be the same?

As I tried to research this my understanding is that Google Finance is no longer supported. Should I be using a different site from which to pull prices for my spreadsheet?

Looking for wisdom and recommendations.

Thanks

[gatorking]

Are you looking at prices of ETFs, stocks or mutual funds?
To get price I use =GOOGLEFINANCE(C10)

[tweet737]

Mutual Funds.

[mudd]

interesting!

I was vaguely aware of googlesheets ability to pull stock price... but I built my tracking sheets in excel and manually update price at close every day. Doesn't take but a minute and I enjoy it.

[Hydromod]

interesting!

I was vaguely aware of googlesheets ability to pull stock price... but I built my tracking sheets in excel and manually update price at close every day. Doesn't take but a minute and I enjoy it.

If you have microsoft 365, you can define a stock data type and get a variety of things about each asset (price, ER, etc.)

[BBurki]

I use a Google Docs spreadsheet with the GOOGLEFINANCE function and it works great. For ETFs it will update throughout the day. But for mutual funds it appears to only update once per day, which seems reasonable for non-ETF funds.

[rossington]

interesting!

I was vaguely aware of googlesheets ability to pull stock price... but I built my tracking sheets in excel and manually update price at close every day. Doesn't take but a minute and I enjoy it.

If you have microsoft 365, you can define a stock data type and get a variety of things about each asset (price, ER, etc.)

This template available in microsoft 365 pretty much does it all:
https://templates.office.com/en-us/inve ... a%20source.

[bgf]

I’ve used google sheets for years to track my portfolio. ETFs are delayed 15-20minutes and mutual funds update sometime overnight. If you want to see your accurate portfolio value with mutual funds it has to be in the morning before market opens.

My portfolio is a mix of mutual funds and etfs so it changes during the day due to etfs while mutual funds aren’t updated til overnight.

Is this your problem? Otherwise it can’t be anything other than cash balances and number of shares that is off.

[acegolfer]

As I tried to research this my understanding is that Google Finance is no longer supported.

Can you share the link? My spreadsheet uses =GOOGLEFINANCE( ) and I haven't noticed any changes lately.

[dcabler]

interesting!

I was vaguely aware of googlesheets ability to pull stock price... but I built my tracking sheets in excel and manually update price at close every day. Doesn't take but a minute and I enjoy it.

If you have microsoft 365, you can define a stock data type and get a variety of things about each asset (price, ER, etc.)

Works for Excel 2021 as well, by the way. I use it all the time.

Cheers.

[rolandtorres]

googlefinance should work but you can scrape it from marketwatch too:

https://stackoverflow.com/questions/737 ... gle-sheets

[JupiterJones]

Are you looking at prices of ETFs, stocks or mutual funds?
To get price I use =GOOGLEFINANCE(C10)

Right. "Price" is the default attribute, so one can specify it in the formula or not.

As others have mentioned, there is a bit of a delay before the results of this formula "catch up" with other sources. Apparently can view the current delay using =GOOGLEFINANCE(C10, "datadelay") but I don't think I've ever gotten that to work.