hedgie
Board Regular
- Joined
- Jun 23, 2004
- Messages
- 174
- Office Version
- 365
- Platform
- Windows
Hope I can ask this in a way that makes sense.
I have a list of stock trades - I am looking to find out the annualized return of each trade - since there might be multiple buys and sells on different dates, I need to determine the PNl for each part of the trade and also determine the S&P 500 return for the same time period. The first three lines are a good sample. The next three is to demonstrate how the order of buys vs sells can vary. My spreadsheet has a large number of these trades so I am trying to figure out if I can do this with formulas vs having to manaully do each symbol as I did above.
I have a list of stock trades - I am looking to find out the annualized return of each trade - since there might be multiple buys and sells on different dates, I need to determine the PNl for each part of the trade and also determine the S&P 500 return for the same time period. The first three lines are a good sample. The next three is to demonstrate how the order of buys vs sells can vary. My spreadsheet has a large number of these trades so I am trying to figure out if I can do this with formulas vs having to manaully do each symbol as I did above.