Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 12:42:03 +0000



Currency conversion problems on the TAL

View Count: 939

[2018-12-21 11:04:47]
User343901 - Posts: 66
Version 1852 appears to have bugs with currency conversions as displayed on the TAL.

When Common Profit Loss currency set to any value other than NONE the calculated totals in the trade activity log are incorrect when choosing a non [SIM] symbol.

This is seen on SIM and LIVE trade data.

Screen shots attached.

Steps to reproduce:

Close sim trade in EURUSD
Set Common Profit Loss to GBP
Set P/L Format to Currency Value

In Trade Activity Log
Choose Trades tab:
Symbol "[SIM]EURUSD" shows correct total (eg: 60.08GBP)
Symbol "EURUSD" shows incorrect total and with double currency suffix(eg: 48.02GBPGBP)

Choose Statistics tab:
Symbol "[SIM]EURUSD" shows correct values with no GBP suffix
Symbol "EURUSD" shows all values as incorrect and with a GBP suffix

Choose Period Stats tab:
Same issues as above.

Note that tick values do not change between symbols "[SIM]EURUSD" and "EURUSD" and appear correct.

My guess is there is a double currency conversion taking place somewhere in the code.

Can you please investigate and confirm.
Date Time Of Last Edit: 2018-12-21 11:06:54
imageTAL 1.png / V - Attached On 2018-12-21 11:03:47 UTC - Size: 111.64 KB - 262 views
imageTAL 2.png / V - Attached On 2018-12-21 11:03:53 UTC - Size: 90.92 KB - 265 views
[2018-12-21 11:05:19]
User343901 - Posts: 66
Additional images attached
imageTAL 3.png / V - Attached On 2018-12-21 11:05:03 UTC - Size: 121.58 KB - 292 views
imageTAL 4.png / V - Attached On 2018-12-21 11:05:08 UTC - Size: 137.44 KB - 278 views
[2018-12-21 12:11:37]
User343901 - Posts: 66
I think I have found further issues with this.

On the Trades tab for both "[SIM]EURUSD" and "EURUSD" when setting the P/L Format to Ticks or Points the totals are not correct and have a currency suffix. Screen shot attached.

This all seems a bit of a mess right now.

Can you please confirm.

Just to be clear I would expect to see total ticks if P/L Format is set to ticks and total points if set to points. I would only want to see total currency if P/L Format is set to currency.
Date Time Of Last Edit: 2018-12-21 12:47:42
imageTAL 5.png / V - Attached On 2018-12-21 12:11:29 UTC - Size: 96.48 KB - 279 views
[2018-12-21 23:02:33]
Sierra Chart Engineering - Posts: 104368
We are resolving these issues now. There are just a couple of minor details which is leading to the issues.

There is a fair amount of complexity with how all of this works and it is just a couple of minor details.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2018-12-21 23:28:12]
User343901 - Posts: 66
Thanks for getting on it!
[2019-01-02 21:06:52]
User343901 - Posts: 66
Hi support

I'm still finding problems with incorrect values in the TAL when Common Profit/Loss Currency is set to any value other than NONE and the symbol quote currency is not USD eg USDJPY or USDCAD

Statistics tab:
Set symbol to [sim]USDJPY
Set P/L Format to Currency Value and all values appear correct
Set P/L Format to any of the Currency Value & Point/Ticks options and all values are incorrect

Trades tab:
Same as above
Also Symbol Profit/Loss column final value is always zero which is wrong

Period Stats tab:
Same as above

Can you please investigate thoroughly as it is dissapointing to still be having issues like this.
[2019-01-02 22:58:29]
Sierra Chart Engineering - Posts: 104368
We have given this some thought, and there is no support for converting to a common currency and also displaying the profit/loss values in ticks or some other format. That has never been supported and we decline to add support for this.

But we will make sure it is not even possible to use one of those modes in this case.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2019-01-02 22:58:37
[2019-01-02 23:19:27]
User343901 - Posts: 66
I don't know what you're referring to.

I have attached screenshots showing the garbage data that is being output when common profit loss currency is set to GBP and the symbol is USDJPY.

Thoughts?
image01.png / V - Attached On 2019-01-02 23:15:59 UTC - Size: 134.82 KB - 257 views
image02.png / V - Attached On 2019-01-02 23:16:03 UTC - Size: 114 KB - 283 views
image03.png / V - Attached On 2019-01-02 23:16:07 UTC - Size: 139.27 KB - 254 views
[2019-01-03 03:21:46]
Sierra Chart Engineering - Posts: 104368
Okay, we do understand the nature of the problem and we are going to make some changes but when using a common currency setting and you are using a profit/loss format that shows a currency value and another format, that other format is just going to be wrong and you need to disregard it.

We thought about not showing it, but that is going to cause much more disruption to our user base so we are not going to do that. We will just make a note of it in the documentation.

Also please do not refer to the result as "garbage".
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2019-01-03 03:32:56
[2019-01-03 08:11:50]
User343901 - Posts: 66
I'm not sure you do understand it. If you look at image "02.png" it shows the values in ticks only. These values are all wrong and is a result of the Common Profit Loss Currency being set to a value not equal to NONE and the symbol being quoted in JPY. This has nothing to do with the "Currency and Ticks" display options.

Note that when the symbol is quoted in USD the TAL shows the correct values in all cases even when using the "Currency and Ticks" display options! So it does work just not always - which suggests both a coding problem and a testing problem.

Note that I am also seeing inconsistent results between USDCAD and USDJPY

Below is a grid showing the very varied results I am seeing. Can you please review and confirm?

