NexusFi: Find Your Edge


Home Menu

 





building 200 days database for S\R lines


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one ELDI with 3 posts (0 thanks)
    2. looks_two Lornz with 2 posts (1 thanks)
    3. looks_3 trendisyourfriend with 1 posts (0 thanks)
    4. looks_4 Fat Tails with 1 posts (0 thanks)
    1. trending_up 4,185 views
    2. thumb_up 1 thanks given
    3. group 3 followers
    1. forum 7 posts
    2. attach_file 1 attachments




 
Search this Thread

building 200 days database for S\R lines

  #1 (permalink)
 ELDI 
haifa israel
 
Experience: Intermediate
Platform: TA
Trading: ES
Posts: 46 since Apr 2011
Thanks Given: 16
Thanks Received: 3

Hi
I would like to build a 200 days database so i can calculate s/r lines from it (calculate the ATR of each day) . I know that QCollector does this work. is there a good freeware that does the same work? does gommiCD do the same thing? or else how do i do such calculation?

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Ninja Trader 8 Drawing Tools Wanted
NinjaTrader
ZombieSqueeze
Platforms and Indicators
Funded Trader platforms
Traders Hideout
Request for MACD with option to use different MAs for fa …
NinjaTrader
NexusFi Journal Challenge - May 2024
Feedback and Announcements
 

  #3 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102



ebdvi View Post
Hi
I would like to build a 200 days database so i can calculate s/r lines from it (calculate the ATR of each day) . I know that QCollector does this work. is there a good freeware that does the same work? does gommiCD do the same thing? or else how do i do such calculation?

I do not know what you want to do with it, but if you are looking for an average daily range, you could just add the Volatility Bands indicator to a NinjaTrader chart.

It will display

-> the average daily range for a period 1 (example 50 business days)
-> the average daily range for a period 2 (example 100 business days)

and then subtract/add that amount to the current daily high/low to display a target for the current day's price action.

Only restriction: This indicator does not use the average true range, but the average daily range (no adjustment made for gaps).

Attached Thumbnails
Click image for larger version

Name:	ES 12-11 (5 Min)  30_11_2011.jpg
Views:	203
Size:	113.5 KB
ID:	56022  
Reply With Quote
  #4 (permalink)
 ELDI 
haifa israel
 
Experience: Intermediate
Platform: TA
Trading: ES
Posts: 46 since Apr 2011
Thanks Given: 16
Thanks Received: 3

thank you very much Fat tails
actually i need something different.
i want to take a data base of the last 200 days, and then write a program that will calculate for each day the difference between the open and the high of the day and the open and the low of this day - and then calculate the average price - for the highs and the lows of 200 days.
the question is again - where can i find or how do i build a data base of the open/high/low of the last 200 days?
full of respect and thanks to your will to help
Ebdvi

Started this thread Reply With Quote
  #5 (permalink)
 
Lornz's Avatar
 Lornz 
Oslo, Norway
 
Experience: Advanced
Platform: CQG, Excel
Trading: CL
Posts: 1,193 since Apr 2010

It would be very easy to accomplish this with QCollector and Excel.

Visit my NexusFi Trade Journal Reply With Quote
  #6 (permalink)
 ELDI 
haifa israel
 
Experience: Intermediate
Platform: TA
Trading: ES
Posts: 46 since Apr 2011
Thanks Given: 16
Thanks Received: 3

Thanks Lorenz
could you say some more - how to do it?
is there a freeware that does the work (apart from Q collector)?
thanks again

Started this thread Reply With Quote
  #7 (permalink)
 
Lornz's Avatar
 Lornz 
Oslo, Norway
 
Experience: Advanced
Platform: CQG, Excel
Trading: CL
Posts: 1,193 since Apr 2010

If you don't require finer granularity than daily OHLC, you can just use Yahoo (e.g.). It depends on which symbols you want.

If you're using IQFeed, you can download a free trial of XLQplus....

Visit my NexusFi Trade Journal Reply With Quote
  #8 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,526 since Oct 2009
Thanks Given: 4,167
Thanks Received: 6,018


ebdvi View Post
Hi
I would like to build a 200 days database so i can calculate s/r lines from it (calculate the ATR of each day) . I know that QCollector does this work. is there a good freeware that does the same work? does gommiCD do the same thing? or else how do i do such calculation?

I know you have asked for a freeware but this guy here might have what you are looking for:
Rancho Dinero | Acme Market Study & Data Export Pack

Or with I/RT (very interesting stuff here):
Investor/RT - Homework, Research, Statistics

Reply With Quote





Last Updated on December 14, 2011


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts