Hi,

The below mentioned row is from the table closed_trade_list. Could somebody please explain why the conversion rate in the last column is 1. Shouldn't it be 0.0105xxx as the USD/JPY is traded in JPY and the conversion rate from JPY to USD should apply for converting the p/l? The full report is attached in the zip.

<row>
<column name="ID1">2</column>
<column name="Q2">20461016</column>
<column name="W3">903736</column>
<column name="E4">USD</column>
<column name="R5">10000</column>
<column name="T6">59316598</column>
<column name="Y7" />
<column name="U8">1</column>
<column name="I9">USD</column>
<column name="O10">07/30/2009 07:10:17</column>
<column name="P11">95.129</column>
<column name="A12">07/30/2009 06:47:58</column>
<column name="S13">95.071</column>
<column name="D14">-6.1</column>
<column name="F15">0</column>
<column name="G16">0</column>
<column name="H17">0</column>
<column name="J18">-6.1</column>
<column name="K19">10000</column>
<column name="L20">2</column>
<column name="INTR21">0</column>
<column name="PNL22">-6.1</column>
<column name="COMM23">0</column>
<column name="ADJ24">0</column>
<column name="Q25">JPY</column>
<column name="Q26">USD</column>
<column name="Q27">3</column>
<column name="Q28">Mkt</column>
<column name="Q29">C</column>
<column name="Q32">d3905940001</column>
<column name="Q33">d3905940001</column>
<column name="Q34">2009-07-30</column>
<column name="CONVERT_RATE">1</column>
</row>

Thanks

Attached Files

00903736.zip (3.7 KB, 2 views)

Guys,

It appears that the conversion rates reported in xml reports are wrong. Earlier I referred data from closed_trade_list. I further studied the reports and here are few of the example that I am referring from table open_floating_positions (first 2 are correct while last 2 are not):

EUR/GBP Short, 10K, 0.85291/0.85400, p/l -18.05, conv rate 1.655905. Calculation: 10000*(0.85291-0.854)*1.655905 = -18.05

EUR/USD Long, 10K, 1.43709/1.41334, p/l -237.50, conv rate 1. Calculation: 10000*(1.41334-1.43709)*1 = -237.50

USD/JPY Long, 30K, 94.504/94.660, p/l 49.44, conv rate 1. Calcuation: 30000*(94.66-94.504)*1 = 4680.00

USD/CHF Long, 30K, 1.07801/1.07531, p/l -75.33, conv rate 1. Calculation: 30000*(1.07531-1.07801)*1 = -81

Could somebody comment?

Thanks

Hi,

It seems to be a real error in case when 'Account currency' == 'First currency in pair'.

Btw, why you need CONVERT_RATE value, it's kind of redundant information, you can always calculate it back from open/close rate and pnl.

Thanks

Not only when 'Account currency' == 'First currency in pair', but it occurs on other crosses as well, for example on EUR/JPY cross, the conversion rate is reported as 94.6601.

We can calculate it from the pnl, but that will give a conversion rate based on the rounded pnl. That may differ at 4th or 5th or 6th decimal place (depending on situation) from the original conversion rate.

For backoffice record keeping, I was looking for the original conversion rate that was applied at the time of conversion/trade. But now I will have to calculate it as the conversion rates are not correct.

Thanks