Home
Welcome Guest! You can not login or register.
Options
Go to last post Go to first unread
rhodanis  
#1 Posted : Tuesday, July 28, 2020 7:52:49 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

Hi,
I can't import csv from IQ edge even if I follow the QuesTrade IQ Edge Trading Journal Import procedure. Could you please help me ?

Example of the CSV, I get from IQ edge:
"Symbol","Action","Fill qty","Fill price","Exec time","Total value","Time placed","Account",
"OCGN","Sell","2","0.7397","28 juil. 2020 03:35:49 ","1.48","28 juil. 2020 03:35:49 ","xxxxxx - Margin",
"OCGN","Sell","2,998","0.7355","28 juil. 2020 03:35:49 ","2,205.03","28 juil. 2020 03:35:49 ","xxxxxx - Margin",

Thank you
Sponsor

TraderMichael  
#2 Posted : Wednesday, July 29, 2020 9:18:42 PM(UTC)
TraderMichael

Rank: Administration

Joined: 5/29/2018(UTC)
Posts: 114
United States

Thanks: 3 times
Was thanked: 8 time(s) in 7 post(s)
Having a look right now. I'll keep you posted!
rhodanis  
#3 Posted : Wednesday, July 29, 2020 9:22:14 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

Thank you
TraderMichael  
#4 Posted : Wednesday, July 29, 2020 9:26:17 PM(UTC)
TraderMichael

Rank: Administration

Joined: 5/29/2018(UTC)
Posts: 114
United States

Thanks: 3 times
Was thanked: 8 time(s) in 7 post(s)
For the dates in your file you've got this format:
28 juil. 2020 11:07:19

Is this a different language? "juil" is definitely not uniform. Any idea what juil is?
rhodanis  
#5 Posted : Wednesday, July 29, 2020 9:29:32 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

Yes, it's a french language. I think IQ edge uses the date format of my computer. I can't modify this in the software.
rhodanis  
#6 Posted : Wednesday, July 29, 2020 9:51:45 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

What's the date format I should use ?
Thanks
TraderMichael  
#7 Posted : Wednesday, July 29, 2020 9:59:06 PM(UTC)
TraderMichael

Rank: Administration

Joined: 5/29/2018(UTC)
Posts: 114
United States

Thanks: 3 times
Was thanked: 8 time(s) in 7 post(s)
Ah, makes sense. The preferred format is "10/12/18 10:06:58AM". I'm sure I could make it work with French but that's a whole other issue... That one would probably take some time to figure out how to handle cleanly. Are you able to just use the month numbers?
rhodanis  
#8 Posted : Wednesday, July 29, 2020 10:59:01 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

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

TraderMichael  
#9 Posted : Thursday, July 30, 2020 4:15:00 PM(UTC)
TraderMichael

Rank: Administration

Joined: 5/29/2018(UTC)
Posts: 114
United States

Thanks: 3 times
Was thanked: 8 time(s) in 7 post(s)
The manually thing isn't really sustainable. I'll try and make it work for your date format. The multiple tickets thing is going to take some pondering on my part... how to address that. I'll have a look at the gross/net issue. Thank you for the heads up. Will keep you posted on these. Trade safe!

Michael
TraderMichael  
#10 Posted : Thursday, July 30, 2020 4:45:37 PM(UTC)
TraderMichael

Rank: Administration

Joined: 5/29/2018(UTC)
Posts: 114
United States

Thanks: 3 times
Was thanked: 8 time(s) in 7 post(s)
Go ahead and try your file as is... French. I believe that part should be addressed.

Thanks,
Michael
rhodanis  
#11 Posted : Thursday, July 30, 2020 8:36:22 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

Hi TraderMichael,
Thank you very much, I can now import the CSV from IQedge without any manual modification. It's great.
About the multiple tickets, I can add a column in the exported CSV with the Order ID. The Order ID is a number and it's the same number for each ticket from the same order. Maybe, it can help you...
Thanks,
rhodanis  
#12 Posted : Friday, July 31, 2020 10:05:17 PM(UTC)
rhodanis

Rank: Newbie

Joined: 6/28/2020(UTC)
Posts: 7

Hi Michael,
you will find below an example of CSV with order ID column:
"Symbol","Action","Fill qty","Fill price","Order ID","Exec time","Total value","Commission",
"EMAN","Sell","200","1.0700","679 121 911","31 juil. 2020 03:57:29 PM","214.00","4.9500",
"EMAN","Sell","200","1.0700","679 121 911","31 juil. 2020 03:57:29 PM","214.00","0.0000",
"EMAN","Sell","100","1.0700","679 121 911","31 juil. 2020 03:57:29 PM","107.00","0.0000",
"EMAN","Sell","200","1.0700","679 121 911","31 juil. 2020 03:57:29 PM","214.00","0.0000",
"EMAN","Sell","300","1.0700","679 121 911","31 juil. 2020 03:57:29 PM","321.00","0.0000",
"EMAN","Buy","204","1.1000","679 080 317","31 juil. 2020 03:24:25 PM","224.40","4.9500",
"EMAN","Buy","100","1.1000","679 080 317","31 juil. 2020 03:24:25 PM","110.00","0.0000",
"EMAN","Buy","596","1.1000","679 080 317","31 juil. 2020 03:24:25 PM","655.60","0.0000",
"EMAN","Buy","100","1.1000","679 080 317","31 juil. 2020 03:24:25 PM","110.00","0.0000",

I hope this help you.
Thanks
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error


Follow Us on Social Media
YouTube - FaceBook - Twitter - Instagram - LinkedIn