Modifying capital values

[j1404]

Scenario is that capital is being added monthly to IB account and I want to keep P&L up to date. When the capital is updated from IB after the deposit, max capital correctly reflects the added amount but accumulated shows artificial gain. With "$SCRIPT_PATH/interactive_update_capital_manual" I can delete capital values from the date the deposit was made and then with option "4: Modify any/all values" I can add back correct accumulated and maximum capital values. This works as long as I make the adjustment immediately after the deposit.

The problem is when I can't make the capital adjustments immediately. Let's say I made a deposit week ago. If I do "5: Delete values of capital since time T", i.e. delete all values since the deposit day, I lose history for the week. If I modify capital values, I can fix the accumulated to be correct as of now but this leaves the artificial gain for the week. Is there a way to selectively delete historical capital values, e.g. of a given day, and respectively add back historical values?

[robcarver17]

"Is there a way to selectively delete historical capital values, e.g. of a given day, and respectively add back historical values?"

Not from the command line

from sysproduction.data.capital import dataCapital
d = dataCapital()
capital_series = d.db_capital_data.get_df_of_all_global_capital()
### manually edit capital_series, columns 'Actual', 'Accumulated' and 'Broker'
d.db_capital_data.update_df_of_all_global_capita(capital_series)

Note - of course this means your capital scaling will be slightly out for the relevant week.