Net Change since Last Week's Close

[stockgoblin]

Hi,

I'm trying to get the Net change since Last week's close.

Isn't that:

(Close[0] - Close[0].DayOfWeek.Friday);

???

[NinjaTrader_Joydeep]

Hello stockgoblin,
If you are trying to calcualate the differene on Intraday bars then you may consider using this code to calculate the Weekly OHLC.

http://ninjatrader.com/support/forum/local_links.php?action=ratelink&linkid=540&catid=-1&lpage=1

A sample code to calculate the difference will be like:

double diff = PriorWeekOHLC().PriorWeekClose[0] - Close[0];

[stockgoblin]

Hey, Thanks for pointing me in the direction of your indicator. I'm looking for the Prior Week's Close to put on the Market Analyzer. I tried your indicator but it just gives me the prior days close in the Market Analyzer. Did you expand that code for use in the Market Analyzer?

Can I do a simple modification to make it give me the Prior Week's Close in the Market Analyzer?

[NinjaTrader_Joydeep]

Hello stockgoblin,
To assists you further can I know what parameters you have used while assigning the Indicator in the Market Analyzer.

Can you please upload a screenshot of the indicator parameters box.

To send a screenshot press Alt + PRINT SCREEN to take a screen shot of the selected window. Then go to Start--> Accessories--> Paint, and press CTRL + V to paste the image. Lastly, save as a jpeg file and send the file as an attachment.

For detailed instructions please visit the following link

• http://take-a-screenshot.org/

[stockgoblin]

I tried using daily data and that's when you get the previous day's close. Using weekly data in the market analyzer settings gives numbers that I can't verify where they come from.

[NinjaTrader_Joydeep]

Hello stockgoblin,
Thanks for the clarification.

The PriorWeekOHLC indicator works on Intraday Data only.

To view the prior weeks closing price on the Market Analyzer you can simply use a 1 (one) period SMA applied on weekly data with Calculate on bar close set to true. Please refer to the attached screenshot which further demonstrates the scenario.

[stockgoblin]

Now, that's smart thinking.

Can I press your brain further though? Now that I have the Prior Week's close, I would like the net change from the prior week's close on the Market Analyzer.

so:

Can we do that in a formula using SMA and I'll whip up a market analyzer indicator?

[NinjaTrader_Joydeep]

Hello stockgoblin,
The prior week indicator works on intraday data only.

A much easier way would be simply calculate a net change indicator and apply it on a weekly bar.

[stockgoblin]

Yea, that sounds good. I'll get on it. There is a Net Change Market Analyzer indicator but it's hard coded for the last daily close, not the last weekly close.

[NinjaTrader_Joydeep]

Hello stockgoblin,
The NetChange is a MarketAnalyzer column and not an indicator.

You have to build an custom indicator to calculate the net change and then apply the indicator on a weekly bar with Calculate on bar close set to false.

[stockgoblin]

Done! Thanks for all your help.