Shifting the decimal place?

Questions about MultiCharts and user contributed studies.
Splint
Posts: 96
Joined: Nov 25 2011
Has thanked: 12 times
Been thanked: 1 time

Apr 29 2012

Hi,

IB provides Japanese Yen data in the form 0.012303 and my EOD data provider can give the data to only 4 digits to the right of the DP. To trade I would have to use the end of day data which would drop the last two digits to get 0.0123. My data provider can give me data in the form 1.2303, is there any way MC could convert it to 0.012303.

My other alternative is to use EOD data for backtesting and download historical data from IB for trading.

Thanks
Splint

sptrader
Posts: 742
Joined: Apr 09 2010
Location: Texas
Has thanked: 483 times
Been thanked: 274 times
Contact:

Apr 29 2012

Maybe Multiply the number by .01 (or divide it by 100) in MC....

Splint
Posts: 96
Joined: Nov 25 2011
Has thanked: 12 times
Been thanked: 1 time

Apr 30 2012

Maybe Multiply the number by .01 (or divide it by 100) in MC....
I do recall a thread where the MC programmers were looking at doing that, not sure if that functionality has been brought into the software yet. I would need to be able to use it for auto trading. Do you know if this can actually be done?

User avatar
Henry MultiСharts
Posts: 9165
Joined: Aug 25 2011
Has thanked: 1264 times
Been thanked: 2958 times

Apr 30 2012

Hello Splint,

If you are using ASCII import or ASCII mapping you can multiply the price of your original file. The price will be imported into QuoteManager or plotted in MultiCharts according to your Multiplier choice.