Is there a way to look at the historical performance of a paper trading account like I can look at the performance of a strategy backtest?
If not, is there a way to export a daily view of the account equity, open positions, etc.?
Is there any way to configure a paper account for margin trading?
Size:
Color:
Size:
Color:
Eugene,
1. Note that TradeFile shares, account number, Strategy ID, and scale are not exported to ExportedTradeHistoryFromAccounts.csv with the other trade data. A csv with all included would be helpful as so only the desired trades could be easily modeled
2. If possible an option to get American date format in the csv file (m/d/yyyy hh:mm:ss or similar) would be good. I run this data thru "Historical Trades: splits, cash flow, multiple files, shared equity" using an Excel reformatted csv today. It allows all time stamps to process on daily bars.
A separate csv creator with those two extra capabilities would also work.
Size:
Color:
Kevin,
Correct. The objective is to create a SimTradeFile2-compatible CSV file to be parsed by the internal routine. The Scale does get exported but as StrategyID may be empty it's not considered.
Thanks for pointing me at the omission of Shares. Although it's an optional field, I'm going to add support for it. This should prevent from liquidating entire position in a symbol which takes place now. Likewise, you're making a good point re: filtering by Account. An optional parameter to ImportHistoricalTrades() will add such capability for TradeFileImportMode.AccountsFile.
As to the custom date format, I'm not sure why it might be needed. Couldn't HistoricalTrades detect and support "dd-MM-yyyy HH:mm:ss" or whatever is there in the resulting CSV? Just keep in mind that a timestamp with "00:00:00" indicates EOD data (see comment in the CreateCsvFileFromAccountsXml() code).
Size:
Color:
Please see Post #11 for my suggested method to process the TradeHistory.xml data.
https://www.wealth-lab.com/Forum/Posts/Historical-Trades-splits-cash-flow-multiple-files-shared-equity-39101QUOTE:
This should prevent from liquidating entire position in a symbol which takes place now.
Adding shares will enable share entry but will not prevent liquidating the entire position. Only Historical Trades does splits.
ImportHistoricalTrades reads the date by requiring the the matching format string. Some users wishing to edit the csv file to include only certain trades will find it difficult - that's what I needed to do. A typical date in ExportHistoricalTrades.csv is "07-01-2015 12:00:42" which in US culture is read as July, 1 when it is really Jan, 7. If the csv is opened in Excel it sees that wrong date via local culture and dates with day > 12 are considered text. Historical Trades uses local system culture so like Excel it cannot read it. I used format "G" in the code linked above with an option to provide a user preferred format.
Shares, account, scale and strategy are all usable in the Historical Trades link above. In addition position splits and stock splits are automatic. Editable ImportHistoricalTrades data can also be created.
Size:
Color:
QUOTE:
A typical date in ExportHistoricalTrades.csv is "07-01-2015 12:00:42" which in US culture is read as July, 1 when it is really Jan, 7. If the csv is opened in Excel it sees that wrong date via local culture and dates with day > 12 are considered text.
Makes sense. With an optional parameter to
ImportHistoricalTrades(), starting from in v2018.07 you'll be able to output to ExportHistoricalTrades.csv using an arbitrary
DateTime format.
Size:
Color:
Thanks, Eugene.
Size:
Color:
@KGo
As requested, support for reading the
Share property and filtering by
AccountName when importing Wealth-Lab's Accounts tool history has been added to C.Components 2018.07. On method syntax please check out the revamped documentation which I hope should read more clear now:
Import real (historical) trades
Size:
Color:
Thanks again, Eugene. I continue to use Historical Trades (post #5 above) as it provides shares, trade selection by Account, Scale and strategy combinations.Plus one entry can be sold in multiple lots and price series splits require no manual price adjustment.
Size:
Color: