|
PureBytes Links
Trading Reference Links
|
Hi Grant (or anyone),
Your code further below, calculates the fxRate based on the Close of
the last bar. Since I have yet to live trade and have only been
involved in backtesting, I am unsure how a broker actually computes
the exchange rate during a real trade. Is their rate typically
"dynamic" and set according to the "last bar" of one's trade?
For example, if I am trading GBP JPY intraday on 15-min bars, with a
base account in USD, and I execute a trade at 09:15 am, will the
broker calculate the exchange rate of JPY USD based on what the rate
was at 09:00 am (i.e. "one bar ago") or will the broker use a rate
based on the close of the previous day? If the latter, how do we modify your code to accomdate that fact?
Also, I have modified a section of your code to account for the fact
that my historical Forex database might have the USDJPY pair but not
the reverse, JPYUSD. Does this look like the right approach?:
ccy1 = StrLeft(Name(),3); // eg. EURJPY gives EUR
ccy2 = StrRight( Name(), 3 ); // eg. EURJPY gives JPY
TickSize = IIf( ccy2 == "JPY", 0.01, 0.0001 ); // the minimum price move of symbol
RoundLotSize = 1; // whole contracts only
contracts = 1;
SetPositionSize( contracts, spsShares );
// Calculate the exchange rate, "fxRate" against our base currency
// For e.g., if we are trading GBYCHF with base of USD, we search our symbols database for either
// CHFUSD or USDCHF, and then find last bar's Close in order to get the correct multiplier:
if( IsNull(Foreign(StrFormat( ccy2 + base ), "Close") ) )
{
fxRateInversed = IIf( ccy2 == base, 1, Ref( Foreign( StrFormat( base +ccy2 ), "Close" ), -1 ) );
fxRate = 1 / fxRateInversed;
}
else
fxRate = IIf( ccy2 == base, 1, Ref( Foreign( StrFormat( ccy2 + base ), "Close" ), -1 ) );
pv = lotsize * fxRate;
md = pv * Close * 1 / leverage;
Thanks for any feedback.
--- In amibroker@xxxxxxxxxxxxxxx, Grant Noble <gruntus@xxx> wrote:
>
> Quit your whining. It took me the best part of 2 years to get accurate profit & margin calculations.
> It didn't help that there was a bug in fx profit calculations involving leverage but Thomasz fixed
> that a few releases ago (ta :)). Along the way I realised that not all brokers calculate margin the
> same way - my broker actually has three different calculations depending on the type of stop used.
> Some base margin on CCY1, some on CCY2. Also margin, as a symbol information property, is defined
> statically whereas I needed to define it dynamically at order time based on entry price. Therefore I
> needed CBT code which I was able to create with the help of another participant on this forum (g'day
> Aron). You too will probably need something like this. Amibroker support is tip-top but working out
> how to set backtest preferences for your broker is your job.
>
> I'll attach some code I use. I #include it in all my systems. Note that is uses ATC so you'll have
> to retrieve this data within your system code. Note also that this code is partially obsolete (since
> that bug was sorted out). Will it do exactly what you want? Probably not, you'll need to tweak
> depending upon your use. I need to do more work on it but I've been busy with twin babies. Hope it
> helps. G
>
> /*
> Grant's FX preferences
> */
> SetOption("FuturesMode", True); // = use MarginDeposit and PointValue in calculations
> SetOption("InitialEquity", 10000 ); // Initial equity $
> SetOption("MaxOpenPositions", 4 ); // Max number of positions
> SetOption("CommissionMode", 3); // 3 = $ per share/contract
> SetOption("CommissionAmount", 0); // Commission amount
> SetOption("AccountMargin", 100); // Account margin, 100 = no margin
> SetOption("PriceBoundChecking", True ); // Price to stay in bar range ?
> SetOption("UsePrevBarEquityForPosSizing", True ); // Use last known bar for position sizing ?
> SetOption("ActivateStopsImmediately", False); // Intraday stops ?
> SetOption("Allowsamebarexit", True); // Allow same bar exit for profit stops ?
> SetOption("Allowpositionshrinking", True); // Take partial trades if equity available ?
> SetOption("InterestRate",0); // Set interest rate earned for free cash, zero to evaluate system
> SetOption("UseCustomBacktestProc", True); // Use Custom backtest for reporting ?
> SetOption("MinShares", 1); // Min number shares one
> SetOption("MinPosValue", 0); // Min position value to make trade worthwhile, 0 = no limit
> SetTradeDelays(0,0,0,0); // Trade delays applied by the backtester
>
> lotsize = StrToNum( ParamList("Lot size", "100000|10000|1000", 0) ); // default lot 100000
> leverage = Param("Leverage rate", 50, 1, 100, 1); // default leverage 50:1
> base = ParamList("Base currency","AUD|CAD|CHF|EUR|GBP|USD", 0); // default base currency AUD
>
> ccy2 = StrRight( Name(), 3 ); // eg. EURJPY gives JPY
> TickSize = IIf( ccy2 == "JPY", 0.01, 0.0001 ); // the minimum price move of symbol
> RoundLotSize = 1; // whole contracts only
> contracts = 1; // contracts to acquire
> SetPositionSize( contracts, spsShares ); // spsShares = size expressed in shares/contracts
>
> fxRate = IIf( ccy2 == base, 1, Ref( Foreign( StrFormat( ccy2 + base ), "Close" ), -1 ) ); // eg.
> close of JPYAUD yesterday
> pv = lotsize * fxRate; // the amount of profit generated by one contract for a one point increase
> in price
> md = pv * Close * 1 / leverage; // the amount of money required to open single contract position [IG
> margin - no stop]
>
> // note: ATC code produces future leak warning when code is Checked by editor..
> AddToComposite( pv, "~spec_" + Name(), "O", atcFlagDeleteValues + atcFlagCompositeGroup +
> atcFlagEnableInExplore + atcFlagEnableInBacktest ); // store daily point value in composite
> AddToComposite( md, "~spec_" + Name(), "C", atcFlagCompositeGroup + atcFlagEnableInExplore +
> atcFlagEnableInBacktest ); // store daily margin deposit in composite
>
> SetCustomBacktestProc(""); // no external backtest procedure
> if ( Status("action") == actionPortfolio) {
> bo = GetBacktesterObject(); // get backtester object
> //
> // set correct MarginDeposit & PointValue on entry signal days
> //
> bo.PreProcess(); // do pre-processing (always required)
> for (i = 1; i < BarCount; i++) // loop through all bars
> {
> for (sig = bo.GetFirstSignal(i); sig; sig = bo.GetNextSignal(i)) // loop through all signals at
> this bar
> {
> if( sig.IsEntry() ) // is it an entry signal (buy/short) ?
> {
> pv = Foreign( "~spec_" + sig.Symbol, "O" ); // entry day point value
> md = Foreign( "~spec_" + sig.Symbol, "C" ); // entry day margin deposit
> _TRACE( StrFormat( "Ticker=" + sig.Symbol + " PointValue=%1.0f pv=%1.0f MarginDeposit=%1.0f
> md=%1.0f", sig.PointValue, pv[i], sig.MarginDeposit, md[i] ) );
> sig.PointValue = pv[i]; // set symbol PointValue
> sig.MarginDeposit = md[i]; // set symbol MarginDeposit
> }
> }
> bo.ProcessTradeSignals(i); // process trades at bar (always required)
> }
> bo.PostProcess(); // do post-processing (always required)
> }
> //
>
> Ýlhan Ketrez wrote:
> > Dear friends,
> >
> > Before registering the mailgroup, I was quite frustated regarding the
> > customer support for Amibroker. Now I observe that Tomasz is very busy
> > with the new technological developements of the software and replies the
> > related questions mostly. I appreciate his great effort and magical
> > software.
> >
> > In my recent e-mails, I believe that I emphasize an important point
> > about forex backtesting in Amibroker. Currently, I see that it is
> > impossible to truly backtest multiple forex pairs with the standard
> > backtester interface. Below, I am trying to explain in detail.
> >
> > - For EURUSD and XXXUSD pairs everything is OK.
> > - When the second unit is not USD, problem arises. I'm taking the EURJPY
> > as my example. Brokers calculate the profit-loss of these trades in JPY
> > (using the pointvalue * pricechange formula) and then converts to USD,
> > using the USDJPY pair as you know.
> > - In Amibroker, when we set the currency as JPY and indicate USDJPY in
> > the settings, it calculates the profit-losses correctly.
> > - In this case, it takes also the margin deposit scalar in JPY.
> > - Hence, all the traded contract quantities increase to extreme values
> > and all the backtest becomes incorrect.
> >
> > How can we (do you) overcome this hindrance?
> >
> > Thanks in advance and best regards,
> > Ilhan
> >
> >
> >
> >
> >
> >
> > ---------- Yönlendirilmiþ ileti ----------
> > Kimden: *Ýlhan Ketrez* ilhanketrez@xxx
> > <mailto:ilhanketrez@xxx>
> > Tarih: 27 Haziran 2008 Cuma 15:28
> > Konu: Re: [amibroker] Portfolio backtest in forex
> > Kime: amibroker@xxxxxxxxxxxxxxx <mailto:amibroker@xxxxxxxxxxxxxxx
> >
> >
> >
> > Thanks Tomasz,
> >
> > Curreny setting in the symbol information window is OK.
> >
> > The settings in the Tools->Preferences->Currencies windos are also OK.
> >
> > When we change the currency, the currency of the margin deposit also
> > changes. That is the problem.
> > In forex accounts all of the margins are (Say) 1000 USD.
> > Hence, in the current situation it becomes 1000 CHF. (Small Problem,
> > average in last years is around 1.4)
> > If the pair is USDJPY, it becomes 1000 JPY. (Greater problem average in
> > last years is around 110)
> >
> > As a result, almost all of the results become insignificant, starting
> > with exposure, total profit/loss calculations.
> >
> >
> > Please note that, unit profit-loss calculation is correct. Infact
> > everything else seem to be correct.
> >
> > I understand the need for setting the margindeposit currency to the
> > active currency to make trade in different markets.
> >
> > One temporary solution can be making an approach by adjusting the
> > position size accordingly But the real, exact solution can only be
> > achieved by defining a seperate currency setting for the margin deposit.
> >
> > I am waiting for your comments.
> >
> > Best regards,
> > Ilhan
> >
> >
> > 2008/6/27, Tomasz Janeczko groups@xxx
> > <mailto:groups@xxx>:
> >
> > Hello,
> >
> > You need to define CURRENCY (symbol->information) for that pair to
> > match the deposit currency.
> > You also need to setup currency tables in Tools->Preferences->Currencies
> >
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com <http://amibroker.com/>
> >
> > ----- Original Message -----
> > *From:* Ýlhan Ketrez <mailto:ilhanketrez@xxx
> > *To:* amibroker@xxxxxxxxxxxxxxx <mailto:amibroker@xxxxxxxxxxxxxxx
> > *Sent:* Thursday, June 26, 2008 4:24 PM
> > *Subject:* [amibroker] Portfolio backtest in forex
> >
> >
> > Hello,
> >
> > While the currency for the margin deposit is not USD, how can we
> > perform a correct portfolio backtest in XXXYYY where YYY is not
> > USD such as EURCHF?
> >
> > Thanks in advance.
> > Ilhan
> >
> >
> >
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG.
> > Version: 8.0.101 / Virus Database: 270.4.3/1527 - Release Date: 6/30/2008 6:07 PM
>
__._,_.___
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
![]()
__,_._,___
|