Dukascopy
 
 
Wiki JStore Search Login

Attention! Read the forum rules carefully before posting a topic.

    Try to find an answer in Wiki before asking a question.
    Submit programming questions in this forum only.
    Off topics are strictly forbidden.

Any topics which do not satisfy these rules will be deleted.

Explanation of convertPipToCurrency() Output
 Post subject: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Thu 12 Apr, 2012, 14:06 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
Can someone please explain the output of the function convertPipToCurrency()?

I understand that it converts the cost of one pip to a specified currency, perhaps the account currency. But how many units of currency does this assume? Is it providing a pip cost relative to 1000 units of currency?

Thanks,

Brad


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Thu 12 Apr, 2012, 15:01 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
bradhallett wrote:
Can someone please explain the output of the function convertPipToCurrency()?
The amount is Instrument.getPipValue() converted to the respective currency. See if the following example helps understand the outputs:
https://www.dukascopy.com/wiki/#JForex_utils/Conversion_of_pip_cost_-_multiple_currencies_and_instruments
bradhallett wrote:
But how many units of currency does this assume?
in JForex API amount 1 stands for 1 million, see:
https://www.dukascopy.com/wiki/#Order_Amounts


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Fri 13 Apr, 2012, 03:18 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
The following is my lot calculation for money management:

lots = (utils.convertPipToCurrency(instrument, account.getCurrency())/instrument.getPipValue())*(account.getBalance()*maxRisk/Math.abs(entryPrice-stopLossPrice)/1000000);


This calculation works find on pairs whose secondary currency is USD (EUR/USD, GBP/USD, etc), but does not work well otherwise (eg. USD/JPY). Is there something wrong with my code?

maxRisk is set to 0.02 but on the JPY pair, for example, the total amount of the account balance risked is a lot less in testing.

Thanks,


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Fri 13 Apr, 2012, 07:34 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
If there is some mistake in the JFUtils.convertPipToCurrency calculation results, then please provide a precise case, describe what results you receive and what you expected instead.


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Fri 13 Apr, 2012, 12:14 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
console.getOut().println(utils.convertPipToCurrency(instrument, account.getCurrency())/instrument.getPipValue());


Using the code above, I am getting the correct conversion rate of the second currency to the account currency. It doesn't seem like this is the issue. I am completely lost as to where my lot sizing problem is.


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Fri 13 Apr, 2012, 12:23 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
Resolving the algorithm is up to you. Logging relevant values (as, for example, it is done here) might facilitate the task.


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Fri 13 Apr, 2012, 19:20 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
I have determined that the issue here is not my algorithm, but rather an issue with the historical backtester and the function convertPipToCurrency().

I have been testing this using the following code:
console.getOut().println(instrument.name()+" "+utils.convertPipToCurrency(instrument, account.getCurrency())/instrument.getPipValue());


The above listed code shows the conversion rate between the second currency in the pair and the account currency. Eg. in the case of EUR/JPY testing on a USD account, the result is the rate of JPY/USD.

Based on my testing, the calculation of utils.convertPipToCurrency() does not work well during the historical tester depending on which currency pairs are being tested. The calculation works perfectly during live trading. During backtesting, however, depending on which symbols are being tested, the output is mostly incorrect. Even when all currency pairs are being tested at once, the historical tester produces incorrect results.

For example, the conversion output on a USD backtest with all symbols being tested shows:
2012-04-13 18:13:07 AUDSGD 1.0 (Suggesting that there is a 1.0 exchange rate for SGD/USD)
2012-04-13 18:13:08 XAUUSD 0.8014393851357038
2012-04-13 18:13:08 AUDUSD 0.8014393851357039 (Suggesting that USD/USD is not 1.0)


Is there a proposed solution for this or should I be reporting this as a bug?


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Mon 16 Apr, 2012, 15:31 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
Could you please provide the full example strategy and the launch scenario?


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 1   New post Posted: Mon 16 Apr, 2012, 22:34 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
The code to demonstrate this error is as follows:
package jforex;

import java.util.*;

import com.dukascopy.api.*;

public class ErrorDemo implements IStrategy {
    private IAccount account;
    private IEngine engine;
    private IConsole console;
    private IHistory history;
    private IContext context;
    private IIndicators indicators;
    private IUserInterface userInterface;
    private JFUtils utils;
   
    public void onStart(IContext context) throws JFException {
        this.account = context.getAccount();
        this.engine = context.getEngine();
        this.console = context.getConsole();
        this.history = context.getHistory();
        this.context = context;
        this.indicators = context.getIndicators();
        this.userInterface = context.getUserInterface();
        this.utils = context.getUtils();
    }

    public void onAccount(IAccount account) throws JFException {
    }

    public void onMessage(IMessage message) throws JFException {
    }

    public void onStop() throws JFException {
    }

    public void onTick(Instrument instrument, ITick tick) throws JFException {
    }
   
    public void onBar(Instrument instrument, Period period, IBar askBar, IBar bidBar) throws JFException {
        if (period.equals(Period.ONE_MIN)) {
             console.getOut().println(instrument.name()+" "+utils.convertPipToCurrency(instrument, account.getCurrency())/instrument.getPipValue());
        }
    }
}


While testing on the EUR/USD for the Intraday period with Tick data for all ticks, output is as follows:
Quote:
21:16:37 EURUSD 1.0


While testing on the EUR/USD and USD/JPY for the Intraday period with Tick data for all ticks, output is as follows:
Quote:
2012-04-16 21:18:34 USDJPY 1.0
2012-04-16 21:18:34 EURUSD 0.012430698853889565
2012-04-16 21:18:34 USDJPY 1.0


While testing on all available symbols for the Intraday period with Tick data for all ticks, output is as follows:
Quote:
21:22:49 AUDUSD 1.0
21:22:49 USDMXN 0.07573692023387561
21:22:49 USDSGD 0.8010092716823196
21:22:49 GBPCAD 1.000250062515629
21:22:49 EURUSD 1.0
21:22:49 NZDCHF 1.0930753675465925
21:22:49 GBPCHF 1.0930753675465925
21:22:49 AUDCAD 1.000250062515629
21:22:49 USDCHF 1.0930753675465925
21:22:49 AUDJPY 0.012430698853889565
21:22:49 USDNOK 0.174092434378033
21:22:49 EURCHF 1.0930753675465925
21:22:49 EURNZD 0.82028
21:22:49 AUDSGD 0.8010092716823196
21:22:49 CADCHF 1.0930753675465925
21:22:49 NZDCAD 1.000250062515629
21:22:49 EURDKK 0.17660356032777622
21:22:49 EURAUD 1.03558
21:22:49 GBPNZD 0.82028
21:22:49 XAUUSD 1.0
21:22:49 USDZAR 0.12607097291491218
21:22:49 EURHKD 0.12889828700621483
21:22:49 HKDJPY 0.012430698853889565
21:22:49 USDSEK 0.14789333341220978
21:22:49 EURSEK 0.14789333341220978
21:22:49 EURGBP 1.58965
21:22:49 NZDJPY 0.012430698853889565
21:22:49 CADJPY 0.012430698853889565
21:22:49 EURSGD 0.8010092716823196
21:22:49 AUDNZD 0.82028
21:22:49 GBPAUD 1.03558
21:22:49 NZDUSD 1.0
21:22:49 XAGUSD 1.0
21:22:49 EURNOK 0.174092434378033
21:22:49 CHFSGD 0.8010092716823196
21:22:49 AUDCHF 1.0930753675465925
21:22:49 USDDKK 0.17660356032777622
21:22:49 USDHKD 0.12889828700621483
21:22:49 USDJPY 0.012430698853889565
21:22:49 GBPUSD 1.0
21:22:49 CHFJPY 0.012430698853889565
21:22:49 USDCAD 1.000250062515629
21:22:49 EURCAD 1.000250062515629
21:22:49 GBPJPY 0.012430698853889565
21:22:49 EURJPY 0.012430698853889565
21:22:49 CADHKD 0.12889828700621483


