New York 5PM Daily Close

[imported_tickstoryParticipant March 9, 2013 at 12:01 am Post count: 1479]

#18634

Hi Jack,

Thanks very much for your post and feedback. If you want to adjust the time to NY time, does “Eastern time (US & Canada)” not do the job for you? It will automatically adjust for daylight savings time.

Regards,

[jacktParticipant March 9, 2013 at 12:38 am Post count: 7]

#18635

@tickstory wrote:

Hi Jack,

Thanks very much for your post and feedback. If you want to adjust the time to NY time, does “Eastern time (US & Canada)” not do the job for you? It will automatically adjust for daylight savings time.

Regards,

No I’m not talking about EST, but it’s an artificial time zone which is EST/EDT + 7. When I say New York Close, it means daily open/close at 5PM EST when most financial markets have already closed at that time.

For example, Sunday 5PM EST/EDT when most broker open will become Monday Midnight, and Friday 5PM EST/EDT becomes Saturday 12AM. Then you’ll have exactly 5 daily candles. There are a few brokers that provide this “time zone”, including FxPro, FXDD, Hotforex. On their daily charts you won’t see that (usually) short Sunday candle.

To summarize, during US Eastern time it’s UTC + 2, during US Eastern daylight saving time it’s UTC + 3. Since you’ve already have EST/EDT, you simply shift it 7 hours forward, uniformly.

Oh BTW the currency close prices you found in the Wall Street Journal everyday are also based on New York Close, i.e., the last price right before 5PM New York time.

More information here: http://www.investopedia.com/ask/answers/05/forexclosingprice.asp#axzz2MzwJ6wPl
and http://www.learntotradethemarket.com/meta-trader-demo-account-sign-up-new-york-close-charts

Thank you!

[imported_tickstoryParticipant March 9, 2013 at 9:37 am Post count: 1479]

#18636

Hi Jack,

Thanks for the further information. This item has been added to the todo list (TICKLITE-88) – it wont make it for the v0.8 release but hopefully the next.

Regards.

[jacktParticipant March 10, 2013 at 1:37 pm Post count: 7]

#18638

That’s wonderful. Thank you! 😀

[boerseunParticipant March 11, 2013 at 8:13 am Post count: 4]

#18637

Yes please, I would also very much appreciate it if this feature could be added.

Thank you

[imported_tickstoryParticipant March 23, 2013 at 12:40 am Post count: 1479]

#18639

Hi boersun,

This feature has been implemented in 0.8.1. You can find out further information here:

viewtopic.php?f=2&t=138

Due to the fact that it was released alongside a pressing fix, only rudimentary testing has been done. Appreciate your feedback to see if it performs as you expect.

Regards.

[jacktParticipant March 24, 2013 at 3:26 pm Post count: 7]

#18640

@tickstory wrote:

Hi boersun,

This feature has been implemented in 0.8.1. You can find out further information here:

viewtopic.php?f=2&t=138

Due to the fact that it was released alongside a pressing fix, only rudimentary testing has been done. Appreciate your feedback to see if it performs as you expect.

Regards.

Thanks for the update. I checked all 1-min candles from AUDCAD and compared the results with those from my own program. They are identical. Awesome job.

May I ask another favor of you? Is it possible to add an option (when exporting to CSV) to either round the volume numbers or make them flat at some constant level? The reason I asked is because ForexTester only allows volume in whole number (http://www.forextester.com/forum/viewtopic.php?t=3437&sid=6b01f9636701b9b657c963c93bb92293).

Thanks and regards,

Jack

[imported_tickstoryParticipant March 24, 2013 at 10:25 pm Post count: 1479]

#18641

Hi Jack,

Thanks for the feedback.

Regarding the volume, you can format the output of the volume to whatever you choose. For your purposes, use the following custom format to output the volume:

{BarBeginTime:yyyyMMdd},{BarBeginTime:HH:mm:ss},{Open},{High},{Low},{Close},{Volume:0}

This will format the volume as a whole number by using the specifier {Volume:0}.

Alternatively, if you just want a set number to appear, you can simply just put whatever number you like in the volume column:

{BarBeginTime:yyyyMMdd},{BarBeginTime:HH:mm:ss},{Open},{High},{Low},{Close},1

Please refer to the section of Exporting to file in the manual for further information.

If you let us know the final custom format that works for you, it can possibly be added as a “quick pick” item in the future.

Regards.

[jacktParticipant March 25, 2013 at 2:59 am Post count: 7]

#18642

@tickstory wrote:

Hi Jack,

Thanks for the feedback.

Regarding the volume, you can format the output of the volume to whatever you choose. For your purposes, use the following custom format to output the volume:

{BarBeginTime:yyyyMMdd},{BarBeginTime:HH:mm:ss},{Open},{High},{Low},{Close},{Volume:0}

This will format the volume as a whole number by using the specifier {Volume:0}.

Alternatively, if you just want a set number to appear, you can simply just put whatever number you like in the volume column:

{BarBeginTime:yyyyMMdd},{BarBeginTime:HH:mm:ss},{Open},{High},{Low},{Close},1

Please refer to the section of Exporting to file in the manual for further information.

If you let us know the final custom format that works for you, it can possibly be added as a “quick pick” item in the future.

Regards.

Thanks a lot! Yes I was thinking about some “quick pick” ideas as well. For ForexTesters the Time column has no colons, so it’s

{BarBeginTime:yyyyMMdd},{BarBeginTime:HHmmss},{Open},{High},{Low},{Close},{Volume:0}

Or you could let users specify their favorite formats and assign names to them maybe?

Thanks and regards,

[Author]

Posts