Excel for updating zones - EasyLanguage Programming | futures io social day trading
futures io futures trading

Excel for updating zones
Updated: Views / Replies:3,256 / 2
Created: by Avartanian Attachments:0

Welcome to futures io.

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

futures io is the largest futures trading community on the planet, with over 100,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors – all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you don’t need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

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

Thread Tools Search this Thread

Excel for updating zones

  #1 (permalink)
Just starting out...
Trading Experience: Intermediate
Platform: TradeStation
Broker/Data: Tradestation
Favorite Futures: ES
Posts: 1 since May 2010
Thanks: 0 given, 1 received

Excel for updating zones

Hi everyone,

I am trying to create a link between TradeStation and Excel for the following info to populate based on different symbols. That way it can populate a Zone in Tradestation based on the created info any help would be greatly appreciated:

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Info to populate the data:

Open/High/Low/Close: The Daily, Weekly, and Monthly OHLC are obtained from Tradestation using the “Pit” session for each market unless otherwise noted. The closing price is the settlement price posted in Tradestation.

D2 High/Low: The High and Low from two days ago.

D3 High/Low: The High and Low from three days ago.

Pivots: The Price Guide uses the “Classic” formulas for calculating the floor trader's pivots. The “Pit” session is used for all markets unless otherwise noted. The Daily, Weekly, and Monthly numbers are derived from the same calculations. The formulas below are used to calculate the floor trader's pivots:

R3 = High + 2*(Pivot-Low)
R2 = P + (R1 - S1)
R1 = (2 x P) - L
Pivot (P) = (High + Low + Close) / 3
S1 = (2 x P) - H
S2 = P - (R1 - S1)
S3 = Low - 2*(High-Pivot)

JR1/JS1: These two numbers are derived from the Jackson Zone concept. The formula's are as follows:

BP = Balance Point (Pivot) = (Yesterday High + Low + Close)/3
Range = Yesterday High – Yesterday Low

JR1 = BP + (Range *.50)
JS1 = BP – (Range * .50)

Fibonacci Extensions: The Fibonacci price extensions are calculated as follows:

Range = Yesterday High – Yesterday Low

Yesterday 1.618 = Low + (Range * 1.618)
Yesterday 1.272 = Low + (Range * 1.272)

Yesterday 1.272 = High – (Range * 1.272)
Yesterday 1.618 = High – (Range * 1.618)

Yesterday's Midpoint: (Yesterday High + Yesterday Low) * .50

Market Profile: Market Profile is a graphical organization of price and time information. Market Profile displays price on the vertical axis and time on the horizontal axis. Letters are used to symbolize time brackets. These letters are called TPO's (Time-Price-Opportunity) (CBOT website definition)

The Value Area is the zone where approximately 70% (1 std deviation) of session's price action was recorded.

The Market Profile numbers displayed on the Price Guide are: The Value Area High (VAH), Point of Control (POC), and Value Area Low (VAL).

They are defined as follows:

VAH: The High of the Value Area.
POC: The longest row of TPO's or most common price.
VAL: The Low of the Value Area.

Reply With Quote
The following 3 users say Thank You to Avartanian for this post:
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

  #3 (permalink)
Trading Apprentice
charlotte, nc
Trading Experience: Intermediate
Platform: Tradestation
Favorite Futures: es
Posts: 2 since Aug 2011
Thanks: 0 given, 0 received

Can't help with your question, but could you share the spreadsheet that calculates the chart from your post?

Reply With Quote


futures io > > > > > Excel for updating zones

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

Journal Challenge $1600 in Prizes & Free Journalytix for all participants!


Trading Resolutions for 2019 - Avoiding Mistakes w/GFF Brokers

Feb 19

3 Excellent Entries, and How To Automate Them w/Kevin Davey

Feb 21

The Driving Force Behind the Market w/Earn2Trade

Mar 5

TBA w/Stage5 & iSystems

Mar 12

TBA w/John Grady @ No BS Day Trading

Mar 19

Day Trading Oil Futures: Reducing Risk & Increasing Profits w/DTN IQFeed

Mar 26

Similar Threads
Thread Thread Starter Forum Replies Last Post
Colour time zones indicator nickohorny NinjaTrader 17 June 2nd, 2016 10:21 AM
Jackson Zones max-td The Elite Circle 32 July 8th, 2012 01:42 AM
Charts stop updating TraderJesse NinjaTrader 11 July 29th, 2011 06:12 PM
indicator realtime updating johni MultiCharts 2 July 15th, 2011 05:45 AM
NT7 - NoGapRangeBars not updating hunter548 The Elite Circle 6 January 12th, 2011 08:27 PM

data, easylanguage, es, information, multicharts, neoticker, ohlc, poc, price action, tpo, tradestation, value area

All times are GMT -4. The time now is 02:45 PM. (this page content is cached, log in for real-time version)

Copyright © 2019 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432 WhatsApp Business, 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
Page generated 2019-02-17 in 0.20 seconds with 14 queries on phoenix