Finally, while running this strategy live, the correct calculations are produced (CAD pairs show a conversion of 1.0 as I have a CAD account):
Quote:
21:28:59 XAUUSD 0.9998396085189892
21:28:59 XAGUSD 0.9998396085189892
21:28:59 USDZAR 0.12608794891597275
21:28:59 USDSGD 0.8009577855724277
21:28:59 USDSEK 0.14779562329410786
21:28:59 USDNOK 0.17389754895896736
21:28:59 USDMXN 0.07563869982838527
21:28:59 USDJPY 0.012429477611155867
21:28:59 USDHKD 0.12887944017635974
21:28:59 USDDKK 0.17657008944162036
21:28:59 USDCHF 1.0928104582550364
21:28:59 USDCAD 1.0
21:28:59 NZDUSD 0.9998552986991788
21:28:59 NZDJPY 0.012429765085959901
21:28:59 NZDCHF 1.0928055993884842
21:28:59 NZDCAD 1.0
21:28:59 HKDJPY 0.012429130487475909
21:28:59 GBPUSD 0.9998396085189891
21:28:59 GBPNZD 0.8200413217811184
21:28:59 GBPJPY 0.01242913048747591
21:28:59 GBPCHF 1.092774894304472
21:28:59 GBPCAD 1.0
21:28:59 GBPAUD 1.0354316347600654
21:28:59 EURUSD 0.9998233378499252
21:28:59 EURSGD 0.800953089215477
21:28:59 EURSEK 0.14780005484087314
21:28:59 EURNZD 0.8200510241561881
21:28:59 EURNOK 0.1738836144937993
21:28:59 EURJPY 0.012429255426857255
21:28:59 EURHKD 0.12888187522691458
21:28:59 EURGBP 1.5896050000000002
21:28:59 EURDKK 0.17656769260292388
21:28:59 EURCHF 1.0928736907203631
21:28:59 EURCAD 1.0
21:28:59 EURAUD 1.035458545052485
21:28:59 CHFSGD 0.8009989952864524
21:28:59 CHFJPY 0.012429054427320799
21:28:59 CADJPY 0.012429385553325173
21:28:59 CADHKD 0.12885858993910787
21:28:59 CADCHF 1.092890202785777
21:28:59 AUDUSD 0.9998132864309623
21:28:59 AUDSGD 0.8009682142451529
21:28:59 AUDNZD 0.8200431905469547
21:28:59 AUDCHF 1.0927519376494683
21:28:59 AUDCAD 1.0
21:28:59 AUDJPY 0.01242836127760785


Since this produces the correct figures in a live environment, I am lead to believe this is a bug with the historical tester.


Attachments:
File comment: Compiled strategy to demonstrate error.
ErrorDemo.jfx [2.88 KiB]
Downloaded 310 times
File comment: Java file for strategy.
ErrorDemo.java [1.37 KiB]
Downloaded 298 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 17 Apr, 2012, 10:52 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
bradhallett wrote:
While testing on the EUR/USD and USD/JPY for the Intraday period with Tick data for all ticks, output is as follows:
Quote:
2012-04-16 21:18:34 USDJPY 1.0
2012-04-16 21:18:34 EURUSD 0.012430698853889565
2012-04-16 21:18:34 USDJPY 1.0


This does not seem to be the case:
Image

Other tests we carried out with the following strategy:
package jforex.utils; 
 
import com.dukascopy.api.*;
 
public class ErrorDemo implements IStrategy {
    private JFUtils utils;
     
    public void onStart(IContext context) throws JFException {
        this.utils = context.getUtils();
       
        for(Instrument instrument : context.getSubscribedInstruments()){
            context.getConsole().getOut().println(instrument.name()+" "+
                    utils.convertPipToCurrency(instrument, context.getAccount().getCurrency())/instrument.getPipValue());
        }       
    }
 
    public void onAccount(IAccount account) throws JFException {    }
    public void onMessage(IMessage message) throws JFException {    }
    public void onStop() throws JFException {    }
    public void onTick(Instrument instrument, ITick tick) throws JFException {    }     
    public void onBar(Instrument instrument, Period period, IBar askBar, IBar bidBar) throws JFException {    }
}
We found all the values to be proper.


Attachments:
ErrorDemo_hist.png [32.38 KiB]
Downloaded 770 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 17 Apr, 2012, 12:27 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
Using your testing code from the previous post, I am still getting incorrect output. Perhaps this is a bug exclusive to Mac users?


Attachments:
Screen Shot 2012-04-17 at 7.23.59 AM.png [48.91 KiB]
Downloaded 450 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 17 Apr, 2012, 13:00 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
bradhallett wrote:
Perhaps this is a bug exclusive to Mac users?
Apparently not:

Image

Could you please provide screen shots of your Account and Custom Settings dialogs?
Also could you check what results you get when you choose a couple more instruments?


Attachments:
Screen shot 2012-04-17 at 2.57.22 PM.png [48.16 KiB]
Downloaded 781 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 17 Apr, 2012, 13:08 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
Could you please check what results does the following strategy yield?
package jforex.utils; 
 
import com.dukascopy.api.*;
 
public class ErrorDemo3 implements IStrategy {
    private JFUtils utils;
    private IHistory history;
    private IConsole console;
    private IAccount account;
     
    public void onStart(IContext context) throws JFException {
        this.utils = context.getUtils();
        this.console = context.getConsole();
        this.history = context.getHistory();
        this.account = context.getAccount();
       
        for(Instrument instrument : context.getSubscribedInstruments()){
            ITick tick = history.getLastTick(instrument);
            double pipCost = utils.convertPipToCurrency(instrument, account.getCurrency());
            double rate = pipCost /instrument.getPipValue();
            console.getOut().println(String.format("%s pipCost=%.8f, rate=%.5f, last tick: %s", instrument.name(), pipCost, rate, tick));
        }       
    }
 
    public void onAccount(IAccount account) throws JFException {    }
    public void onMessage(IMessage message) throws JFException {    }
    public void onStop() throws JFException {    }
    public void onTick(Instrument instrument, ITick tick) throws JFException {    }     
    public void onBar(Instrument instrument, Period period, IBar askBar, IBar bidBar) throws JFException {    }
}


Attachments:
ErrorDemo3.java [1.29 KiB]
Downloaded 304 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Wed 18 Apr, 2012, 00:34 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
The following is the output from the requested strategy:

Attachment:
Screen Shot 2012-04-17 at 7.29.50 PM.png [210.2 KiB]
Downloaded 453 times


Attachment:
Screen Shot 2012-04-17 at 7.30.01 PM.png [217.49 KiB]
Downloaded 438 times


Attachment:
Screen Shot 2012-04-17 at 7.30.13 PM.png [61.46 KiB]
Downloaded 468 times


Unfortunately, I cannot determine what is causing this error. Please help.

Thanks,

Brad


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Sun 22 Apr, 2012, 11:47 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
It looks as if the Historical Tester used a different account currency than that which gets selected, please try the following version:
package jforex.strategies; 
 
import java.util.Currency;
import java.util.HashSet;
import java.util.Set;

import com.dukascopy.api.*;
 
public class ErrorDemo4 implements IStrategy {
    private JFUtils utils;
    private IHistory history;
    private IConsole console;
    private IAccount account;
     
    public void onStart(IContext context) throws JFException {
        this.utils = context.getUtils();
        this.console = context.getConsole();
        this.history = context.getHistory();
        this.account = context.getAccount();
       
        Set<Currency> currencies = new HashSet<Currency>();
        currencies.add(account.getCurrency());
        currencies.add(Currency.getInstance("USD"));
        currencies.add(Currency.getInstance("EUR"));
        currencies.add(Currency.getInstance("JPY"));
       
        for(Currency currency: currencies){
            for(Instrument instrument : context.getSubscribedInstruments()){
                ITick tick = history.getLastTick(instrument);
                try{
                    double pipCost = utils.convertPipToCurrency(instrument, currency);
                    double rate = pipCost /instrument.getPipValue();
                    console.getOut().println(String.format("%s -> %s pipCost=%.8f, rate=%.5f, last tick: %s", instrument, currency, pipCost, rate, tick));
                } catch (JFException e){
                    console.getErr().println(e + " for " + instrument + " -> " + currency);
                }
            }   
        }
        console.getOut().println("account currency: " + account.getCurrency());
    }
 
    public void onAccount(IAccount account) throws JFException {    }
    public void onMessage(IMessage message) throws JFException {    }
    public void onStop() throws JFException {    }
    public void onTick(Instrument instrument, ITick tick) throws JFException {    }     
    public void onBar(Instrument instrument, Period period, IBar askBar, IBar bidBar) throws JFException {    }
}


