Stock Calculation
Budget: $15 – $25 USD
I want to create a spreadsheet that calculates stock losses at 3 different price levels, with a maximum loss of $300-$600. For example = Buy $5k of AMZN at $2,910/share, buy $15k if price drops to $2,860/share and buy a final $10k at $2,815/share. Then if price continues to decline, I would sell all $30k at $2,800share. The 1st purchase results in a $189 loss, the 2nd purchase results in a $315 loss, and the last position results in a $53 loss, or a total of $556.
Not sure, but I think the ability to change all variables including Buy or sell, stock price, amount invested at each tier, and the total loss amount will be necessary since I will be buying or selling different priced stocks. Also, the $300-$600 will limit the space between tier levels so the amount invested at each tier may need to vary to meet the maximum loss amount.
Not sure, but I think the ability to change all variables including Buy or sell, stock price, amount invested at each tier, and the total loss amount will be necessary since I will be buying or selling different priced stocks. Also, the $300-$600 will limit the space between tier levels so the amount invested at each tier may need to vary to meet the maximum loss amount.