Gamestudio Links
Zorro Links
Newest Posts
Blobsculptor tools and objects download here
by NeoDumont. 03/28/24 03:01
Issue with Multi-Core WFO Training
by aliswee. 03/24/24 20:20
Why Zorro supports up to 72 cores?
by Edgar_Herrera. 03/23/24 21:41
Zorro Trader GPT
by TipmyPip. 03/06/24 09:27
VSCode instead of SED
by 3run. 03/01/24 19:06
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
5 registered members (Nymphodora, AndrewAMD, TipmyPip, Quad, Imhotep), 847 guests, and 4 spiders.
Key: Admin, Global Mod, Mod
Newest Members
sakolin, rajesh7827, juergen_wue, NITRO_FOREVER, jack0roses
19043 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
FXCM Y/E Recon for Taxes #439877
04/11/14 14:18
04/11/14 14:18
Joined: Jun 2013
Posts: 1,609
D
DdlV Offline OP
Serious User
DdlV  Offline OP
Serious User
D

Joined: Jun 2013
Posts: 1,609
Hi jcl.

It's tax filing time frown .

I just finished reconciling Zorro's trades.csv to FXCM's Combined Account Statement for last year. For more than 1/3 of the records the Profit Zorro posted to trades.csv needed to be corrected. Rollover figures were all exact.

Is this as expected? That trades.csv is not an accurate record and needs this much fix-up to be correct?

Thanks.

Re: FXCM Y/E Recon for Taxes [Re: DdlV] #439879
04/11/14 16:14
04/11/14 16:14
Joined: Jul 2000
Posts: 27,977
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,977
Frankfurt
trades.csv is an accurate record as to my knowledge.

However it is based on the trade profit retrieved from the broker's API, not on the FXCM account statement. Differences between the two may be due to account currency conversion or similar effects, but those differences should be very small.

Re: FXCM Y/E Recon for Taxes [Re: jcl] #439889
04/11/14 17:52
04/11/14 17:52
Joined: Jun 2013
Posts: 1,609
D
DdlV Offline OP
Serious User
DdlV  Offline OP
Serious User
D

Joined: Jun 2013
Posts: 1,609
Thanks jcl.

Not sure I understand what you're saying. Isn't the API returning Profit in the account's currency? I.e., already past any currency conversion...

(Not that FXCM's API can't have an error here too... laugh )

However: I'm using USD. trades.csv has many Profit values that have more than 2 decimal places (i.e., sub-cents). Why would this be?

Thanks.

Re: FXCM Y/E Recon for Taxes [Re: DdlV] #439970
04/14/14 06:19
04/14/14 06:19
Joined: Jul 2000
Posts: 27,977
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,977
Frankfurt
Yes, the API returns the profit in the account currency. It can apparently have more than 2 decimal places. I do not know the differences of FXCM's calculation of the profit in the account statement compared to the profit in the API, but a possible reason of small differences can be a different calculation method, a different currency conversion time, or simply a different rounding method.

Re: FXCM Y/E Recon for Taxes [Re: jcl] #439986
04/14/14 15:11
04/14/14 15:11
Joined: Jun 2013
Posts: 1,609
D
DdlV Offline OP
Serious User
DdlV  Offline OP
Serious User
D

Joined: Jun 2013
Posts: 1,609
Thanks jcl.

Hopefully this is an API bug that FXCM will fix someday... What they report in the API should match what appears on their Account Statements...

One other issue/question: The manual states the Profit in trades.csv includes Rollover. However, in my reconciliation to FXCM it does not. In other words, I had to add the Rollover in trades.csv to the Profit in trades.csv to equal the Net P/L in FXCM's Account Statement. Zorro's Profit in trades.csv equals the Gross P/L in FXCM's Account Statement. Could you please double-check the calculation of Profit in trades.csv vs. the manual?

Thanks.

Re: FXCM Y/E Recon for Taxes [Re: DdlV] #440031
04/16/14 08:20
04/16/14 08:20
Joined: Jul 2000
Posts: 27,977
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,977
Frankfurt
Yes, AFAIK the listed profit does not contain rollover, which is listed separately. I'll check the manual.


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1