Edit PnL History

[andycare]

Hi,

it would be great if it would be possible to edit the lines in the PnL Tab. At least being able to delete a line would also help.

The reasong for requesting that is, that I was holding DELL during the recently made split between DELL and VMW. So the log tells me, that I had a 50% loss on the DELL position, but it missed that I got VMW shares in exchange. Therefore, I see a drop in the equity curve, which didn't exist.

Furthermore, it would be great, if I could export the PnL history as CSV (or similar) in order to make further analysises.

Thanks and best regards
Andreas

[admin]

Hi,

it would be great if it would be possible to edit the lines in the PnL Tab. At least being able to delete a line would also help.

The reasong for requesting that is, that I was holding DELL during the recently made split between DELL and VMW. So the log tells me, that I had a 50% loss on the DELL position, but it missed that I got VMW shares in exchange. Therefore, I see a drop in the equity curve, which didn't exist.

Furthermore, it would be great, if I could export the PnL history as CSV (or similar) in order to make further analysises.

Thanks and best regards
Andreas

These are both great ideas. I don't have a timeline on when these will be ready, but the PnL data is stored using SQLite and is very easy to access.

In the meantime, I suggest you manually modify the APM database files yourself.
You can download a SQLite DB browser here: https://sqlitebrowser.org/
The database file is located at AccountName>databases>strategyStats.db
If you edit the StrategyAllocations table and adjust the PnL value for the day of the DELL split, then it should show up correctly in APM. Make sure APM is closed when you do this.
Note that you should save a copy of the .db file and then modify it in case something goes wrong. Otherwise, you risk losing all your data.

For exporting the data as a CSV, you can use Python to read the table from the database and export it as a CSV file (using the Pandas library).

[andycare]

These are both great ideas. I don't have a timeline on when these will be ready, but the PnL data is stored using SQLite and is very easy to access.

In the meantime, I suggest you manually modify the APM database files yourself.
You can download a SQLite DB browser here: https://sqlitebrowser.org/
The database file is located at AccountName>databases>strategyStats.db
If you edit the StrategyAllocations table and adjust the PnL value for the day of the DELL split, then it should show up correctly in APM. Make sure APM is closed when you do this.
Note that you should save a copy of the .db file and then modify it in case something goes wrong. Otherwise, you risk losing all your data.

For exporting the data as a CSV, you can use Python to read the table from the database and export it as a CSV file (using the Pandas library).

Thank you for these tips. It worked perfectly. For me this solution would already be fine