Dec 30 2021 03:08 PM
I'm to calculate current gain or loss from an initial investment with current value changing everyday. ie
1000 invested but day 1 is 1009, day 2 is 950. I want to use auto calculate but it pulls next box and not initial investment
Current Value | 4900 | 2690.66 | 2812.68 | 3878.34 | 4715.01 | ||||||||
Gain/Loss | -2209.34 | -2087.32 | -1021.66 | -184.99 | |||||||||
Current Price | 0.0843 | 0.0881 | 0.0867 | 0.0787 | |||||||||
Breakeven Price | 0.081532653 | 0.081532653 | 0.081532653 | 0.08153265 |
Dec 30 2021 06:35 PM
You're going to have to do a bit more to explain the situation. I do a lot with tracking my investments, but I am having a hard time making coherent sense of your description here. Can you take another pass at describing the details of the investment (I realize the $1,000 and other figures are just an example), but are you looking for an internal rate of return (where XIRR function might work for you) or just an absolute return based on today's value or each day's value....
Your description is just missing a lot of details. Which probably is why you've had over 40 views and no replies to date,
Dec 30 2021 07:26 PM
Jan 02 2022 06:49 AM
SolutionJan 02 2022 06:49 AM
Solution