Hi!
I have a bit complicated problem I can't seem to figure out.
This is the data I have
| Company Name | Round | Investment | Share price 1 | Share price 2 |
| x | 1 | 100 | 3 | 3 |
| x | 2 | 200 | 3 | 4 |
| x | 3 | 300 | 3 | 5 |
This is the output I want, where I want to adjust the new shareprice compared to the "last round" except for the first round:
| Company Name | Round | Investment | Share price 1 | Share price 2 |
| x | 1 | 100 * 3/3 | 3 | 3 |
| z | 2 | 200*4/4 + 100*4/3 | 3 | 4 |
| y | 3 | 300 *5/5 + 200 *5/4 + 100*5/3 | 3 | 5 |
