I have to modify the CSV manually to use the right format.
It's work however I have other problems.
- In the CSV from IQ edge, one order or ticket is divided into several executions, and when I import them your website considers each execution as one ticket.
In the following example I place one buy order and one sell order but as you can see the CSV from IQ edge shows several executions. That's the reason why only the last sell execution has a commission of 4.95 . I don't think it makes sense to consider each execution as one ticket.
"Symbol","Action","Fill qty","Fill price","Exec time","Total value","Time placed","Commission"
"ONTX","Sell","100","1.3001","07/29/20 03:06:52PM","130.01","07/29/20 03:06:52PM","4.95"
"ONTX","Sell","400","1.30","07/29/20 03:06:52PM","520.00","07/29/20 03:06:52PM","0.00"
"ONTX","Sell","100","1.30","07/29/20 03:06:52PM","130.00","07/29/20 03:06:52PM","0.00"
"ONTX","Sell","100","1.30","07/29/20 03:06:52PM","130.00","07/29/20 03:06:52PM","0.00"
"ONTX","Sell","800","1.30","07/29/20 03:06:52PM","1,040.00","07/29/20 03:06:52PM","0.00"
"ONTX","Sell","100","1.30","07/29/20 03:06:52PM","130.00","07/29/20 03:06:52PM","0.00"
"ONTX","Sell","100","1.30","07/29/20 03:06:52PM","130.00","07/29/20 03:06:52PM","0.00"
"ONTX","Sell","300","1.30","07/29/20 03:06:52PM","390.00","07/29/20 03:06:52PM","0.00"
"ONTX","Buy","2,000","1.31","07/29/20 03:05:25PM","2,620.00","07/29/20 03:05:25PM","4.95"
- The other problem, when I choose Gross or Net in the dashboard and I click on filter, nothing changes (same behavior in the other sections such as calendar view or By symbol). However, Gross and Net value are displayed in the trade list.
Thank you for your help and your work !
Edited by user Wednesday, July 29, 2020 11:23:49 PM(UTC)
| Reason: Not specified