Build Your Own Portfolio Dashboard Tracker in 20 Minutes! (Portfolio Tracker in Google Sheets)

I'm trying to sign up for patreon, but it keeps rejecting any of my credit cards.....Any tricks I should know about? Thanks

Hi. My sheets says this: "Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive" for the dividend formula. Can you please tell me why?

Some of my tickers don't show up using the Google Finance formula. Do you know why this would be? It seems to be a lot of .TO stocks (I am Canadian and buy a lot of stocks on the TSX). or .CN stocks. Is there a workaround for this?

What website would I use instead of finviz for my Canadian Stocks?

I'm encountering the "Function INDEX parameter 2 value is 7. Valid values are between 0 and 2 inclusive." Error when trying to key in the dividend. How do I resolve it?

Thank you so much for another wonderful job. You are absolutly amazing. I learnd a lot from you understanding google sheets and I enjoyed your presentation for Portfolio Tracker. Thank you again for a great job.

in my dividend column import from finviz come like text and does not allows me to make subtraction, multiply,etc. Any recommendation how to tranform this column to a number? Thanks

Wow, thank you so much!! I am going to go chart crazy right now😂

What if I have my stocks in 2 currencies, Euros and Dollars. How do I navigate this situation? Because Google Sheets just adds them up like they are the same, even though I did fill them in in euros and dollars. Do I just change my entire Google sheet to one currency, or can I try something else?

I can’t believe I found this. Dude you are the Goat 🐐

hi I don't know why the formula for dividend doesn't works, any helps?

The industry is not working anymore as well

for the dividend formula i keep getting this error please help I don't know if Im entering it wrong or am i just stupid lol (Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive.\

What if purchase price has changed, would data still be accurate?
For example if you buy BAC one month at 37.31 first month, and next month you buy it again but this time at 34.0. How could we keep track of the actual market value when shares have different purchase prices over months?
Thanks

okay, thank you. but pls control your talking speed for better understanding.

1yr tredline which works for me :)
=SPARKLINE(GOOGLEFINANCE(A3,"price",TODAY()-360,TODAY()),{"linewidth",2;"color","RED"})

So you have to upload your portfolio to Google? I am not sure I want my financial data in Google's cloud or any cloud for that matter.

Is it possible to include the announcement date, ex dividend date & dividend payment date in the Spreadsheet?

Thank you so much for all your videos. Googlefinance is giving totally wrong price of REM (which is the ETF from iShares). For example now it’s giving 0.11 instead of 25.09. Maybe you could advice what might be the reason?

Two questions. I have multiple positions with stocks, and I sell off lower positions as price rises. Is there a spreadsheet that shows profit, loss on all positions held? And since I scalp trade, I need updates quicker than every 15 minutes. Currently using a plug-in that updates every 10 seconds for excel. Love what you’re doing it would definitely be a patron if these issues have been addressed.

Hey for the industry stock I don’t know if it’s just me but the link no longer works

HI

How to get dividend, industry for international Market like Hong Kong in google sheets

This is the same as excel correct?

Your portfolio tracker is awesome. I can download a copy by becoming a patreon member?

Hello, How to create Portfolio PE vs Market PE in spread sheet

I am having trouble with the industry formula. It comes up with an error: could not fetch url

What if you are getting dividends reinvested every quarter/month?

What if you bought shares at different prices, do you put in the average price? And the total amount of shares bought?

It says “resource at url not found” when trying to web scrape the industry name using the command you have in the description

The industry webstrapper doesnt work for me,. says url could not be fetched gives a N/A

hey mate. what can we do if the dividend in finviz is wrong? As apple is giving 0.23 not 0.92

How can we calculate the cost of stocks when selling some of them? This only works if we only buy, but selling and buying does not reflect the real cost

how do you put in that you sold a stock?

Top!!!

Hello does this spreadsheet work with Canadian stocks ans does it calculate the average cost of a stock when you buy the same stock at different period in time? Thanks for the answer, waiting for your answer to join your patreon.

Not sure if otherts have this issue but some of the formulas take very long to load. most of the times they stay on loading oe N/a. I dont think is the network speed but any ideas ?

Does this work for Crypto as well?

Does each holding need to be listed once? I dollar cost average per paycheck

great video!

Fabulous

Great video :)

8k coming soon???

hello, i use sharesight. What are the advantages of maaking your own exel?

Thanks for the video, very helpful!

The formula for getting the amount of dividends does not work for me. I don't know why, but I keep getting a syntax error (

Really appreciate it.

I like this video so much. Need to find time to create such excel files by myself

Thank you :)

YESSSSS