Excel for updating zones - EasyLanguage Programming | futures.io
futures.io futures trading

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Platforms and Indicators > TradeStation > EasyLanguage Programming

Excel for updating zones
Started:May 8th, 2010 (05:26 PM) by Avartanian Views / Replies:2,679 / 2
Last Reply:August 25th, 2011 (01:35 PM) Attachments:0

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • 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, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Excel for updating zones

Old May 8th, 2010, 05:26 PM   #1 (permalink)
Just starting out...
Futures 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:

Old May 8th, 2010, 05:27 PM   #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.


Old August 25th, 2011, 01:35 PM   #3 (permalink)
Trading Apprentice
charlotte, nc
Futures 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 > Futures Trading, News, Charts and Platforms > Platforms and Indicators > TradeStation > EasyLanguage Programming > Excel for updating zones

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

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

All times are GMT -4. The time now is 01:18 PM.

Copyright © 2016 by 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 2016-10-27 in 0.09 seconds with 19 queries on phoenix via your IP