Simple Investing Calculator in Google Sheets
Budget: $10 – $30 USD
I'm looking for an experienced Google Sheets expert to create a straightforward investing calculator for me. The calculator should primarily focus on Dollar-Cost Averaging (DCA) over a 12 month period.
Every month we will purchase four ETFs (VTV, VO, XLK, IYW) for each of the four individuals here with a monthly allocation that is 1/12 of the starting available investment for that person. That amount will be adjusted based on the weighing strategy. We want to retain a balanced portfolio with 25% in each ETF.
We also want to use a weighted buyout so that if the value of a particular ETF is lower that month, we will consider it "on sale" and buy more shares. When that happens, we need to recalculate the available funds remaining to invest. We want to be able to commit these trades during hours.
Our trading platform does not allow for fractional shares off hours, so the spreadsheet also needs to calculate the number of shares of each ETF to purchase, round this up to the next whole number and then use this as the basis to adjust the remaining funds available to invest.
We will rebalance the portfolio annually, which is at the end of this DCA strategy, so this the calculator does not need to address any rebalancing. The calculator only needs to work over a 12 month period. The weighting should use an adjustment that takes the average price of the ETF over the trailing 3 months and divides that by the current price of that ETF.
Ideal candidate should have a strong understanding of investment calculations, particularly DCA, and be proficient in Google Sheets. Prior experience in creating financial calculators is a plus.
Every month we will purchase four ETFs (VTV, VO, XLK, IYW) for each of the four individuals here with a monthly allocation that is 1/12 of the starting available investment for that person. That amount will be adjusted based on the weighing strategy. We want to retain a balanced portfolio with 25% in each ETF.
We also want to use a weighted buyout so that if the value of a particular ETF is lower that month, we will consider it "on sale" and buy more shares. When that happens, we need to recalculate the available funds remaining to invest. We want to be able to commit these trades during hours.
Our trading platform does not allow for fractional shares off hours, so the spreadsheet also needs to calculate the number of shares of each ETF to purchase, round this up to the next whole number and then use this as the basis to adjust the remaining funds available to invest.
We will rebalance the portfolio annually, which is at the end of this DCA strategy, so this the calculator does not need to address any rebalancing. The calculator only needs to work over a 12 month period. The weighting should use an adjustment that takes the average price of the ETF over the trailing 3 months and divides that by the current price of that ETF.
Ideal candidate should have a strong understanding of investment calculations, particularly DCA, and be proficient in Google Sheets. Prior experience in creating financial calculators is a plus.