why doesnt NT understand forex quantities and P/L

[NinjaTrader_Brett]

Rate is only found in the Control Center->Account Performance->Executions Tab.

-Brett

[khoga]

Was there resolution to this?

I'm also having the same problem. The Rate in the Executions tab is correct and the # of pips is correct, but it shows up in the PnL field and isn't multiplied by the qty/dollar amount I traded...

[NinjaTrader_Brett]

Hello,

When you say the execution tab is correct what exactly do you mean. What value do you have to QTY -> Rate -> and subsequently PnL showed in the account performance execution report.

-Brett

[khoga]

Code and results

The code snippet is:

EnterLong((int)(GetAccountValue(AccountItem.Buying Power)/Close[0]), lsSignal + "Long");

The goal is to use all available cash in a trade, buying the currency.

Results end up as follows for EURJPY:

Trades Tab:
Qty: 10000
Entry: 99.87
Exit: 99.88
Profit: 0.01

Executions Tab:
Buy, 10000, 99.87, Entry, Rate=1
Sell, 10000, 99.88, Exit, Rate=0.0127828

I reran the same scenario above, but with a qty of 100,000 (just to see if the result was different and maybe my math was just off) but came up with 0.01 profit on half a pip this time. (rounded, maybe?).

I really apologize if I'm missing something basic here, but I would have expected the price difference (here 0.01) to be multiplied out by the qty (or cash amount purchased - 0.01 for every dollar committed).

Kindly let me know what I'm missing?


*******************************
Edit the above - looks like the profit of 0.01 is actually profit of 0.01%. I had to go to the periods tab and filter through the trading hours to see the actual dollars earned, but they show up much more in line.

Taking this lesson learned back to Strategy Analyzer, the rate column in the executions tab is always 1 and doesn't change to the appropriate denomination. I've the correct data for all major cross-currencies in the database.

For instance, an optimization run on a single pair returns a cumulative return of -15.69%, a total net profit of -$0.14 but the account amount used is $100,000.

Is there something I need to tweak for Strategy Analyzer?

[NinjaTrader_Brett]

Hello,

At the top is a drop down selector to the right of the Generate button to select the PnL display.

Can you please confirm what is this set too? As a PnL of .01 is correct when 1 tick is the PnL if you are set to points mode.

-Brett

[khoga]

You are both a scholar and a gentleman! Sorry about the "RTFM" question there.

Any thoughts on Strategy Analyzer? Am I making a bone head move there?

[NinjaTrader_Brett]

No problem, as far as the strategy analyzer not sure what you're asking.

-Brett

[luxurious_04]

I just wanna ask if 1 pips in forex chart is equal to 1 tick on futures?

[NinjaTrader_Matthew]

They are equal in the sake that 1 tick and 1 pip represent the smallest possible fluctuation in price. However that does not mean that 1 tick in futures is worth the same amount as 1 tick in forex. Each instrument has it's own point value which will change the cost per tick.

[jimi euro]

I'm having this same P/L problem in NinjaTrader for Forex. NT does not correctly calculate pnl for forex for me. I have tried to test in live and market replay, and found it only working in market replay if I had immediately downloaded a new bit of market replay data.

Resetting the instruments does not work. I have tried uninstalls, reinstalls, db repairs, even getting rid of my entire NT7 folder and replacing with just a few pieces of fresh market replay data. How can I fix this?

Jim

[jimi euro]

I'm having this same P/L problem in NinjaTrader for Forex. NT does not correctly calculate pnl for forex for me. I have tried to test in live and market replay, and found it only working in market replay if I had immediately downloaded a new bit of market replay data.

Resetting the instruments does not work. I have tried uninstalls, reinstalls, db repairs, even getting rid of my entire NT7 folder and replacing with just a few pieces of fresh market replay data. How can I fix this?

Jim

bump?.................

[NinjaTrader_Brett]

Hello,

Thanks for the the forum post.

To calculate forex PnL correctly you needed to have the converting pairs live data in NinjaTrader. Either in a market analyzer or another chart for example. To confirm this is the problem if you go to the control center->executions tab and look at the executions tab. The column of rate would be 0 or 1. This indicates no conversion has occurred and you need the live data of the forex pair that will convert it to USD data flowing.

Forex traders I recommend going to File->New->Market Analyzer and then right click and add instrument list and add the forex list. This contains the all the major pairs that should fill all your conversion needs for you.

-Brett

[jimi euro]

Hello Brett,

I'm still having the issue. I have many currency pairs loaded, both with USD and cross currency pairs in market analyzer. The PNL still shows an error. The currency conversion rate in the executions tab is 1.6196.

[NinjaTrader_Brett]

Hello,

What is the rate set too?

Then lets break down one trade that is off.

What is the QTY of the trade?

What is the PnL reported of the trade?

How many pips in PnL was there?

-Brett

[jimi euro]

• EURGBP
• 0.0004 difference in price
• 100,000 units
• Should be $40
• Displays $64.78

Screen shots attached.



Thank you for your kind help.