Attachments:
ErrorDemo4.java [1.96 KiB]
Downloaded 314 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 24 Apr, 2012, 02:15 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
With all currencies selected, output is as follows:
Quote:
2012-04-24 01:14:11 account currency: USD
2012-04-24 01:14:11 CHF/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 87.792 / 87.768
2012-04-24 01:14:11 EUR/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 105.56 / 105.54
2012-04-24 01:14:11 EUR/CHF -> JPY pipCost=0.00877805, rate=87.78053, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.20257 / 1.20234
2012-04-24 01:14:11 EUR/DKK -> JPY pipCost=0.00141902, rate=14.19017, last tick: 1334534591416[2012-04-16 00:03:11.416+0000] / 7.4389 / 7.4379
2012-04-24 01:14:11 GBP/CHF -> JPY pipCost=0.00877810, rate=87.78105, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.46018 / 1.45968
2012-04-24 01:14:11 USD/CHF -> JPY pipCost=0.00877801, rate=87.78014, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.92194 / 0.92178
2012-04-24 01:14:11 NZD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 66.482 / 66.463
2012-04-24 01:14:11 EUR/SEK -> JPY pipCost=0.00118832, rate=11.88318, last tick: 1334534404343[2012-04-16 00:00:04.343+0000] / 8.88621 / 8.87875
2012-04-24 01:14:11 GBP/NZD -> JPY pipCost=0.00664686, rate=66.46863, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.92839 / 1.92769
2012-04-24 01:14:11 CAD/HKD -> JPY pipCost=0.00104296, rate=10.42957, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.76598 / 7.76382
2012-04-24 01:14:11 EUR/GBP -> JPY pipCost=0.01281564, rate=128.15636, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.8237 / 0.82354
2012-04-24 01:14:11 NZD/CHF -> JPY pipCost=0.00877817, rate=87.78166, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.75739 / 0.75708
2012-04-24 01:14:11 EUR/AUD -> JPY pipCost=0.00836676, rate=83.66762, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.26168 / 1.26145
2012-04-24 01:14:11 AUD/USD -> JPY pipCost=0.00809210, rate=80.92100, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.03403 / 1.03389
2012-04-24 01:14:11 AUD/SGD -> JPY pipCost=0.00647724, rate=64.77238, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.29201 / 1.29147
2012-04-24 01:14:11 EUR/NZD -> JPY pipCost=0.00664717, rate=66.47174, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58817 / 1.58768
2012-04-24 01:14:11 USD/MXN -> JPY pipCost=0.00061357, rate=6.13572, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 13.19363 / 13.18337
2012-04-24 01:14:11 GBP/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 128.171 / 128.146
2012-04-24 01:14:11 EUR/NOK -> JPY pipCost=0.00139460, rate=13.94602, last tick: 1334534402590[2012-04-16 00:00:02.590+0000] / 7.57196 / 7.56528
2012-04-24 01:14:11 XAU/USD -> JPY pipCost=0.80921000, rate=80.92100, last tick: 1334534401748[2012-04-16 00:00:01.748+0000] / 1653.087 / 1652.752
2012-04-24 01:14:11 NZD/USD -> JPY pipCost=0.00809210, rate=80.92100, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.82152 / 0.82135
2012-04-24 01:14:11 EUR/USD -> JPY pipCost=0.00809210, rate=80.92100, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30444 / 1.30433
2012-04-24 01:14:11 EUR/SGD -> JPY pipCost=0.00647708, rate=64.77081, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.62992 / 1.62933
2012-04-24 01:14:11 AUD/CHF -> JPY pipCost=0.00877798, rate=87.77981, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.95333 / 0.95301
2012-04-24 01:14:11 NZD/CAD -> JPY pipCost=0.00809900, rate=80.99002, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.82092 / 0.82055
2012-04-24 01:14:11 GBP/CAD -> JPY pipCost=0.00809834, rate=80.98339, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58279 / 1.58216
2012-04-24 01:14:11 USD/ZAR -> JPY pipCost=0.00101644, rate=10.16437, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.96592 / 7.95656
2012-04-24 01:14:11 CAD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 80.995 / 80.972
2012-04-24 01:14:11 AUD/CAD -> JPY pipCost=0.00809841, rate=80.98405, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.0333 / 1.03301
2012-04-24 01:14:11 GBP/USD -> JPY pipCost=0.00809210, rate=80.92100, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58382 / 1.58357
2012-04-24 01:14:11 AUD/NZD -> JPY pipCost=0.00664710, rate=66.47103, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.25892 / 1.25854
2012-04-24 01:14:11 USD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534404095[2012-04-16 00:00:04.095+0000] / 80.925 / 80.917
2012-04-24 01:14:11 USD/HKD -> JPY pipCost=0.00104296, rate=10.42956, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.7591 / 7.75852
2012-04-24 01:14:11 CAD/CHF -> JPY pipCost=0.00877863, rate=87.78625, last tick: 1334534402633[2012-04-16 00:00:02.633+0000] / 0.92273 / 0.92231
2012-04-24 01:14:11 USD/NOK -> JPY pipCost=0.00139453, rate=13.94532, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 5.8052 / 5.80027
2012-04-24 01:14:11 EUR/HKD -> JPY pipCost=0.00104298, rate=10.42979, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 10.12075 / 10.11976
2012-04-24 01:14:11 EUR/CAD -> JPY pipCost=0.00809828, rate=80.98277, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30355 / 1.30323
2012-04-24 01:14:11 CHF/SGD -> JPY pipCost=0.00647685, rate=64.76853, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.35546 / 1.35512
2012-04-24 01:14:11 USD/DKK -> JPY pipCost=0.00141899, rate=14.18991, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 5.70313 / 5.7023
2012-04-24 01:14:11 USD/SGD -> JPY pipCost=0.00647731, rate=64.77307, last tick: 1334534402664[2012-04-16 00:00:02.664+0000] / 1.24951 / 1.24909
2012-04-24 01:14:11 GBP/AUD -> JPY pipCost=0.00836658, rate=83.66575, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.532 / 1.53148
2012-04-24 01:14:11 USD/CAD -> JPY pipCost=0.00809846, rate=80.98457, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.99929 / 0.99914
2012-04-24 01:14:11 AUD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 83.678 / 83.658
2012-04-24 01:14:11 XAG/USD -> JPY pipCost=0.80921000, rate=80.92100, last tick: 1334534401490[2012-04-16 00:00:01.490+0000] / 31.455 / 31.412
2012-04-24 01:14:11 USD/SEK -> JPY pipCost=0.00118814, rate=11.88137, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 6.81276 / 6.80873
2012-04-24 01:14:11 HKD/JPY -> JPY pipCost=0.00010000, rate=1.00000, last tick: 1334534407536[2012-04-16 00:00:07.536+0000] / 10.43013 / 10.42898
2012-04-24 01:14:11 CHF/JPY -> EUR pipCost=0.83667112, rate=83.66711, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 87.792 / 87.768
2012-04-24 01:14:11 EUR/JPY -> EUR pipCost=0.83665923, rate=83.66592, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 105.56 / 105.54
2012-04-24 01:14:11 EUR/CHF -> EUR pipCost=0.00009531, rate=0.95315, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.20257 / 1.20234
2012-04-24 01:14:11 EUR/DKK -> EUR pipCost=0.00058962, rate=5.89617, last tick: 1334534591416[2012-04-16 00:03:11.416+0000] / 7.4389 / 7.4379
2012-04-24 01:14:11 GBP/CHF -> EUR pipCost=0.00009531, rate=0.95312, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.46018 / 1.45968
2012-04-24 01:14:11 USD/CHF -> EUR pipCost=0.00009531, rate=0.95315, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.92194 / 0.92178
2012-04-24 01:14:11 NZD/JPY -> EUR pipCost=0.83668574, rate=83.66857, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 66.482 / 66.463
2012-04-24 01:14:11 EUR/SEK -> EUR pipCost=0.00070408, rate=7.04084, last tick: 1334534404343[2012-04-16 00:00:04.343+0000] / 8.88621 / 8.87875
2012-04-24 01:14:11 GBP/NZD -> EUR pipCost=0.00012587, rate=1.25873, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.92839 / 1.92769
2012-04-24 01:14:11 CAD/HKD -> EUR pipCost=0.00080223, rate=8.02233, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.76598 / 7.76382
2012-04-24 01:14:11 EUR/GBP -> EUR pipCost=0.00006529, rate=0.65286, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.8237 / 0.82354
2012-04-24 01:14:11 NZD/CHF -> EUR pipCost=0.00009531, rate=0.95313, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.75739 / 0.75708
2012-04-24 01:14:11 EUR/AUD -> EUR pipCost=0.00010000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.26168 / 1.26145
2012-04-24 01:14:11 AUD/USD -> EUR pipCost=0.00010340, rate=1.03396, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.03403 / 1.03389
2012-04-24 01:14:11 AUD/SGD -> EUR pipCost=0.00012917, rate=1.29174, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.29201 / 1.29147
2012-04-24 01:14:11 EUR/NZD -> EUR pipCost=0.00012587, rate=1.25869, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58817 / 1.58768
2012-04-24 01:14:11 USD/MXN -> EUR pipCost=0.00136361, rate=13.63614, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 13.19363 / 13.18337
2012-04-24 01:14:11 GBP/JPY -> EUR pipCost=0.83669017, rate=83.66902, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 128.171 / 128.146
2012-04-24 01:14:11 EUR/NOK -> EUR pipCost=0.00059994, rate=5.99939, last tick: 1334534402590[2012-04-16 00:00:02.590+0000] / 7.57196 / 7.56528
2012-04-24 01:14:11 XAU/USD -> EUR pipCost=0.01033960, rate=1.03396, last tick: 1334534401748[2012-04-16 00:00:01.748+0000] / 1653.087 / 1652.752
2012-04-24 01:14:11 NZD/USD -> EUR pipCost=0.00010339, rate=1.03394, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.82152 / 0.82135
2012-04-24 01:14:11 EUR/USD -> EUR pipCost=0.00010339, rate=1.03394, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30444 / 1.30433
2012-04-24 01:14:11 EUR/SGD -> EUR pipCost=0.00012917, rate=1.29175, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.62992 / 1.62933
2012-04-24 01:14:11 AUD/CHF -> EUR pipCost=0.00009532, rate=0.95317, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.95333 / 0.95301
2012-04-24 01:14:11 NZD/CAD -> EUR pipCost=0.00010331, rate=1.03305, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.82092 / 0.82055
2012-04-24 01:14:11 GBP/CAD -> EUR pipCost=0.00010331, rate=1.03313, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58279 / 1.58216
2012-04-24 01:14:11 USD/ZAR -> EUR pipCost=0.00082315, rate=8.23146, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.96592 / 7.95656
2012-04-24 01:14:11 CAD/JPY -> EUR pipCost=0.83668368, rate=83.66837, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 80.995 / 80.972
2012-04-24 01:14:11 AUD/CAD -> EUR pipCost=0.00010332, rate=1.03315, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.0333 / 1.03301
2012-04-24 01:14:11 GBP/USD -> EUR pipCost=0.00010339, rate=1.03392, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58382 / 1.58357
2012-04-24 01:14:11 AUD/NZD -> EUR pipCost=0.00012587, rate=1.25873, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.25892 / 1.25854
2012-04-24 01:14:11 USD/JPY -> EUR pipCost=0.83667618, rate=83.66762, last tick: 1334534404095[2012-04-16 00:00:04.095+0000] / 80.925 / 80.917
2012-04-24 01:14:11 USD/HKD -> EUR pipCost=0.00080222, rate=8.02216, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.7591 / 7.75852
2012-04-24 01:14:11 CAD/CHF -> EUR pipCost=0.00009531, rate=0.95310, last tick: 1334534402633[2012-04-16 00:00:02.633+0000] / 0.92273 / 0.92231
2012-04-24 01:14:11 USD/NOK -> EUR pipCost=0.00059997, rate=5.99969, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 5.8052 / 5.80027
2012-04-24 01:14:11 EUR/HKD -> EUR pipCost=0.00080220, rate=8.02198, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 10.12075 / 10.11976
2012-04-24 01:14:11 EUR/CAD -> EUR pipCost=0.00010332, rate=1.03315, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30355 / 1.30323
2012-04-24 01:14:11 CHF/SGD -> EUR pipCost=0.00012918, rate=1.29179, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.35546 / 1.35512
2012-04-24 01:14:11 USD/DKK -> EUR pipCost=0.00058963, rate=5.89628, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 5.70313 / 5.7023
2012-04-24 01:14:11 USD/SGD -> EUR pipCost=0.00012917, rate=1.29170, last tick: 1334534402664[2012-04-16 00:00:02.664+0000] / 1.24951 / 1.24909
2012-04-24 01:14:11 GBP/AUD -> EUR pipCost=0.00010000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.532 / 1.53148
2012-04-24 01:14:11 USD/CAD -> EUR pipCost=0.00010331, rate=1.03313, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.99929 / 0.99914
2012-04-24 01:14:11 AUD/JPY -> EUR pipCost=0.83668000, rate=83.66800, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 83.678 / 83.658
2012-04-24 01:14:11 XAG/USD -> EUR pipCost=0.01033960, rate=1.03396, last tick: 1334534401490[2012-04-16 00:00:01.490+0000] / 31.455 / 31.412
2012-04-24 01:14:11 USD/SEK -> EUR pipCost=0.00070419, rate=7.04192, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 6.81276 / 6.80873
2012-04-24 01:14:11 HKD/JPY -> EUR pipCost=0.00836657, rate=83.66573, last tick: 1334534407536[2012-04-16 00:00:07.536+0000] / 10.43013 / 10.42898
2012-04-24 01:14:11 CHF/JPY -> USD pipCost=0.11881354, rate=11.88135, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 87.792 / 87.768
2012-04-24 01:14:11 EUR/JPY -> USD pipCost=0.11881132, rate=11.88113, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 105.56 / 105.54
2012-04-24 01:14:11 EUR/CHF -> USD pipCost=0.00001354, rate=0.13535, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.20257 / 1.20234
2012-04-24 01:14:11 EUR/DKK -> USD pipCost=0.00008373, rate=0.83730, last tick: 1334534591416[2012-04-16 00:03:11.416+0000] / 7.4389 / 7.4379
2012-04-24 01:14:11 GBP/CHF -> USD pipCost=0.00001354, rate=0.13535, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.46018 / 1.45968
2012-04-24 01:14:11 USD/CHF -> USD pipCost=0.00001354, rate=0.13535, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.92194 / 0.92178
2012-04-24 01:14:11 NZD/JPY -> USD pipCost=0.11881580, rate=11.88158, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 66.482 / 66.463
2012-04-24 01:14:11 EUR/SEK -> USD pipCost=0.00010000, rate=1.00000, last tick: 1334534404343[2012-04-16 00:00:04.343+0000] / 8.88621 / 8.87875
2012-04-24 01:14:11 GBP/NZD -> USD pipCost=0.00001788, rate=0.17875, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.92839 / 1.92769
2012-04-24 01:14:11 CAD/HKD -> USD pipCost=0.00011392, rate=1.13920, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.76598 / 7.76382
2012-04-24 01:14:11 EUR/GBP -> USD pipCost=0.00000927, rate=0.09271, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.8237 / 0.82354
2012-04-24 01:14:11 NZD/CHF -> USD pipCost=0.00001354, rate=0.13535, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.75739 / 0.75708
2012-04-24 01:14:11 EUR/AUD -> USD pipCost=0.00001420, rate=0.14201, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.26168 / 1.26145
2012-04-24 01:14:11 AUD/USD -> USD pipCost=0.00001468, rate=0.14683, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.03403 / 1.03389
2012-04-24 01:14:11 AUD/SGD -> USD pipCost=0.00001834, rate=0.18343, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.29201 / 1.29147
2012-04-24 01:14:11 EUR/NZD -> USD pipCost=0.00001787, rate=0.17874, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58817 / 1.58768
2012-04-24 01:14:11 USD/MXN -> USD pipCost=0.00019364, rate=1.93643, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 13.19363 / 13.18337
2012-04-24 01:14:11 GBP/JPY -> USD pipCost=0.11881773, rate=11.88177, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 128.171 / 128.146
2012-04-24 01:14:11 EUR/NOK -> USD pipCost=0.00008520, rate=0.85195, last tick: 1334534402590[2012-04-16 00:00:02.590+0000] / 7.57196 / 7.56528
2012-04-24 01:14:11 XAU/USD -> USD pipCost=0.00146827, rate=0.14683, last tick: 1334534401748[2012-04-16 00:00:01.748+0000] / 1653.087 / 1652.752
2012-04-24 01:14:11 NZD/USD -> USD pipCost=0.00001468, rate=0.14683, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.82152 / 0.82135
2012-04-24 01:14:11 EUR/USD -> USD pipCost=0.00001468, rate=0.14683, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30444 / 1.30433
2012-04-24 01:14:11 EUR/SGD -> USD pipCost=0.00001834, rate=0.18344, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.62992 / 1.62933
2012-04-24 01:14:11 AUD/CHF -> USD pipCost=0.00001354, rate=0.13535, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.95333 / 0.95301
2012-04-24 01:14:11 NZD/CAD -> USD pipCost=0.00001467, rate=0.14670, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.82092 / 0.82055
2012-04-24 01:14:11 GBP/CAD -> USD pipCost=0.00001467, rate=0.14671, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58279 / 1.58216
2012-04-24 01:14:11 USD/ZAR -> USD pipCost=0.00011689, rate=1.16892, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.96592 / 7.95656
2012-04-24 01:14:11 CAD/JPY -> USD pipCost=0.11881215, rate=11.88122, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 80.995 / 80.972
2012-04-24 01:14:11 AUD/CAD -> USD pipCost=0.00001467, rate=0.14671, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.0333 / 1.03301
2012-04-24 01:14:11 GBP/USD -> USD pipCost=0.00001468, rate=0.14683, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.58382 / 1.58357
2012-04-24 01:14:11 AUD/NZD -> USD pipCost=0.00001787, rate=0.17875, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.25892 / 1.25854
2012-04-24 01:14:11 USD/JPY -> USD pipCost=0.11881373, rate=11.88137, last tick: 1334534404095[2012-04-16 00:00:04.095+0000] / 80.925 / 80.917
2012-04-24 01:14:11 USD/HKD -> USD pipCost=0.00011392, rate=1.13920, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 7.7591 / 7.75852
2012-04-24 01:14:11 CAD/CHF -> USD pipCost=0.00001353, rate=0.13534, last tick: 1334534402633[2012-04-16 00:00:02.633+0000] / 0.92273 / 0.92231
2012-04-24 01:14:11 USD/NOK -> USD pipCost=0.00008520, rate=0.85200, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 5.8052 / 5.80027
2012-04-24 01:14:11 EUR/HKD -> USD pipCost=0.00011392, rate=1.13918, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 10.12075 / 10.11976
2012-04-24 01:14:11 EUR/CAD -> USD pipCost=0.00001467, rate=0.14671, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30355 / 1.30323
2012-04-24 01:14:11 CHF/SGD -> USD pipCost=0.00001834, rate=0.18344, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.35546 / 1.35512
2012-04-24 01:14:11 USD/DKK -> USD pipCost=0.00008373, rate=0.83731, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 5.70313 / 5.7023
2012-04-24 01:14:11 USD/SGD -> USD pipCost=0.00001834, rate=0.18343, last tick: 1334534402664[2012-04-16 00:00:02.664+0000] / 1.24951 / 1.24909
2012-04-24 01:14:11 GBP/AUD -> USD pipCost=0.00001420, rate=0.14201, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.532 / 1.53148
2012-04-24 01:14:11 USD/CAD -> USD pipCost=0.00001467, rate=0.14671, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 0.99929 / 0.99914
2012-04-24 01:14:11 AUD/JPY -> USD pipCost=0.11881220, rate=11.88122, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 83.678 / 83.658
2012-04-24 01:14:11 XAG/USD -> USD pipCost=0.00146827, rate=0.14683, last tick: 1334534401490[2012-04-16 00:00:01.490+0000] / 31.455 / 31.412
2012-04-24 01:14:11 USD/SEK -> USD pipCost=0.00010000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 6.81276 / 6.80873
2012-04-24 01:14:11 HKD/JPY -> USD pipCost=0.00118814, rate=11.88136, last tick: 1334534407536[2012-04-16 00:00:07.536+0000] / 10.43013 / 10.42898


