Thanks for this update! I was lookking into what happened and tried both 9 and 10 but not 7. Moving forward, I'm substituting that table number value for a cell value from another sheet so that I can update one cell and all my formulas that call that table number will be updated with a single update.
Hi, great tracker, currently building something similar following your awesome design. Just wondering how do you know it is table 8? Where does it specify it's table 8? For example if I wanted to pull data from another site, how do I know which table # to pull from? Many thanks
How do you find out what table number a table is? If you see data you want to import, how do you find the path to import it? I am struggling to pull data from yahoo. Finviz does not cover a lot of canadian stocks.
Love the Video, I am excited to learn more now that I subscribed. I am from Canada and many of my Div funds are Canadian . The Finviz tables do not seem to work for Canadian stuff. How can we pull that info?
The tracker stopped reading the finviz table recently. It seemed to work again when I changed column F, G, and H in My Positions from _"Table", 8_ to _"Table", 7_ Keep the rest the same.
Ex-Div date isn't in same spot for all my tickers i guess..doesn't work.. on SCHD it's the expense ratio whereas on your example it's the right spot for aapl..any thoughts?
I made all spreedsheet too following all your steps that mention!. Excelent video!! Thanks for that!. Do you have something similar for options? Thanks!
I don't think I did wrong but couldn't get data for Industry. It said "Error Could not fetch url". Is there someone who can help with this? Appreciate you!
Hello. I am really new to this. I am the column "dividend yield". I have put in the instructions and get an Error message: "Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive." What's happening, also Where do you get the table number?
Awesome torturials, i cant get the dividend to load from the HTML :-( is it because they change the table number? can´t seem to guess the right number if thats the case :-(
Awesome, thanks for taking the time to put this together. I've been looking for something like this to document my dividend growth. My question is, if I wanted to keep track of the income the following year, do I just add new months in the data tab and label them 2022 and then just create another monthly dividend income chart for the new year? Thanks again!
Hello, thnKs for such informative video. looking for such content from months Finally found here. btw Finviz doens't have Indian stocks. do you recommend any particular website similar to finviz for indian stocks??
Hi im trying to make a canadian version as well, can you send me the formula that you used for Annual payout, payout ratio, Annual div income? Just a little stuck just because finviz doesnt support canadian stocks. Thanks!
Annual Div Income is just where you add your # of shares and annual payout so you can just manually add those 2 up.
3 года назад
trying to make a Canadian version as well, I haven't been able to make the formulas work for PE and yield. Changed ticker to multiple versions, tried yahoo, Gfinance, and other formulas, no luck. If you could provide the formulas you used that would be much, much appreciated!
hey @flipSSide97 ruclips.net/video/Q5yVoTqD06M/видео.html watch this video it will show how you can find what is the table number of table you want to find out. It works. Hope it helps.
@DLCShark The links in the discription for ex-dividend and industry dindn't work for some reason. I went back to the video to copy them individually and it all worked!
@@DLCShark Maybe it's because you use comma to delimit decimals. If it's true you need to substitute dot by comma. Like this =IF(ISBLANK(A2);"";SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTHTML("www.finviz.com/quote.ashx?t="&A2;"Table";8);8;2);"*";"");".";",")*1)
I copy paste =if(isblank(A2),"",GOOGLEFINANCE(A2,"Price")) from your description and I get an error #ERROR! I have no idea what I've done wrong I used the same Ticker AAPL as you, and I tried with my portfolio too
I am a Canadian investor and canadians stocks are not on Finviz (unless dual listed on American exchanges), would you know how to pull the date from another source?
If I could like this video a thousand times I would. I sat and created this whole spreadsheet with you. Thank you so much. It’s nice to actually have numbers to see how my investment are doing😊
@@christophermichael236 Hi sorry my computer crashed and I haven’t been able to get another one as yet. Are you sure you are following the step in the video accurately? Sometimes you just need to pause the video and look at the function to make sure it’s exactly the same. Spacing and everything. It also helps to write it on a piece of paper first then do it on your computer.
First of all, thank you for taking the time to teach us how to create this tracker. I have a question regarding the PAYOUT RATIO, the formula only worked on the 1st cell. On the remaining cells, I am getting #VALUE!. When I click on the cell with the error the following message pops up: Function MULTIPLY parameter 1 expects number values. But "-" is a text and cannot be coerced to a number. UPDATE: I just realized that all the tickers on my spreadsheet do not have any data for the Payout Ratio on the finviz table. I looked up each any every one and the Payout Ratio on the finviz table only shows a hyphen for all my tickers. Is there a way to hide the #VALUE! error message on all my cells? Thanks in advance.
Your sheet tutorials are the best. I have learned lots but still struggle with some things. Finviz doesn't seem to provide dividend data on preferred stock that I'm aware of. Any recommendation on how to pull that data if finviz doesn't have it? The stocks in particular I'm asking about is HT-d, rpt-d & rlj-a. Again thanks for you help and keep up the good work!
The ex-dividend formula doesn't work anymore. The error says "Resource at url not found." Also, the Industry info page on Fidelity has changed so that formula no longer works either.
This is great! Thanks. Any advice on easily finding the table number? I'm looking through the html and only counting 4 previous tables. Assuming they are buried, but wondering if you have a better trick?
If you want to know what the current table number is. 1) Once your on the webpage. Press f12 on your keyboard. 2) On the menu that pops up the right hand side of ur browser. Click on console. 3) Paste the following line into the console. var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); }); 4) All the tables on the webpage will come up and hover your mouse over them until the one you want is highlighted. 5) the number of the table will be next to it. :)
Thanks for sharing much appreciated. How does one deal with some UK stocks e.g. BT.A as a ticker symbol. In some case there is need to place the name of the exchange so one can get the required information. How do you do this?
You need to add an exchange reference to every ticker (or you could add the exchange reference in another cell as part of the same row). This data can then be used as needed to adjust the importhtml function based upon search requirements - for example yahoo finance uses .L at the end of a ticker reference for UK stocks. With BT-A and ex-dividend date, your ticker would be LON:BT-A (in cell C4 - for the example below). To pull other data for BT-A all you need to do is adjust the table (4), row (8), and column (2) values. =iferror(if(isblank(C4),"",index(importhtml("uk.finance.yahoo.com/quote/"®EXEXTRACT(C4,".*:(.*)")&if(regexmatch(C4,"LON:"),".L","")&"/key-statistics?p="®EXEXTRACT(C4,".*:(.*)")&if(regexmatch(C4,"LON:"),".L",""),"table",4),8,2)),"-")
I have the same question and am stuck with the Dividend Yield formula not working because the table number changed probably but I don't know how he knows this table number. Have you figured that out?
Thank you for helping! I have a question regarding the annual payout. This information is formated as a text and cannot be used in a formular in my sheet. Is there a trick to change that? Thank you!
Thanks for all the videos! Question from a newbie regarding Div. Yield. Shouldn't we calculate the yield base on our purchase price rather than the current price? Meaning the yield on our investment will stay the same regardless if the stocks current price. (assuming the dividend is the same). i.e. I buy a stock for $50 w/ $2 dividend. I get a 4% div yield. If the stock doubles, an you bought the stock your div yield would be 2% but I'm still at 4%. Or am I thinking of this wrong...? Thanks again!
That is a great question! And what you are thinking of is yield on cost! I posted a video a few months back regarding yield on cost and the difference between the two. So by all means you can have both yield on cost and dividend yield to see the growth
You can compute on historical cost yield or current price yield. It really depends on your preference but current price yield is usually more relevant since you can add or sell at current price.
Hi, thanks for sharing. Awesome formula. Somehow when I get to the Industry Breakdown, for the Market Value, it is only showing value on the 1st row. the rest is blank. And another thing is when you finished putting down the formula, it showed the autofill, mine did not. Any idea why it did not? Thanks!
Thank you for all information and work hard to update them. Would you do the "Keep Days" column and "Shares Outstanding" column? want to know how many days I keep the stock on my portfolio and How many Shares the company has. very appreciate your time.!
33:52 I'm not quite sure how can I put my annual income monthly since it's since I haven't getting paid for the rest of the year. The Ex-dividend and Market Value are not working. This is getting frustrating.
Great video man. Do you know how I can create projected income month by month or quarter by quarter based on DRIP in Google sheets? Do you know how I can set up a live sparkline that shows the performance of the entire portfolio? Thanks
This is pretty amazing. BRAVO! Quick question, maybe someone can answer. Hypothetical... what if a company stopped paying dividends? Then the Div Yield box would ERROR. How can that update to a 0.00% instead? And so forth? F (FORD) in my example gives the following error under Dividend Yield “ERROR - Function MULTIPLY parameter 1 expects number values. But “-“ is a text and cannot be coerced to a number.”
Just found your channel and love your spreadsheets. Question couldn’t you use your transactions sheet from your dark themed portfolio tracker to make this more automated? Just thinking it would be cool to enter your buys, sells, dividend income etc to have it update your positions and monthly income. Just a thought and would be awesome to see an updated dividend tracker spreadsheet. Thanks for the videos.
hi, trying to do this from australia, is there a way to make google finance pull data from Specific exchanges? its getting confused and pulling date from US companys with the same ticker as the Aus ones im trying to use]
I am getting this error message when trying to get div yield fromFINVIZ. How to fix?#REF! Function Index parameter 2 valid 8. Valid values are between 0 and 3 inclusive
How do you specify between stocks that are in USD or CAD? Also, when I add the formula to update the Market Price, I don't know where its getting the price but they are not what is showing on Google finance. Update - I notice the Google finance site, when I post Canadian tickers, it doesn't recognize that they are Canadian and changes to the American ticker and price, how can I fix this?
Hi! Nice work, thanks very much for this sharing. You've got another sub. If I just use "," in the formulas, nothing works. I had to replace it with ";". However, when I import data, it appears to be in text format and I cannot change it to currency. This situation does not allow me to multiply values such as Payout Racio by the number of shares. Can you help?
***FINVIZ UPDATE*** Hey Everyone, Finviz updated their code so now you need to pull from table 7 instead of table 8 like in the video!!!
Is there a way to change the code so that if there is an error a “-“ will appear instead of n/a or ref error? Thanks.
Thanks for this update! I was lookking into what happened and tried both 9 and 10 but not 7. Moving forward, I'm substituting that table number value for a cell value from another sheet so that I can update one cell and all my formulas that call that table number will be updated with a single update.
You are the man!!!!!
I having trouble in Industry column :(
can someone paste the formula here so we can just copy and paste? I keep getting errors
Is there an update on Fidelity industry code? Having trouble getting this to work.
great info, I'm getting an error in the dividend yeild part I can't get the data from finviz, it gives me an error, any guidance will be welcome
resource at url not found. :(
did the table move or is my CTRL C, CTRL V skills lacking?
Had the same issue. Check to be sure you have “ “ around the URL
I watch some of video not understand but your video is very clear & spot on thanks dude
Hi, great tracker, currently building something similar following your awesome design. Just wondering how do you know it is table 8? Where does it specify it's table 8? For example if I wanted to pull data from another site, how do I know which table # to pull from? Many thanks
Its table 9
@@fuccckckkkkckkck Awesome sauce. How do you know which table it is?
How do you find out what table number a table is? If you see data you want to import, how do you find the path to import it? I am struggling to pull data from yahoo. Finviz does not cover a lot of canadian stocks.
I am having a hell of a time with the formula working, I have changed out the numbers you spoke about but I keep getting errors, or ref.
Hi, how do you find out which table is?
Love the Video, I am excited to learn more now that I subscribed. I am from Canada and many of my Div funds are Canadian
. The Finviz tables do not seem to work for Canadian stuff. How can we pull that info?
The tracker stopped reading the finviz table recently. It seemed to work again when I changed column F, G, and H in My Positions from _"Table", 8_ to _"Table", 7_
Keep the rest the same.
Just stumbled across this and it has already been a lifesaver! Still trying to learn all the ropes. Thanks!
I am getting an error with the formulas that the, "Valid Values are from 0-3 inclusive". Can someone assist me with this?
EVERYTHING PASSED market value says "Resource at url not found." what do i do
If you used copy paste try typing it in by hand. Copy paste does not always work for some reason.
Even that didn’t work. Bummer
Thank you so much for sharing! this content is amazing, I created my own spreadsheet for tracking stocks and options, your video helped a lot!!
Glad to hear it!
Ex-Div date isn't in same spot for all my tickers i guess..doesn't work.. on SCHD it's the expense ratio whereas on your example it's the right spot for aapl..any thoughts?
The XML you're importing from Fidelity for Industry / Sector info doesnt work on all stocks because not all stocks show that info on the stock page.
I made all spreedsheet too following all your steps that mention!. Excelent video!! Thanks for that!. Do you have something similar for options? Thanks!
I don't think I did wrong but couldn't get data for Industry. It said "Error
Could not fetch url". Is there someone who can help with this? Appreciate you!
How does this work for canadian stocks on the Toronto Stock exchange? FinViz doesn't have some of my stocks I own.
You have to use Yahoo Finance
I was just trying to make the portfolio and when I do the code for table 7 or table 8 I get a #REF! error. Not sure what I am doing wrong.
Hello. I am really new to this. I am the column "dividend yield". I have put in the instructions and get an Error message: "Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive." What's happening, also Where do you get the table number?
Thank you.. Dividend Yield is Table 9 today.
Awesome torturials, i cant get the dividend to load from the HTML :-( is it because they change the table number? can´t seem to guess the right number if thats the case :-(
Awesome, thanks for taking the time to put this together. I've been looking for something like this to document my dividend growth. My question is, if I wanted to keep track of the income the following year, do I just add new months in the data tab and label them 2022 and then just create another monthly dividend income chart for the new year? Thanks again!
Hello,
thnKs for such informative video.
looking for such content from months Finally found here.
btw Finviz doens't have Indian stocks.
do you recommend any particular website similar to finviz for indian stocks??
I was able to create a Canadian version with your overall template! Thank you!
Thats awesome!
Hi im trying to make a canadian version as well, can you send me the formula that you used for Annual payout, payout ratio, Annual div income? Just a little stuck just because finviz doesnt support canadian stocks. Thanks!
Annual Div Income is just where you add your # of shares and annual payout so you can just manually add those 2 up.
trying to make a Canadian version as well, I haven't been able to make the formulas work for PE and yield. Changed ticker to multiple versions, tried yahoo, Gfinance, and other formulas, no luck. If you could provide the formulas you used that would be much, much appreciated!
Would you be willing to share your Canadian version with us, please? I haven't been able to get the one I am trying to build work. Thanks in advance!
I was looking for how to create tracking sheets like yours. Your video is super great 👍🏻 Thank you for so much.
This is great thank you! How do we know what "table" a table is if it changes?
hey @flipSSide97
ruclips.net/video/Q5yVoTqD06M/видео.html
watch this video it will show how you can find what is the table number of table you want to find out.
It works. Hope it helps.
I want so badly to make this sheet but the ex dividend date won’t work. Nor will the industry formula.
@DLCShark The links in the discription for ex-dividend and industry dindn't work for some reason. I went back to the video to copy them individually and it all worked!
@@DLCShark Maybe it's because you use comma to delimit decimals. If it's true you need to substitute dot by comma. Like this =IF(ISBLANK(A2);"";SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTHTML("www.finviz.com/quote.ashx?t="&A2;"Table";8);8;2);"*";"");".";",")*1)
@@CasualFlyer How did you input it for Industry because its the only part that doesn't work
This is a great video ! - any idea what table and from where for the ASX ( Aussie Stock Exchange )
I copy paste =if(isblank(A2),"",GOOGLEFINANCE(A2,"Price")) from your description and I get an error #ERROR! I have no idea what I've done wrong I used the same Ticker AAPL as you, and I tried with my portfolio too
hey still have 1 -2 questions, how does it go over several years and how can you add dividends already received?
Just incredible how you can design these spreadsheets and explain so that it is easy to understand. Going on to the next video...thanks.
Your videos and this whole channel are amazing !!
If I want to check the dividends let's say 5 years back how do you do that?
I am a Canadian investor and canadians stocks are not on Finviz (unless dual listed on American exchanges), would you know how to pull the date from another source?
I am having the same problem :(
Thanks again! You have a gift in teaching! Also, *1 works to destring the copied information so I can conditionally format them later.
Hey, I tried to put in AT&T but it does not show the "pay-out ratio", could you maybe help?
I did exactly as instructed, but it didn't work... :(
Beautiful. I loved it. I was looking for something like this exactly. Thank You!
Thanks for the great content. Hi from Texas
OH MY GOD I made an excel spreadsheet. Thanks!
What do you do when you put an ETF into your portfolio because the industry sector would be N/A
If I could like this video a thousand times I would. I sat and created this whole spreadsheet with you. Thank you so much. It’s nice to actually have numbers to see how my investment are doing😊
You're welcome and glad you liked it!!
I keep getting an error in column E, could you send me a copy of yours so I can see where I am going wrong?
@@christophermichael236 Hi sorry my computer crashed and I haven’t been able to get another one as yet. Are you sure you are following the step in the video accurately? Sometimes you just need to pause the video and look at the function to make sure it’s exactly the same. Spacing and everything. It also helps to write it on a piece of paper first then do it on your computer.
First of all, thank you for taking the time to teach us how to create this tracker. I have a question regarding the PAYOUT RATIO, the formula only worked on the 1st cell. On the remaining cells, I am getting #VALUE!. When I click on the cell with the error the following message pops up: Function MULTIPLY parameter 1 expects number values. But "-" is a text and cannot be coerced to a number. UPDATE: I just realized that all the tickers on my spreadsheet do not have any data for the Payout Ratio on the finviz table. I looked up each any every one and the Payout Ratio on the finviz table only shows a hyphen for all my tickers. Is there a way to hide the #VALUE! error message on all my cells? Thanks in advance.
Sure wish there was a Canadian version of this. Oh well, it looked nice and promising.
I fully agree, tried recreating my Canadian portfolio and realized it just wont work out.
Thank you so much, I was able to follow your instructions and create my own spreadsheets.
Nice!
i'm not sure why i'm having an issue. But receiving an N/A for all the codes i wanted to use. (resource at URL not found)
Me too.
same
Me as well - love the stuff you're putting up - helping me a ton! I'm assuming finviz changed the table but no idea really
As of jan 31st finviz is still pulling from table 8! Just checked
Same here
Great video! How would I get a Sector name for a ETF like VTI or ARKK?
Thanks! And thats a good question. I'll have to do some research and get back to you on that one!
@@ThinkStocks No problem and alright let me know when you find something on that! I'm in your discord too!
Your sheet tutorials are the best. I have learned lots but still struggle with some things. Finviz doesn't seem to provide dividend data on preferred stock that I'm aware of. Any recommendation on how to pull that data if finviz doesn't have it? The stocks in particular I'm asking about is HT-d, rpt-d & rlj-a. Again thanks for you help and keep up the good work!
I noticed that for some ETFs Yahoo Finance doesn't have a next dividend date, even if they pay dividends
The ex-dividend formula doesn't work anymore. The error says "Resource at url not found." Also, the Industry info page on Fidelity has changed so that formula no longer works either.
Great video. Could you please tell me how can I calculate dividends for the next 5-10 years? Thank you.
This is great! Thanks. Any advice on easily finding the table number? I'm looking through the html and only counting 4 previous tables. Assuming they are buried, but wondering if you have a better trick?
Thanks! And nope, it's just trial and error unfortunately! Lol
Have the same question..really trying and error?
If you want to know what the current table number is.
1) Once your on the webpage. Press f12 on your keyboard.
2) On the menu that pops up the right hand side of ur browser. Click on console.
3) Paste the following line into the console.
var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
4) All the tables on the webpage will come up and hover your mouse over them until the one you want is highlighted.
5) the number of the table will be next to it. :)
Thanks for sharing much appreciated. How does one deal with some UK stocks e.g. BT.A as a ticker symbol. In some case there is need to place the name of the exchange so one can get the required information. How do you do this?
You need to add an exchange reference to every ticker (or you could add the exchange reference in another cell as part of the same row). This data can then be used as needed to adjust the importhtml function based upon search requirements - for example yahoo finance uses .L at the end of a ticker reference for UK stocks.
With BT-A and ex-dividend date, your ticker would be LON:BT-A (in cell C4 - for the example below). To pull other data for BT-A all you need to do is adjust the table (4), row (8), and column (2) values.
=iferror(if(isblank(C4),"",index(importhtml("uk.finance.yahoo.com/quote/"®EXEXTRACT(C4,".*:(.*)")&if(regexmatch(C4,"LON:"),".L","")&"/key-statistics?p="®EXEXTRACT(C4,".*:(.*)")&if(regexmatch(C4,"LON:"),".L",""),"table",4),8,2)),"-")
Thanks for the amazing work 😍. But how do you know, what table it is? Where do you see that?
I have the same question and am stuck with the Dividend Yield formula not working because the table number changed probably but I don't know how he knows this table number. Have you figured that out?
Unfortunately "dividend yield", "dividend payout", and "payout ratio" formulas don't work. They return #REF! in the cells.
Great video especially thanks to types of functions
Thank you for helping! I have a question regarding the annual payout. This information is formated as a text and cannot be used in a formular in my sheet. Is there a trick to change that? Thank you!
It doesn't work anymore! Do you know a new formula for dividends?
Thanks for all the videos!
Question from a newbie regarding Div. Yield. Shouldn't we calculate the yield base on our purchase price rather than the current price? Meaning the yield on our investment will stay the same regardless if the stocks current price. (assuming the dividend is the same). i.e. I buy a stock for $50 w/ $2 dividend. I get a 4% div yield. If the stock doubles, an you bought the stock your div yield would be 2% but I'm still at 4%. Or am I thinking of this wrong...?
Thanks again!
That is a great question! And what you are thinking of is yield on cost! I posted a video a few months back regarding yield on cost and the difference between the two. So by all means you can have both yield on cost and dividend yield to see the growth
You can compute on historical cost yield or current price yield. It really depends on your preference but current price yield is usually more relevant since you can add or sell at current price.
Excellent tutorial. Exactly what I've been looking for. Thank you.
I can’t get anything out of finviz. No table number works (tried 1 to 11). Any ideas? BTW: great videos. I really like them
Currently it is table 8! You might have another error somewhere in the function if it isn't working
@@ThinkStocks it is also not working for me. I tried everything.
@@failindustry9816 same, I also tried american stocks just in case...
The formula for ex-dividend isn't working
My data takes long to load now. What methods can I use to speed it up?
the formula's that you are using wont work for me.
can u maybe help me with it?
Hi, thanks for sharing. Awesome formula. Somehow when I get to the Industry Breakdown, for the Market Value, it is only showing value on the 1st row. the rest is blank. And another thing is when you finished putting down the formula, it showed the autofill, mine did not. Any idea why it did not? Thanks!
Having same issue
works perfect! thank u so so much.
I've looked at 2 vids of yours and the ex dividend just doesnt work. All it says it resource at url is not found
same here :(
Can you track stock performance 5,10 years. And divident cagr 5 and 10 years? Do you know were to pull this data from?
That I have not figured out yet!
@@ThinkStocks Thanks for reply
Can you index funds instead of using only companies. - Thanks I would love that
Sure I can add that to the list!
@@ThinkStocks that would be awesome!
Thank you for all information and work hard to update them. Would you do the "Keep Days" column and "Shares Outstanding" column? want to know how many days I keep the stock on my portfolio and How many Shares the company has. very appreciate your time.!
33:52 I'm not quite sure how can I put my annual income monthly since it's since I haven't getting paid for the rest of the year.
The Ex-dividend and Market Value are not working. This is getting frustrating.
Great video man. Do you know how I can create projected income month by month or quarter by quarter based on DRIP in Google sheets? Do you know how I can set up a live sparkline that shows the performance of the entire portfolio? Thanks
Thanks! And so far no, I've been doing a lot of research on how to do that but so far no luck. When I figure out how ill be sure to post a video!
Thank You you save me two dayss
Bro this is awesome. Is there any way to link data to see my P/L for the day?
Where can the dividend income be pulled from for London FTSE stocks?
how can you copy these functions Like dividend ex date and such) or do we type it using your video?
This is pretty amazing. BRAVO!
Quick question, maybe someone can answer. Hypothetical... what if a company stopped paying dividends? Then the Div Yield box would ERROR. How can that update to a 0.00% instead? And so forth? F (FORD) in my example gives the following error under Dividend Yield
“ERROR - Function MULTIPLY parameter 1 expects number values. But “-“ is a text and cannot be coerced to a number.”
Yes! Add an iferror statement to say zero for companies who stock paying dividends!
Hi, what do I do if one of my stocks just did a reverse split? Thank you.
Just found your channel and love your spreadsheets. Question couldn’t you use your transactions sheet from your dark themed portfolio tracker to make this more automated? Just thinking it would be cool to enter your buys, sells, dividend income etc to have it update your positions and monthly income. Just a thought and would be awesome to see an updated dividend tracker spreadsheet. Thanks for the videos.
Awesome find with the sector info!
hi, trying to do this from australia, is there a way to make google finance pull data from Specific exchanges? its getting confused and pulling date from US companys with the same ticker as the Aus ones im trying to use]
How many stocks total can you have ?
Thanks for the vid
I am getting this error message when trying to get div yield fromFINVIZ. How to fix?#REF! Function Index parameter 2 valid 8. Valid values are between 0 and 3 inclusive
trying to pull from finviz but keep getting the argument error. I typed it in word for word not quite sure what is wrong
How come I cant pull the ex div date from yahoo finance?
Isn't this formula "annual dividend/share price = dividend yield"??? Does this one is accurate or not???
Thank you!!! You're AWESOME, I've subscribed. Can you do an options income tracker?
Thanks for the sub man! and that's on my list! I got a few more trackers coming out before that one!
Great video! What if I'm tracking things like SPHD and VDIGX in the same spreadsheet?
Why do I get resources at URL not found for ex-dividend date?
same here could you let me know if you figured it out
I get url not found for all inquiries
@@anddocster same did yall find the solution ?
@@matthewfaubla3240 I did. It had to with getting in the requisite periods and quotations.
@@anddocster what’s the requisite period😅
Great video can't wait to make my own
How do you specify between stocks that are in USD or CAD? Also, when I add the formula to update the Market Price, I don't know where its getting the price but they are not what is showing on Google finance. Update - I notice the Google finance site, when I post Canadian tickers, it doesn't recognize that they are Canadian and changes to the American ticker and price, how can I fix this?
Where did you plug in the numbers for the income on the data sheet?
Is there any way to do this with excel? Thanks for the video!
Hi! Nice work, thanks very much for this sharing. You've got another sub.
If I just use "," in the formulas, nothing works. I had to replace it with ";". However, when I import data, it appears to be in text format and I cannot change it to currency. This situation does not allow me to multiply values such as Payout Racio by the number of shares. Can you help?
I got the same...any solutions?
@@lukesaan you have to use a substitute indication. Show me the line code you got pls.
Fizniv is always so slow to pull up stats. Is there a more efficient way to get this data? Great tutorial otherwise.
Unfortunately finviz is the best answer at the moment. Been looking for something more efficient
Hi, When i am trying to copy the code and paste it into my sheets, it is not working tried a lot, is there a way can you share the sheet, thank you
Hi! Im trying to automate a dayly save of a cell to do a grafh, do you have a video about that?
Thank you so much!