Rob Am am not very familar with google spreadsheets but intrigued by your rebalancing spreadsheet. I followed, step by step, your video but do not know how to transfer the information from the holdings page to the asset class page to total up my amounts added in tot he holding page. Please help! Thanks.
Rob, I've been doing a simpler version by hand in Excel, so I know what invaluable gift you're making to all of us by sharing your spreadsheet for free. Thank you!
Wow! Thank you for sharing your knowledge and spreadsheet. This will definitely help me monitor my asset allocation for a multitude of investments with varying brokerage houses.
Thanks again for publishing this spreadsheet, Rob! I've been using it since you first published it. I just watched the video and I had already done the rebalance modification you did at the end of the video. I added one more modification that users might like. Under My Target, cell D10 in your example, I summed up the percentages so that you can easily make sure they add up to 100%. "=SUM(D5:D9)" in your example.
Nice spreadsheet! I've created my own tracking tool but didn't know how to pull prices in, this is very helpful! I'm retired, cash flow is important to track...do you have a tool that can automatically pull in dividends so current yield on cost is available? Thanks! Gary
How do you recommend adding a target date fund in this spreadsheet? I know this is an older video but i'll give it shot anyways :) The only thing I could think of is trying to add every ticker within the target date fund but not sure that data is entirely visible and likely changes frequently. Or, perhaps I should just omit those from the asset class worksheet as there really is no ability to re-balance within those accounts?
I just copied the spreadsheet .Thanks. But it doesn't have the change you made in this video where you added the Rebalance column. Is there another link that includes that change? Also, if I add more Asset Classes/Categories on the "Holdings" page, will their corresponding values be automatically picked up (for the allocation percentage calculations & pie charts) when I also add the additional Asset Classes to the "By Asset Class" page?
Thank you so much Rob! I have been looking for a spreadsheet that is simple and yet flexible enough to personalise. This is perfect! I have a question though... With the international entries, do I have to adjust the figures myself to accommodate the exchange rate (which constantly changes)?
This is in American Dollars if I'm not mistaken. How would you recommence this (fantastic) spread sheet be used for portfolios held in Canadian Dollars?
1. Shouldn't the "Category" column be shaded light green to match your format indicating it as a manual entry? 2. Is there a way to convert this to an Excel sheet and yet download prices, etc.? (Downloaded Google Sheets formulae don't translate into Excel :(
How do I input a target date fund from my 401k for the company I work for (it does not have a ticker). The Fund Name is "Vanguard Fiduciary Trust Company Target Retirement 2050 Trust"
Love this spreadsheet Rob, but I am finding that Google fails to bring in the referenced data quite often. Just one ticker symbol that doesn't load makes ALL the formulas on the Asset Class worksheet produce nothing but N/As. Have you encountered this issue?
Hi Rob, I have some mutual funds and ETFs that are asset allocation with 60/40 splits like VBIAX and AOR. I created a new category and named it Stocks and Bonds. Any recommendations on how to track this category along with the individual US Stocks, International Stocks and Bonds? Also I’m having problems getting the Weighted and YTD columns to work after I added all my extra rows. Thanks for any recommendations.
Mr. Berger, Thanks for the information. After following your instructions. Upon entering new stocks everything went fine, except from 'Expense Ratio to Returns' columns. Why? the cut or copy paste function of the 'google finance formulas' do not process. I cannot find how to insert expense ratio formulas, etc. why? Is there some instructions on getting these values to populate into the sheet after entering new stocks? Please.
If I wanted to have track allocation % tracked for deferred and Roth separately and then the % for the entire portfolio , is there a way to modify your google sheet to achieve this?
Rob: The YTD figure does not seem to be accurate in the spreadsheet. Perhaps the formula has changed since it was originally created but I cannot figure out how to make it work correctly. It gives an inaccurate figure. Can you help?
Hi, Rob!! Thanks for all the valuable content you put out for investors. Just incredible! Question for you, do you know if there are any online tools where you can plug in your portfolio and it will create a pie chart and show sectors/industry weightings based on current market value?
Hey Bob. New listener here but really like what I've seen so far. One thing I am looking for is software that will allow me to compare the "End of Plan" results for my current portfolio [which I get through Fidelity] to the results if I changed the allocation- maybe 1 more conservative and 1 more aggressive- over the next 20 years. Anything like that available to individual investors? Thanks.
Thanks Rob - if I wanted to add the gain, I assume I could simple add two (or three) columns? Cost price, Gain/Loss, (Gain/Loss %)? Any tips or trip on how to do this?
Hi Rob, I know you're not in the business of providing tech support to your audience, but I thought I would run by you an issue I'm having with the hopes that there's a straightforward answer. I spent many hours tweaking your spreadsheet to fit my situation, and at some point, my cells for GoogleFinance Name and Price returned "N/A". When I hover on a Price cell (for example), I get the message "When evaluating GoogleFInance, the query for the symbol ''EWX' returned no data."I thought this might have to do with the Lookup column. I'm not really sure what that column does - I have it in my spreadsheet, but don't really understand it. Perhaps you know of a couple of troubleshooting avenues I can take. Thanks, Rose
I just tried EWX and it worked for me. Make sure you don't have any extra characters in the ticker cell and that the Google Finance function is referencing the correct cell.
@@rob_berger Thanks for your help, Rob. I wasn't able to fix it, per se, but I figured out how to restore an earlier (working) version. Thank you. Rose
Having a lot of trouble with asset class page. Video does not explain how to navigate it. Some of my positions just aren't transferring over to it from the Holdings page. Everything seems to be fine on Holdings page. I am using the old spreadsheet, not the new one with the stocks page.
Here's the spreadsheet: docs.google.com/spreadsheets/d/1TgS9I6k495XvBbUmjO7fzC05iAQM815Y7gbk2u2EbE0/edit#gid=208315194
Rob
Am am not very familar with google spreadsheets but intrigued by your rebalancing spreadsheet. I followed, step by step, your video but do not know how to transfer the information from the holdings page to the asset class page to total up my amounts added in tot he holding page. Please help! Thanks.
Is this usable only online? or can i download it and use like the excel sheet I'm using now?
How do you enter crypto on your spreadsheet?
I love that this is still helping people. Thank you Rob!
And for those reading these comments, you can thank Dan for the spreadsheet! He's the one that created it many years ago.
Thanks Dan!
Rob, I've been doing a simpler version by hand in Excel, so I know what invaluable gift you're making to all of us by sharing your spreadsheet for free. Thank you!
Wow! Thank you for sharing your knowledge and spreadsheet. This will definitely help me monitor my asset allocation for a multitude of investments with varying brokerage houses.
Rob, I sent you an email about finding a spreadsheet that can help me rebalance, and then today I found your video. I will give this a try. Thank you!
Thanks again for publishing this spreadsheet, Rob! I've been using it since you first published it. I just watched the video and I had already done the rebalance modification you did at the end of the video. I added one more modification that users might like. Under My Target, cell D10 in your example, I summed up the percentages so that you can easily make sure they add up to 100%. "=SUM(D5:D9)" in your example.
Nice! Thanks for sharing.
Awesome! Been thinking about building one for years now you saved my day!
So helpful! This is really all you need. Will be using it for years to come. Thanks!
Thanks a lot for the spreadsheet!!!!
Nice spreadsheet! I've created my own tracking tool but didn't know how to pull prices in, this is very helpful! I'm retired, cash flow is important to track...do you have a tool that can automatically pull in dividends so current yield on cost is available? Thanks! Gary
Sorry novice here is there a way to add a conversion formula to covert google finance dollar value to Canadian ?
How do you recommend adding a target date fund in this spreadsheet? I know this is an older video but i'll give it shot anyways :) The only thing I could think of is trying to add every ticker within the target date fund but not sure that data is entirely visible and likely changes frequently. Or, perhaps I should just omit those from the asset class worksheet as there really is no ability to re-balance within those accounts?
I just copied the spreadsheet .Thanks. But it doesn't have the change you made in this video where you added the Rebalance column. Is there another link that includes that change? Also, if I add more Asset Classes/Categories on the "Holdings" page, will their corresponding values be automatically picked up (for the allocation percentage calculations & pie charts) when I also add the additional Asset Classes to the "By Asset Class" page?
Thank you so much Rob!
I have been looking for a spreadsheet that is simple and yet flexible enough to personalise. This is perfect!
I have a question though...
With the international entries, do I have to adjust the figures myself to accommodate the exchange rate (which constantly changes)?
This is in American Dollars if I'm not mistaken. How would you recommence this (fantastic) spread sheet be used for portfolios held in Canadian Dollars?
1. Shouldn't the "Category" column be shaded light green to match your format indicating it as a manual entry? 2. Is there a way to convert this to an Excel sheet and yet download prices, etc.? (Downloaded Google Sheets formulae don't translate into Excel :(
Thank you Rob this is so helpful!
How do I input a target date fund from my 401k for the company I work for (it does not have a ticker). The Fund Name is
"Vanguard Fiduciary Trust Company Target
Retirement 2050 Trust"
This is great, thank you! Is there a way to calculate the rebalance amount via new contributions instead of selling shares? Thanks!!
Love this spreadsheet Rob, but I am finding that Google fails to bring in the referenced data quite often. Just one ticker symbol that doesn't load makes ALL the formulas on the Asset Class worksheet produce nothing but N/As. Have you encountered this issue?
FYI...the formulas are correct, because sometimes the whole thing works perfectly........
Hi Rob, I have some mutual funds and ETFs that are asset allocation with 60/40 splits like VBIAX and AOR. I created a new category and named it Stocks and Bonds. Any recommendations on how to track this category along with the individual US Stocks, International Stocks and Bonds? Also I’m having problems getting the Weighted and YTD columns to work after I added all my extra rows. Thanks for any recommendations.
Not sure why, but some of the changes in values stopped transferring over to the asset class page for me.
Mr. Berger, Thanks for the information. After following your instructions. Upon entering new stocks everything went fine, except from 'Expense Ratio to Returns' columns. Why? the cut or copy paste function of the 'google finance formulas' do not process. I cannot find how to insert expense ratio formulas, etc. why?
Is there some instructions on getting these values to populate into the sheet after entering new stocks?
Please.
Not a fan of google spread sheet too much work updating this info, do you know of any automated spreadsheets that update daily?
so helpful! thanks Rob! : )
If I wanted to have track allocation % tracked for deferred and Roth separately and then the % for the entire portfolio , is there a way to modify your google sheet to achieve this?
I had this sheet from some time now.
Rob: The YTD figure does not seem to be accurate in the spreadsheet. Perhaps the formula has changed since it was originally created but I cannot figure out how to make it work correctly. It gives an inaccurate figure. Can you help?
How do you enter Cash in holdings?
Hi, Rob!! Thanks for all the valuable content you put out for investors. Just incredible! Question for you, do you know if there are any online tools where you can plug in your portfolio and it will create a pie chart and show sectors/industry weightings based on current market value?
Thanks for the video. In your spreadsheet, how do you categorize a fund like Vanguard Wellington which has US stock, International stock and bonds?
You have to break it up into multiple rows. Same would be true with a target date retirement fund. Not ideal, but it can work.
Hey Bob. New listener here but really like what I've seen so far. One thing I am looking for is software that will allow me to compare the "End of Plan" results for my current portfolio [which I get through Fidelity] to the results if I changed the allocation- maybe 1 more conservative and 1 more aggressive- over the next 20 years. Anything like that available to individual investors? Thanks.
Great video Rob!!
Thanks Rob - if I wanted to add the gain, I assume I could simple add two (or three) columns? Cost price, Gain/Loss, (Gain/Loss %)? Any tips or trip on how to do this?
That's what I do. I total a gain column.
Hi Rob,
I know you're not in the business of providing tech support to your audience, but I thought I would run by you an issue I'm having with the hopes that there's a straightforward answer. I spent many hours tweaking your spreadsheet to fit my situation, and at some point, my cells for GoogleFinance Name and Price returned "N/A". When I hover on a Price cell (for example), I get the message "When evaluating GoogleFInance, the query for the symbol ''EWX' returned no data."I thought this might have to do with the Lookup column. I'm not really sure what that column does - I have it in my spreadsheet, but don't really understand it. Perhaps you know of a couple of troubleshooting avenues I can take. Thanks, Rose
I just tried EWX and it worked for me. Make sure you don't have any extra characters in the ticker cell and that the Google Finance function is referencing the correct cell.
@@rob_berger Thanks for your help, Rob. I wasn't able to fix it, per se, but I figured out how to restore an earlier (working) version. Thank you. Rose
Having a lot of trouble with asset class page. Video does not explain how to navigate it. Some of my positions just aren't transferring over to it from the Holdings page. Everything seems to be fine on Holdings page. I am using the old spreadsheet, not the new one with the stocks page.