Other relevant details:
- Testing using the Live platform
- Testing currency is USD, live account currency is CAD.

Please advise if I can be of any further assistance in resolving this bug.

Thank you,

Brad


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 24 Apr, 2012, 02:18 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
With just the EUR/USD and USD/JPY selected for testing, output is as follows:
Quote:
2012-04-24 01:16:59 account currency: USD
2012-04-24 01:16:59 EUR/USD -> JPY pipCost=0.00809210, rate=80.92100, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30444 / 1.30433
2012-04-24 01:16:59 USD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1334534404095[2012-04-16 00:00:04.095+0000] / 80.925 / 80.917
2012-04-24 01:16:59 EUR/USD -> EUR pipCost=0.00010000, rate=1.00000, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30444 / 1.30433
2012-04-24 01:16:59 USD/JPY -> EUR pipCost=0.80921000, rate=80.92100, last tick: 1334534404095[2012-04-16 00:00:04.095+0000] / 80.925 / 80.917
2012-04-24 01:16:59 EUR/USD -> USD pipCost=0.00000124, rate=0.01236, last tick: 1334534399998[2012-04-15 23:59:59.998+0000] / 1.30444 / 1.30433
2012-04-24 01:16:59 USD/JPY -> USD pipCost=0.01000000, rate=1.00000, last tick: 1334534404095[2012-04-16 00:00:04.095+0000] / 80.925 / 80.917


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Tue 24 Apr, 2012, 19:53 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
Could you please retest the strategy on JForex DEMO client?


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Wed 25 Apr, 2012, 23:26 

