Anyone else's rebalancing spreadsheet tab work?

#1

I just downloaded the excel spreadsheet from the course and trying to use the rebalancing spreadsheet but the stock prices don’t automatically update like it states on the instructions. Does anyone else have this issue?

#2

Hi Jae,
It seems to be working for me. What are you seeing?

image
image710×314 27.9 KB

1 Like
#3

Hi Vivi,

When I change the ticker symbols to what I have in my portfolio and the respective weight, the share prices don’t update. And in the formula I see =IFERROR(_xludf.DUMMYFUNCTION(“GOOGLEFINANCE(B2,”“price”")"), 193.99)

Any idea on how to fix this?

#4

Try changing the formula to =GOOGLEFINANCE(B2, “price”) … does that work?

#5

No it does not work. It’s ok I’ll just figure it out. Thanks!

#6

I’m looking for this spreadsheet on the site. Any guidance where to find it? I completed by course and ready to start entering the data but I don’t know where to find it!!!

#7

Hi Lisa,
You can find it here: