Kline Candlestick Time Interval Formula - futures io
futures io



Kline Candlestick Time Interval Formula


Discussion in Traders Hideout

Updated
    1. trending_up 525 views
    2. thumb_up 0 thanks given
    3. group 2 followers
    1. forum 3 posts
    2. attach_file 2 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Kline Candlestick Time Interval Formula

(login for full post details)
  #1 (permalink)
 nothingbutprofits 
rochester new york/USA
 
Experience: Advanced
Platform: ThinkOrSwim & NT
Broker: NT, TOS
Trading: ES NQ RTY CL NG
 
nothingbutprofits's Avatar
 
Posts: 17 since Feb 2021
Thanks: 62 given, 3 received

Hi everyone,

I'm working on my own data analysis using the ticks OCHLV data which I converted to 1m OCHLV records.

I'm wondering if it's possible for anyone to provide the feedback on the candlestick equations to make sure that the details below is correct.

Time Intervals:
m -> minutes; h -> hours; d -> days; w -> weeks; M -> months
Interval time formats: 1m, 3m, 5m, 15m, 30m, 1h, 2h, 4h, 6h, 8h, 12h, 1d, 1w, 1M

OCHLV:
O = Open
C = Close
H = High
L = Low
V = Volume

If the interval time request is 3m (3 minutes), it means that the 1m OCHLV data will pull 3 (THREE) 1m OCHLV records from database, then use the OCHLV formulas (see below) to calculate the 1m OCHLV values in order to display the 3m OCHLV values.

OCHLV Formulas: (based on n as total minutes request.)

Example: 3m = n, which n would be 3, only used for reference here.

1st 1m O + 2nd 1m O + 3rd 1m O = 3m Open
n (based on 3m)

1st 1m C + 2nd 1m C + 3rd 1m C = 3m Close
n (based on 3m)

1st 1m H + 2nd 1m H + 3rd 1m H = 3m High
n (based on 3m)

1st 1m L + 2nd 1m L + 3rd 1m L = 3m Low
n (based on 3m)

1st 1m V + 2nd 1m V + 3rd 1m V + nV = 3m Total Volume based on n minutes

Please let me know if the above information is correct.

Thanks!

Started this thread Reply With Quote

Journal Challenge April 2021 results (now extended!):
Competing for $1800 in prizes from Jigsaw
looks_oneMaking a Living with the Microsby sstheo
(172 thanks from 21 posts)
looks_twoSalao's Journalby Salao
(48 thanks from 11 posts)
looks_3Deetee’s DAX Trading Journal (time based)by Deetee
(35 thanks from 18 posts)
looks_4Learning to Profit - A journey in algorithms and optionsby Syntax
(15 thanks from 13 posts)
looks_5Maybe a little bit different journalby Malykubo
(14 thanks from 14 posts)
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Big Mike in Ecuador
76 thanks
The Crude Dude Oil Trading System
57 thanks
Would You Sell Your System?
57 thanks
The New Micro Contract - MICRO BITCOIN coming May 2021
25 thanks
Help improve the FIO community
23 thanks
 
(login for full post details)
  #2 (permalink)
 hedgeplay 
Austin Texas / US
 
Experience: Intermediate
 
Posts: 23 since Dec 2019
Thanks: 54 given, 13 received

Hi,

Just wanted to add a few ideas as food for thought.

If I read your post correctly.

----------------------------

Keep of count of 1min bars as they pass so you know when you see a "1m" and a "3m" bar.


Then:

For High and Low it is not addition of the three but which was the Highest and which one of the three was the Lowest.

So set "1m" as the starting High and Low and check of the next two bars to see if the "1m" gets disrupted from either the High or Low position.


For Open is just one of the three bars, Open on the "1m".

For Close is just one of the three bars, Close on the "3m".


HedgePlay

Reply With Quote
 
(login for full post details)
  #3 (permalink)
 hedgeplay 
Austin Texas / US
 
Experience: Intermediate
 
Posts: 23 since Dec 2019
Thanks: 54 given, 13 received


Bonus round!

Beyond what you asked if I was going to go to all the trouble you list in your post I would consider adding the two additional series.

A classic problem with OCHL bars is they, depending on how you are using them, are sometimes inaccurate because they "Lose" range of movement when price jumps / gaps between the Close of one bar and Open of the next.

If you want full range of movement create then create a True Range OHLC, use the same formulas use to derive "True Range".

The Open for your three minute bar is not the Open of 1m but the Close of the just previous 3m bar. This way all the range that happened since the last 3m bar will be included in this new 3m bar.

HedgePlay

Reply With Quote
 
(login for full post details)
  #4 (permalink)
 nothingbutprofits 
rochester new york/USA
 
Experience: Advanced
Platform: ThinkOrSwim & NT
Broker: NT, TOS
Trading: ES NQ RTY CL NG
 
nothingbutprofits's Avatar
 
Posts: 17 since Feb 2021
Thanks: 62 given, 3 received


hedgeplay View Post
Bonus round!

Beyond what you asked if I was going to go to all the trouble you list in your post I would consider adding the two additional series.

A classic problem with OCHL bars is they, depending on how you are using them, are sometimes inaccurate because they "Lose" range of movement when price jumps / gaps between the Close of one bar and Open of the next.

If you want full range of movement create then create a True Range OHLC, use the same formulas use to derive "True Range".

The Open for your three minute bar is not the Open of 1m but the Close of the just previous 3m bar. This way all the range that happened since the last 3m bar will be included in this new 3m bar.

HedgePlay

Thanks for the clarification. I understand clearly.

Here are the pictures I drew up based on your description, which makes sense.





Many thanks!

Started this thread Reply With Quote


futures io Trading Community Traders Hideout > Kline Candlestick Time Interval Formula


Last Updated on April 3, 2021


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge w/$1,800 in prizes!

April
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts