NexusFi: Find Your Edge

Home Menu


Excel for updating zones

Discussion in EasyLanguage Programming

    1. trending_up 4,747 views
    2. thumb_up 3 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments

Search this Thread

Excel for updating zones

(login for full post details)
  #1 (permalink)
Posts: 1 since May 2010
Thanks Given: 0
Thanks Received: 1

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:

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:

Can you help answer these questions
from other members on NexusFi?
Futures Close-Out Policy
Platforms and Indicators
Looking for an MQL4 MetaTrader programmer/coder
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
33 thanks
Daytrading ES & NQ
32 thanks
Battlestations: Show us your trading desks!
30 thanks
Spoo-nalysis ES e-mini futures S&P 500
28 thanks
Retail Trading As An Industry
25 thanks

(login for full post details)
  #3 (permalink)
charlotte, nc
Posts: 2 since Aug 2011
Thanks Given: 0
Thanks Received: 0

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

Reply With Quote

Last Updated on August 25, 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