Common Profit Loss Currency = GBP
Symbol = USD quoted (eg EURUSD)
TAL P/L Format = ANY OPTION
RESULT = ALL VALUES CORRECT

Common Profit Loss Currency = GBP
Symbol = USDJPY or USDCAD
TAL P/L Format = "Currency"
RESULT = ALL VALUES CORRECT

Common Profit Loss Currency = GBP
Symbol = USDJPY
TAL P/L Format = Ticks, Points, or Currency & Ticks/Points
RESULT = ALL VALUES INCORRECT

Common Profit Loss Currency = GBP
Symbol = USDCAD
TAL P/L Format = Ticks or Points
RESULT = ALL VALUES CORRECT

Common Profit Loss Currency = GBP
Symbol = USDCAD
TAL P/L Format = Currency & Ticks/Points
RESULT = CURRENCY INCORRECT BUT TICKS/POINTS CORRECT
Date Time Of Last Edit: 2019-01-03 09:29:34
[2019-01-03 09:01:49]
User343901 - Posts: 66
To add to the above when trading USDJPY while using GBP as the common profit loss currency and setting the following:

Chart Setting > Advanced Settings > Profit/Loss Format = Currency Value & Points/Ticks

The values shown on the chart trading widgets are all correct. As the calculation is done correctly in this instance I don't understand how your statement in post #9 can be valid.
Date Time Of Last Edit: 2019-01-03 09:25:45
[2019-01-03 10:40:47]
User343901 - Posts: 66
More problems with USDJPY this time on the Chart Stats Tab. I have attached screenshots.

Note that Common Profit Loss Currency is set to USD

When the P/L Format is set to "Currency Value" the values I think are being shown in JPY which is wrong. The total of the Open P/L column is shown in USD and is correct and matches that shown in the trade window.

When the P/L Format is set to "Currency Value and Ticks" the values are shown in USD which is correct and the tick values are correct too. Again the total of the Open P/L column is shown in USD and is correct and matches that shown in the trade window.

So this is almost the inverse of the problems found in the other tabs.
Date Time Of Last Edit: 2019-01-03 11:01:50
imageUSDJPY-01.png / V - Attached On 2019-01-03 10:40:38 UTC - Size: 119.08 KB - 252 views
imageUSDJPY-02.png / V - Attached On 2019-01-03 10:40:42 UTC - Size: 139.15 KB - 272 views
[2019-01-05 03:47:37]
Sierra Chart Engineering - Posts: 104368
If you look at image "02.png" it shows the values in ticks only. These values are all wrong and is a result of the Common Profit Loss Currency being set to a value not equal to NONE and the symbol being quoted in JPY.
You misunderstood what we meant. This has been resolved. Use version 1856. Also the only way now to display the common currency in the Trade Activity Log is by using the profit/loss format that says "Currency Value".

The other formats no longer support it even if they have currency value in their name, in the case of the Trade Activity Log. So the final result is a little different than what we stated in our prior post.

And we did discover a problem where there was a double currency conversion occurring in some cases like in the case where two formats are displayed at once. And that is been fixed.

The values shown on the chart trading widgets are all correct. As the calculation is done correctly in this instance I don't understand how your statement in post #9 can be valid.
There is a significant internal difference in the way that the common currency is implemented in a chart compared to the Trade Activity Log.

We will have to look at post #12 a little later on.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2019-01-05 03:49:38
[2019-01-05 14:19:21]
User343901 - Posts: 66
I have re-reviewed these issues on 1856 and there are still obvious problems.

In brief:
1. "ticks or points ignore quantity" are being totalled incorrectly which I assume is throwing out all the values in the Statistics tab
2. on Trades tab "currency value & ticks or points" do now show correctly as common currency alonside Tick values which is great and directly contradicts your statement above. So you've proven it is possible to have converted currency alongside ticks/points. Bizarrely though the total is now shown in the symbol quote currency.

See the attached image where I have put together the different tabs in one image for clarity.

Aside from fixing the errors all I want as a user is a simple and consistent view of the data. Setting an option such as P/L Format should show the data absolutely consistently in all areas of the program without exception. There is no reason for this not to be the case. Sierra is a great package overall but the TAL falls well below the standard I would expect from professional software.
imageTAL v1856.jpg / V - Attached On 2019-01-05 14:19:12 UTC - Size: 528.76 KB - 274 views
[2019-01-10 08:28:47]
User343901 - Posts: 66
Hi support

Have you been able to look into the issues I pointed out in posts #12 and #14?

The current version (v1857) does not allow a view of the per symbol profit loss in the common currency in the chart stats tab. In your comments above you stated P/L Format -> Currency Value should show all values in the common currency. This worked fine several versions back. Can you please reinstate this functionality?

Also the "ticks/points ignore quantity" totals on the trades tab are still being summed incorrectly. Can you please confirm? Will this be fixed? I have attached a screenshot.
imageTrades v1857.png / V - Attached On 2019-01-10 08:27:52 UTC - Size: 83.26 KB - 259 views
[2019-01-11 22:17:42]
Sierra Chart Engineering - Posts: 104368
We have been looking this over and have restored the ability to support common currency on the chart trade stats tab.


Also the "ticks/points ignore quantity" totals on the trades tab are still being summed incorrectly. Can you please confirm? Will this be fixed? I have attached a screenshot.
This has been resolved. Use the prerelease.

Setting an option such as P/L Format should show the data absolutely consistently in all areas of the program without exception. There is no reason for this not to be the case.
There are reasons and this cannot be the case consistently.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2019-01-12 01:41:02

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account