Suggestion - $DXC no more free - workaround ?

[tspielmann]

Hello,

I just noticedthat the $DXC USD CASH INDEX moved from being free into a option in a other package (97$/month)

as this index is very useful for FX traders and it's only a simple calculation of 6 underlying currencies, would it be possible to generate it "on the fly" (or as a free add-on to FX data subscribers by eSignal) therefore ? ( If a capable programmer could do that within a few hours, please get in contact with me)

(as FX feed is already subscribed)

Any thoughts / comments / help would be greatly appreciated !

Attached Doc gives the overview how it's calculated.

[ACM]

tspielmann

as this index is very useful for FX traders and it's only a simple calculation of 6 underlying currencies, would it be possible to generate it "on the fly" (or as a free add-on to FX data subscribers by eSignal) therefore ?

You may be able to do that using the Spread Symbols Settings tool and creating your own symbol based on the equation of the Dollar Index.
For instructions on how to use the Spread Symbols Settings tool see this article in the eSignal KnowledgeBase
Alex

[eSignal_AveryH]

To help you get the formula correct I have added the percentages for each currency that makes up the Dollar Index.


I hope this helps.

Euro EUR 0.576
Japanese Yen JPY 0.136
British Pound GBP 0.119
Canadian Dollar CAD 0.091
Swedish Krona SEK 0.042
Swiss France CHF 0.036


AveryH
eSignal Support

[tspielmann]

Calculation

Hi Guys,

many thanks for your helpful answers !
Just one left now, please see attached for the full formula. Is it possible to use the the needed power function (or only the 4 basic operations).

Many thanks !
Torsten

P.S. as this finally will need some time to compute - and I am sure that lots of FX feed subscribers would be interested in - would it be possible to offer this computed index based on the formula directly by eSignal ?

Again thanks !

[eSignal_AveryH]

Hi All,
By using the Spread Symbols Settings tool you can create your own symbol based on the equation of the Dollar Index. Below we have provided the equation to help create your custom spread. Please highlight and copy the formula below into the Spread Symbol Tool. For instructions on how to use the Spread Symbols Settings tool see
this article in the eSignal KnowledgeBase.


50.14348112 * ((EUR A0-FX * .576) + (JPY A0-FX * .136) + (GBP A0-FX * .119) + (CAD A0-FX * .091) + (SEK A0-FX * .042) + (CHF A0-FX * .036))


AveryH
eSignal Support

[tspielmann]

Dear Avery,

many thanks, unfortunately it's not the muliplication with the factor which is needed, but the POWER (a^b) function !
If the POWER function is used it will result in the very same amount as on the official NYBOT DXC.

Is there any way to do this ?

Regards
Torsten

Originally posted by ahodgee
Hi All,
By using the Spread Symbols Settings tool you can create your own symbol based on the equation of the Dollar Index. Below we have provided the equation to help create your custom spread. Please highlight and copy the formula below into the Spread Symbol Tool. For instructions on how to use the Spread Symbols Settings tool see
this article in the eSignal KnowledgeBase.


50.14348112 * ((EUR A0-FX * .576) + (JPY A0-FX * .136) + (GBP A0-FX * .119) + (CAD A0-FX * .091) + (SEK A0-FX * .042) + (CHF A0-FX * .036))


AveryH
eSignal Support

[buhrmaster]

You could always create an EFS with the currencies as inputs and use the exponential function in the javascript math library. The problem of course is that you can only use it as a study on an advanced chart, not in a quote window.

[buhrmaster]

There is another quick and dirty solution(?), which will track DXC but over time will drift, namely convert the exponential weights to linear weights:

solve for x

EUR A0-FX * X = EUR A0-FX ^ .576

and plug that in as the linear weight in the Spread Symbol window.

Finally, if you have Excel creating a DDE connection with Signal and recreating DXC is easy to do.

[buhrmaster]

I just noticed that there are CME$INDEX futures that have an underlying index, Symbol: UX A0, that is probably available under the GLOBEX feed or certainly under CME feed.

The index appears to be highly correlated with DX A0, and indeed may be an improvement.

[tspielmann]

CME$

Hi,

the CME$ is slightly different in its calculation, it's taking different weightings, see my initial post at the beginning, in the graphic the DX and CME are shown.

Thanks for the input !