Help with DCA template

Out of my depth here in excel world! A cry for help from excel savvy folk…

E3 should be around $375? I assume the problem is with the formulae in E3. Does Peter’s formulae there only work for $100 buys?

I’ve got basic excel skills but this is a stumbling block. Anyone able to help a brother out? Cheers, BrettRobin

3 Likes

You can use the forumla to (=D3*E2) and just put the number of shares you bought in D3 instead of the number of shares per $100 dollars. I just put the number of shares I bought at the amount I invested.

Hope this helps.

4 Likes

I looked at the original Google Sheet and it is for per $100.
i modified the cell formula to something below. You would have to change the header to something like “Shares per Investment”

4 Likes

Thats exactly what I did.

4 Likes

Thanks @JosephD and @Tracker great to find such friendly, helpful folk at the pub, cheers, B

4 Likes

anytime Bro - that’s why I am here as well. Great community.

4 Likes

No prob! Happy to help. Spreadsheets and data analytics is what i do at work. Hahaha

4 Likes

💰 YEN · YouTube ·️ YEN.CAMP 🧠