User rating: 3
Joined: Thu 17 Nov, 2011, 04:06
Posts: 39
Location: Canada, Ottawa
Results on the DEMO client.

For EUR/USD and USD/JPY
Quote:
2012-04-25 22:20:14 account currency: USD
2012-04-25 22:20:14 EUR/USD -> USD pipCost=0.00010000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.31964 / 1.31953
2012-04-25 22:20:14 USD/JPY -> USD pipCost=0.00012285, rate=0.01228, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 81.404 / 81.398
2012-04-25 22:20:14 EUR/USD -> JPY pipCost=0.00814010, rate=81.40100, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.31964 / 1.31953
2012-04-25 22:20:14 USD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 81.404 / 81.398
2012-04-25 22:20:14 EUR/USD -> EUR pipCost=0.00007578, rate=0.75781, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.31964 / 1.31953
2012-04-25 22:20:14 USD/JPY -> EUR pipCost=0.00009310, rate=0.00931, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 81.404 / 81.398


For all pairs...
Quote:
2012-04-25 22:24:51 account currency: USD
2012-04-25 22:24:51 AUD/USD -> USD pipCost=0.00010000, rate=1.00000, last tick: 1335312001237[2012-04-25 00:00:01.237+0000] / 1.03349 / 1.03337
2012-04-25 22:24:51 AUD/SGD -> USD pipCost=0.00008030, rate=0.80302, last tick: 1335312001646[2012-04-25 00:00:01.646+0000] / 1.28719 / 1.28667
2012-04-25 22:24:51 USD/JPY -> USD pipCost=0.00012285, rate=0.01228, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 81.404 / 81.398
2012-04-25 22:24:51 CHF/SGD -> USD pipCost=0.00008031, rate=0.80305, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.36754 / 1.36719
2012-04-25 22:24:51 GBP/CHF -> USD pipCost=0.00010981, rate=1.09807, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.47035 / 1.46996
2012-04-25 22:24:51 EUR/TRY -> USD pipCost=0.00005612, rate=0.56124, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 2.35203 / 2.35036
2012-04-25 22:24:51 USD/NOK -> USD pipCost=0.00001745, rate=0.17449, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 5.73325 / 5.72853
2012-04-25 22:24:51 NZD/CAD -> USD pipCost=0.00010132, rate=1.01324, last tick: 1335312001646[2012-04-25 00:00:01.646+0000] / 0.80334 / 0.80298
2012-04-25 22:24:51 USD/CAD -> USD pipCost=0.00010133, rate=1.01325, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.987 / 0.98684
2012-04-25 22:24:51 USD/RUB -> USD pipCost=0.00000341, rate=0.03408, last tick: 1335333611706[2012-04-25 06:00:11.706+0000] / 29.362 / 29.329
2012-04-25 22:24:51 EUR/HKD -> USD pipCost=0.00001289, rate=0.12887, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 10.23981 / 10.23897
2012-04-25 22:24:51 EUR/USD -> USD pipCost=0.00010000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.31964 / 1.31953
2012-04-25 22:24:51 GBP/CAD -> USD pipCost=0.00010132, rate=1.01322, last tick: 1335312007686[2012-04-25 00:00:07.686+0000] / 1.59354 / 1.593
2012-04-25 22:24:51 NZD/CHF -> USD pipCost=0.00010980, rate=1.09802, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.74128 / 0.741
2012-04-25 22:24:51 XAG/USD -> USD pipCost=0.01000000, rate=1.00000, last tick: 1335312002211[2012-04-25 00:00:02.211+0000] / 30.846 / 30.798
2012-04-25 22:24:51 USD/DKK -> USD pipCost=0.00001773, rate=0.17735, last tick: 1335312013903[2012-04-25 00:00:13.903+0000] / 5.63913 / 5.6381
2012-04-25 22:24:51 EUR/NOK -> USD pipCost=0.00001745, rate=0.17448, last tick: 1335312059317[2012-04-25 00:00:59.317+0000] / 7.56641 / 7.55928
2012-04-25 22:24:51 EUR/SGD -> USD pipCost=0.00008030, rate=0.80300, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.64357 / 1.64306
2012-04-25 22:24:51 GBP/USD -> USD pipCost=0.00010000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.61442 / 1.61425
2012-04-25 22:24:51 SGD/JPY -> USD pipCost=0.00012284, rate=0.01228, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 65.385 / 65.348
2012-04-25 22:24:51 USD/TRY -> USD pipCost=0.00005615, rate=0.56148, last tick: 1335312009400[2012-04-25 00:00:09.400+0000] / 1.78227 / 1.77972
2012-04-25 22:24:51 EUR/AUD -> USD pipCost=0.00010334, rate=1.03340, last tick: 1335312001294[2012-04-25 00:00:01.294+0000] / 1.27703 / 1.27685
2012-04-25 22:24:51 HKD/JPY -> USD pipCost=0.00000123, rate=0.01228, last tick: 1335312008461[2012-04-25 00:00:08.461+0000] / 10.49123 / 10.48958
2012-04-25 22:24:51 USD/PLN -> USD pipCost=0.00003146, rate=0.31461, last tick: 1335312015411[2012-04-25 00:00:15.411+0000] / 3.18194 / 3.17516
2012-04-25 22:24:51 AUD/NZD -> USD pipCost=0.00008138, rate=0.81382, last tick: 1335312001780[2012-04-25 00:00:01.780+0000] / 1.27006 / 1.26965
2012-04-25 22:24:51 AUD/JPY -> USD pipCost=0.00012285, rate=0.01228, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 84.13 / 84.114
2012-04-25 22:24:51 USD/MXN -> USD pipCost=0.00000760, rate=0.07600, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 13.16562 / 13.14888
2012-04-25 22:24:51 CHF/JPY -> USD pipCost=0.00012285, rate=0.01229, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 89.396 / 89.363
2012-04-25 22:24:51 GBP/JPY -> USD pipCost=0.00012285, rate=0.01228, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 131.421 / 131.397
2012-04-25 22:24:51 EUR/DKK -> USD pipCost=0.00001774, rate=0.17735, last tick: 1335312033271[2012-04-25 00:00:33.271+0000] / 7.44108 / 7.43992
2012-04-25 22:24:51 AUD/CHF -> USD pipCost=0.00010981, rate=1.09807, last tick: 1335312001834[2012-04-25 00:00:01.834+0000] / 0.94124 / 0.94102
2012-04-25 22:24:51 USD/HKD -> USD pipCost=0.00001289, rate=0.12887, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 7.76013 / 7.75927
2012-04-25 22:24:51 CAD/CHF -> USD pipCost=0.00010980, rate=1.09804, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.92299 / 0.92257
2012-04-25 22:24:51 EUR/SEK -> USD pipCost=0.00001485, rate=0.14850, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 8.8892 / 8.88341
2012-04-25 22:24:51 XAU/USD -> USD pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1642.178 / 1641.665
2012-04-25 22:24:51 CAD/JPY -> USD pipCost=0.00012285, rate=0.01229, last tick: 1335312008819[2012-04-25 00:00:08.819+0000] / 82.486 / 82.468
2012-04-25 22:24:51 NZD/USD -> USD pipCost=0.00010000, rate=1.00000, last tick: 1335312001842[2012-04-25 00:00:01.842+0000] / 0.81386 / 0.81372
2012-04-25 22:24:51 EUR/CAD -> USD pipCost=0.00010132, rate=1.01321, last tick: 1335312001224[2012-04-25 00:00:01.224+0000] / 1.30252 / 1.30223
2012-04-25 22:24:51 AUD/CAD -> USD pipCost=0.00010132, rate=1.01321, last tick: 1335312001837[2012-04-25 00:00:01.837+0000] / 1.02007 / 1.01984
2012-04-25 22:24:51 GBP/AUD -> USD pipCost=0.00010334, rate=1.03342, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.5623 / 1.56196
2012-04-25 22:24:51 GBP/NZD -> USD pipCost=0.00008138, rate=0.81380, last tick: 1335312001878[2012-04-25 00:00:01.878+0000] / 1.98399 / 1.98342
2012-04-25 22:24:51 USD/SEK -> USD pipCost=0.00001485, rate=0.14849, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 6.73676 / 6.7318
2012-04-25 22:24:51 EUR/NZD -> USD pipCost=0.00008138, rate=0.81381, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.6217 / 1.62129
2012-04-25 22:24:51 NZD/JPY -> USD pipCost=0.00012285, rate=0.01228, last tick: 1335312001965[2012-04-25 00:00:01.965+0000] / 66.253 / 66.235
2012-04-25 22:24:51 EUR/GBP -> USD pipCost=0.00016143, rate=1.61431, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.8175 / 0.81736
2012-04-25 22:24:51 USD/ZAR -> USD pipCost=0.00001285, rate=0.12846, last tick: 1335312009459[2012-04-25 00:00:09.459+0000] / 7.78654 / 7.78232
2012-04-25 22:24:51 EUR/JPY -> USD pipCost=0.00012285, rate=0.01228, last tick: 1335312001238[2012-04-25 00:00:01.238+0000] / 107.426 / 107.41
2012-04-25 22:24:51 USD/CHF -> USD pipCost=0.00010981, rate=1.09807, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.91078 / 0.9106
2012-04-25 22:24:51 USD/SGD -> USD pipCost=0.00008030, rate=0.80295, last tick: 1335312039252[2012-04-25 00:00:39.252+0000] / 1.24557 / 1.24524
2012-04-25 22:24:51 EUR/CHF -> USD pipCost=0.00010980, rate=1.09803, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.20191 / 1.20165
2012-04-25 22:24:51 CAD/HKD -> USD pipCost=0.00001289, rate=0.12888, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 7.86328 / 7.86112
2012-04-25 22:24:51 EUR/PLN -> USD pipCost=0.00003146, rate=0.31457, last tick: 1335333662670[2012-04-25 06:01:02.670+0000] / 4.19682 / 4.19298
2012-04-25 22:24:51 AUD/USD -> JPY pipCost=0.00814008, rate=81.40077, last tick: 1335312001237[2012-04-25 00:00:01.237+0000] / 1.03349 / 1.03337
2012-04-25 22:24:51 AUD/SGD -> JPY pipCost=0.00653664, rate=65.36641, last tick: 1335312001646[2012-04-25 00:00:01.646+0000] / 1.28719 / 1.28667
2012-04-25 22:24:51 USD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 81.404 / 81.398
2012-04-25 22:24:51 CHF/SGD -> JPY pipCost=0.00653662, rate=65.36623, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.36754 / 1.36719
2012-04-25 22:24:51 GBP/CHF -> JPY pipCost=0.00893845, rate=89.38445, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.47035 / 1.46996
2012-04-25 22:24:51 EUR/TRY -> JPY pipCost=0.00456866, rate=45.68656, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 2.35203 / 2.35036
2012-04-25 22:24:51 USD/NOK -> JPY pipCost=0.00142039, rate=14.20390, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 5.73325 / 5.72853
2012-04-25 22:24:51 NZD/CAD -> JPY pipCost=0.00824792, rate=82.47921, last tick: 1335312001646[2012-04-25 00:00:01.646+0000] / 0.80334 / 0.80298
2012-04-25 22:24:51 USD/CAD -> JPY pipCost=0.00824798, rate=82.47984, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.987 / 0.98684
2012-04-25 22:24:51 USD/RUB -> JPY pipCost=0.00027739, rate=2.77388, last tick: 1335333611706[2012-04-25 06:00:11.706+0000] / 29.362 / 29.329
2012-04-25 22:24:51 EUR/HKD -> JPY pipCost=0.00104907, rate=10.49066, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 10.23981 / 10.23897
2012-04-25 22:24:51 EUR/USD -> JPY pipCost=0.00814029, rate=81.40287, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.31964 / 1.31953
2012-04-25 22:24:51 GBP/CAD -> JPY pipCost=0.00824775, rate=82.47755, last tick: 1335312007686[2012-04-25 00:00:07.686+0000] / 1.59354 / 1.593
2012-04-25 22:24:51 NZD/CHF -> JPY pipCost=0.00893812, rate=89.38122, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.74128 / 0.741
2012-04-25 22:24:51 XAG/USD -> JPY pipCost=0.81401000, rate=81.40100, last tick: 1335312002211[2012-04-25 00:00:02.211+0000] / 30.846 / 30.798
2012-04-25 22:24:51 USD/DKK -> JPY pipCost=0.00144363, rate=14.43635, last tick: 1335312013903[2012-04-25 00:00:13.903+0000] / 5.63913 / 5.6381
2012-04-25 22:24:51 EUR/NOK -> JPY pipCost=0.00142034, rate=14.20339, last tick: 1335312059317[2012-04-25 00:00:59.317+0000] / 7.56641 / 7.55928
2012-04-25 22:24:51 EUR/SGD -> JPY pipCost=0.00653667, rate=65.36665, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.64357 / 1.64306
2012-04-25 22:24:51 GBP/USD -> JPY pipCost=0.00814013, rate=81.40132, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.61442 / 1.61425
2012-04-25 22:24:51 SGD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 65.385 / 65.348
2012-04-25 22:24:51 USD/TRY -> JPY pipCost=0.00457054, rate=45.70535, last tick: 1335312009400[2012-04-25 00:00:09.400+0000] / 1.78227 / 1.77972
2012-04-25 22:24:51 EUR/AUD -> JPY pipCost=0.00841214, rate=84.12142, last tick: 1335312001294[2012-04-25 00:00:01.294+0000] / 1.27703 / 1.27685
2012-04-25 22:24:51 HKD/JPY -> JPY pipCost=0.00010000, rate=1.00000, last tick: 1335312008461[2012-04-25 00:00:08.461+0000] / 10.49123 / 10.48958
2012-04-25 22:24:51 USD/PLN -> JPY pipCost=0.00256095, rate=25.60948, last tick: 1335312015411[2012-04-25 00:00:15.411+0000] / 3.18194 / 3.17516
2012-04-25 22:24:51 AUD/NZD -> JPY pipCost=0.00662454, rate=66.24536, last tick: 1335312001780[2012-04-25 00:00:01.780+0000] / 1.27006 / 1.26965
2012-04-25 22:24:51 AUD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 84.13 / 84.114
2012-04-25 22:24:51 USD/MXN -> JPY pipCost=0.00061868, rate=6.18678, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 13.16562 / 13.14888
2012-04-25 22:24:51 CHF/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 89.396 / 89.363
2012-04-25 22:24:51 GBP/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 131.421 / 131.397
2012-04-25 22:24:51 EUR/DKK -> JPY pipCost=0.00144369, rate=14.43693, last tick: 1335312033271[2012-04-25 00:00:33.271+0000] / 7.44108 / 7.43992
2012-04-25 22:24:51 AUD/CHF -> JPY pipCost=0.00893840, rate=89.38404, last tick: 1335312001834[2012-04-25 00:00:01.834+0000] / 0.94124 / 0.94102
2012-04-25 22:24:51 USD/HKD -> JPY pipCost=0.00104902, rate=10.49023, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 7.76013 / 7.75927
2012-04-25 22:24:51 CAD/CHF -> JPY pipCost=0.00893788, rate=89.37883, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.92299 / 0.92257
2012-04-25 22:24:51 EUR/SEK -> JPY pipCost=0.00120880, rate=12.08804, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 8.8892 / 8.88341
2012-04-25 22:24:51 XAU/USD -> JPY pipCost=0.81401000, rate=81.40100, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1642.178 / 1641.665
2012-04-25 22:24:51 CAD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335312008819[2012-04-25 00:00:08.819+0000] / 82.486 / 82.468
2012-04-25 22:24:51 NZD/USD -> JPY pipCost=0.00814018, rate=81.40184, last tick: 1335312001842[2012-04-25 00:00:01.842+0000] / 0.81386 / 0.81372
2012-04-25 22:24:51 EUR/CAD -> JPY pipCost=0.00824785, rate=82.47855, last tick: 1335312001224[2012-04-25 00:00:01.224+0000] / 1.30252 / 1.30223
2012-04-25 22:24:51 AUD/CAD -> JPY pipCost=0.00824762, rate=82.47619, last tick: 1335312001837[2012-04-25 00:00:01.837+0000] / 1.02007 / 1.01984
2012-04-25 22:24:51 GBP/AUD -> JPY pipCost=0.00841217, rate=84.12168, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.5623 / 1.56196
2012-04-25 22:24:51 GBP/NZD -> JPY pipCost=0.00662442, rate=66.24422, last tick: 1335312001878[2012-04-25 00:00:01.878+0000] / 1.98399 / 1.98342
2012-04-25 22:24:51 USD/SEK -> JPY pipCost=0.00120876, rate=12.08756, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 6.73676 / 6.7318
2012-04-25 22:24:51 EUR/NZD -> JPY pipCost=0.00662463, rate=66.24627, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.6217 / 1.62129
2012-04-25 22:24:51 NZD/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335312001965[2012-04-25 00:00:01.965+0000] / 66.253 / 66.235
2012-04-25 22:24:51 EUR/GBP -> JPY pipCost=0.01314094, rate=131.40942, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.8175 / 0.81736
2012-04-25 22:24:51 USD/ZAR -> JPY pipCost=0.00104569, rate=10.45690, last tick: 1335312009459[2012-04-25 00:00:09.459+0000] / 7.78654 / 7.78232
2012-04-25 22:24:51 EUR/JPY -> JPY pipCost=0.01000000, rate=1.00000, last tick: 1335312001238[2012-04-25 00:00:01.238+0000] / 107.426 / 107.41
2012-04-25 22:24:51 USD/CHF -> JPY pipCost=0.00893839, rate=89.38387, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.91078 / 0.9106
2012-04-25 22:24:51 USD/SGD -> JPY pipCost=0.00653611, rate=65.36107, last tick: 1335312039252[2012-04-25 00:00:39.252+0000] / 1.24557 / 1.24524
2012-04-25 22:24:51 EUR/CHF -> JPY pipCost=0.00893824, rate=89.38242, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.20191 / 1.20165
2012-04-25 22:24:51 CAD/HKD -> JPY pipCost=0.00104903, rate=10.49032, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 7.86328 / 7.86112
2012-04-25 22:24:51 EUR/PLN -> JPY pipCost=0.00256068, rate=25.60681, last tick: 1335333662670[2012-04-25 06:01:02.670+0000] / 4.19682 / 4.19298
2012-04-25 22:24:51 AUD/USD -> EUR pipCost=0.00007577, rate=0.75772, last tick: 1335312001237[2012-04-25 00:00:01.237+0000] / 1.03349 / 1.03337
2012-04-25 22:24:51 AUD/SGD -> EUR pipCost=0.00006085, rate=0.60852, last tick: 1335312001646[2012-04-25 00:00:01.646+0000] / 1.28719 / 1.28667
2012-04-25 22:24:51 USD/JPY -> EUR pipCost=0.00009308, rate=0.00931, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 81.404 / 81.398
2012-04-25 22:24:51 CHF/SGD -> EUR pipCost=0.00006085, rate=0.60854, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.36754 / 1.36719
2012-04-25 22:24:51 GBP/CHF -> EUR pipCost=0.00008321, rate=0.83212, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.47035 / 1.46996
2012-04-25 22:24:51 EUR/TRY -> EUR pipCost=0.00004253, rate=0.42532, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 2.35203 / 2.35036
2012-04-25 22:24:51 USD/NOK -> EUR pipCost=0.00001322, rate=0.13222, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 5.73325 / 5.72853
2012-04-25 22:24:51 NZD/CAD -> EUR pipCost=0.00007679, rate=0.76786, last tick: 1335312001646[2012-04-25 00:00:01.646+0000] / 0.80334 / 0.80298
2012-04-25 22:24:51 USD/CAD -> EUR pipCost=0.00007678, rate=0.76776, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.987 / 0.98684
2012-04-25 22:24:51 USD/RUB -> EUR pipCost=0.00000258, rate=0.02582, last tick: 1335333611706[2012-04-25 06:00:11.706+0000] / 29.362 / 29.329
2012-04-25 22:24:51 EUR/HKD -> EUR pipCost=0.00000977, rate=0.09766, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 10.23981 / 10.23897
2012-04-25 22:24:51 EUR/USD -> EUR pipCost=0.00007578, rate=0.75781, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.31964 / 1.31953
2012-04-25 22:24:51 GBP/CAD -> EUR pipCost=0.00007678, rate=0.76782, last tick: 1335312007686[2012-04-25 00:00:07.686+0000] / 1.59354 / 1.593
2012-04-25 22:24:51 NZD/CHF -> EUR pipCost=0.00008321, rate=0.83212, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.74128 / 0.741
2012-04-25 22:24:51 XAG/USD -> EUR pipCost=0.00757718, rate=0.75772, last tick: 1335312002211[2012-04-25 00:00:02.211+0000] / 30.846 / 30.798
2012-04-25 22:24:51 USD/DKK -> EUR pipCost=0.00001344, rate=0.13438, last tick: 1335312013903[2012-04-25 00:00:13.903+0000] / 5.63913 / 5.6381
2012-04-25 22:24:51 EUR/NOK -> EUR pipCost=0.00001322, rate=0.13223, last tick: 1335312059317[2012-04-25 00:00:59.317+0000] / 7.56641 / 7.55928
2012-04-25 22:24:51 EUR/SGD -> EUR pipCost=0.00006085, rate=0.60853, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.64357 / 1.64306
2012-04-25 22:24:51 GBP/USD -> EUR pipCost=0.00007577, rate=0.75772, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.61442 / 1.61425
2012-04-25 22:24:51 SGD/JPY -> EUR pipCost=0.00009309, rate=0.00931, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 65.385 / 65.348
2012-04-25 22:24:51 USD/TRY -> EUR pipCost=0.00004254, rate=0.42545, last tick: 1335312009400[2012-04-25 00:00:09.400+0000] / 1.78227 / 1.77972
2012-04-25 22:24:51 EUR/AUD -> EUR pipCost=0.00007831, rate=0.78312, last tick: 1335312001294[2012-04-25 00:00:01.294+0000] / 1.27703 / 1.27685
2012-04-25 22:24:51 HKD/JPY -> EUR pipCost=0.00000093, rate=0.00931, last tick: 1335312008461[2012-04-25 00:00:08.461+0000] / 10.49123 / 10.48958
2012-04-25 22:24:51 USD/PLN -> EUR pipCost=0.00002384, rate=0.23838, last tick: 1335312015411[2012-04-25 00:00:15.411+0000] / 3.18194 / 3.17516
2012-04-25 22:24:51 AUD/NZD -> EUR pipCost=0.00006167, rate=0.61670, last tick: 1335312001780[2012-04-25 00:00:01.780+0000] / 1.27006 / 1.26965
2012-04-25 22:24:51 AUD/JPY -> EUR pipCost=0.00009309, rate=0.00931, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 84.13 / 84.114
2012-04-25 22:24:51 USD/MXN -> EUR pipCost=0.00000576, rate=0.05759, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 13.16562 / 13.14888
2012-04-25 22:24:51 CHF/JPY -> EUR pipCost=0.00009310, rate=0.00931, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 89.396 / 89.363
2012-04-25 22:24:51 GBP/JPY -> EUR pipCost=0.00009309, rate=0.00931, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 131.421 / 131.397
2012-04-25 22:24:51 EUR/DKK -> EUR pipCost=0.00001344, rate=0.13440, last tick: 1335312033271[2012-04-25 00:00:33.271+0000] / 7.44108 / 7.43992
2012-04-25 22:24:51 AUD/CHF -> EUR pipCost=0.00008321, rate=0.83211, last tick: 1335312001834[2012-04-25 00:00:01.834+0000] / 0.94124 / 0.94102
2012-04-25 22:24:51 USD/HKD -> EUR pipCost=0.00000976, rate=0.09765, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 7.76013 / 7.75927
2012-04-25 22:24:51 CAD/CHF -> EUR pipCost=0.00008321, rate=0.83208, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.92299 / 0.92257
2012-04-25 22:24:51 EUR/SEK -> EUR pipCost=0.00001125, rate=0.11253, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 8.8892 / 8.88341
2012-04-25 22:24:51 XAU/USD -> EUR pipCost=0.00757718, rate=0.75772, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1642.178 / 1641.665
2012-04-25 22:24:51 CAD/JPY -> EUR pipCost=0.00009310, rate=0.00931, last tick: 1335312008819[2012-04-25 00:00:08.819+0000] / 82.486 / 82.468
2012-04-25 22:24:51 NZD/USD -> EUR pipCost=0.00007577, rate=0.75772, last tick: 1335312001842[2012-04-25 00:00:01.842+0000] / 0.81386 / 0.81372
2012-04-25 22:24:50 EUR/CAD -> EUR pipCost=0.00007678, rate=0.76783, last tick: 1335312001224[2012-04-25 00:00:01.224+0000] / 1.30252 / 1.30223
2012-04-25 22:24:50 AUD/CAD -> EUR pipCost=0.00007678, rate=0.76780, last tick: 1335312001837[2012-04-25 00:00:01.837+0000] / 1.02007 / 1.01984
2012-04-25 22:24:50 GBP/AUD -> EUR pipCost=0.00007831, rate=0.78313, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.5623 / 1.56196
2012-04-25 22:24:50 GBP/NZD -> EUR pipCost=0.00006167, rate=0.61670, last tick: 1335312001878[2012-04-25 00:00:01.878+0000] / 1.98399 / 1.98342
2012-04-25 22:24:50 USD/SEK -> EUR pipCost=0.00001125, rate=0.11252, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 6.73676 / 6.7318
2012-04-25 22:24:50 EUR/NZD -> EUR pipCost=0.00006167, rate=0.61671, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.6217 / 1.62129
2012-04-25 22:24:50 NZD/JPY -> EUR pipCost=0.00009310, rate=0.00931, last tick: 1335312001965[2012-04-25 00:00:01.965+0000] / 66.253 / 66.235
2012-04-25 22:24:50 EUR/GBP -> EUR pipCost=0.00012233, rate=1.22335, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.8175 / 0.81736
2012-04-25 22:24:50 USD/ZAR -> EUR pipCost=0.00000973, rate=0.09734, last tick: 1335312009459[2012-04-25 00:00:09.459+0000] / 7.78654 / 7.78232
2012-04-25 22:24:50 EUR/JPY -> EUR pipCost=0.00009309, rate=0.00931, last tick: 1335312001238[2012-04-25 00:00:01.238+0000] / 107.426 / 107.41
2012-04-25 22:24:50 USD/CHF -> EUR pipCost=0.00008320, rate=0.83203, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 0.91078 / 0.9106
2012-04-25 22:24:50 USD/SGD -> EUR pipCost=0.00006084, rate=0.60841, last tick: 1335312039252[2012-04-25 00:00:39.252+0000] / 1.24557 / 1.24524
2012-04-25 22:24:50 EUR/CHF -> EUR pipCost=0.00008321, rate=0.83210, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 1.20191 / 1.20165
2012-04-25 22:24:50 CAD/HKD -> EUR pipCost=0.00000977, rate=0.09766, last tick: 1335311999998[2012-04-24 23:59:59.998+0000] / 7.86328 / 7.86112
2012-04-25 22:24:50 EUR/PLN -> EUR pipCost=0.00002384, rate=0.23838, last tick: 1335333662670[2012-04-25 06:01:02.670+0000] / 4.19682 / 4.19298


 
 Post subject: Re: Explanation of convertPipToCurrency() Output Post rating: 0   New post Posted: Thu 26 Apr, 2012, 08:12 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
So the issue has been fixed on DEMO (JForex-API 2.6.65) and will be available on LIVE (currently JForex-API 2.6.60.1) with the next release of LIVE JForex client.


 

Jump to:  

  © 1998-2025 Dukascopy® Bank SA
On-line Currency forex trading with Swiss Forex Broker - ECN Forex Brokerage,
Managed Forex Accounts, introducing forex brokers, Currency Forex Data Feed and News
Currency Forex Trading Platform provided on-line by Dukascopy.com