NexusFi: Find Your Edge


Home Menu

 





Excel for updating zones


Discussion in EasyLanguage Programming

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




 
Search this Thread
  #1 (permalink)
Avartanian
CA
 
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
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Cycle Through Ninjatrader Open Windows
NinjaTrader
convert to nt8
NinjaTrader
Top Pick Trading reviews?
Trading Reviews and Vendors
What a Cool Draw/Markup Tool!
Traders Hideout
Creating global variables for Ninjatrader
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Vinny E-Mini & Algobox Review TRADE ROOM
8 thanks
Futures spread trading grains education sources?
6 thanks
Just another trading journal: PA, Wyckoff & Trends
4 thanks
Wheres the videos?
3 thanks
Blue wave trading review
2 thanks
  #3 (permalink)
sstamilio
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 - Sitemap - Downloads - Top
no new posts