Spreadsheet Advice for ZN pricing - Bonds and Interest Rates Trading | futures io social day trading
futures io futures trading


Spreadsheet Advice for ZN pricing
Updated: Views / Replies:4,520 / 53
Created: by Hinneni Attachments:13

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 90,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

Reply
 13  
 
Thread Tools Search this Thread
 

Spreadsheet Advice for ZN pricing

  #51 (permalink)
Elite Member
san diego, CA/usa
 
Futures Experience: Intermediate
Platform: NinjaTrader
Favorite Futures: 6E
 
Posts: 22 since Oct 2014
Thanks: 9 given, 6 received

Thanks

if a range is the smallest of the last four then it should appear red? correct? Isn't there a numerical formula for the cell range?


thanks for answering my questions

Reply With Quote
 
  #52 (permalink)
Market Wizard
London UK
 
Futures Experience: Beginner
Platform: CQG
Favorite Futures: Futures
 
xplorer's Avatar
 
Posts: 3,045 since Sep 2015
Thanks: 6,553 given, 4,810 received
Forum Reputation: Legendary


Hinneni View Post
if a range is the smallest of the last four then it should appear red? correct?

Correct


Quoting 
Isn't there a numerical formula for the cell range?

Excel simplifies that for you with the conditional formatting. Basically by selecting the bottom x (in your case you want the bottom 1 results, i.e. the minimum value of the last four) Excel automatically calculates the minimum result and colors it for you.

Reply With Quote
The following user says Thank You to xplorer for this post:
 
  #53 (permalink)
Elite Member
san diego, CA/usa
 
Futures Experience: Intermediate
Platform: NinjaTrader
Favorite Futures: 6E
 
Posts: 22 since Oct 2014
Thanks: 9 given, 6 received

Question


I need this formula to calculate every four cells only, not to take into account the entire row. Every four it should color the smallest value?

This is probably really simplistic, but I am running into a block


thanks again

Update.....

I created a separate column that takes the MIN of the last 4 cells so I can visually compare them ...then a separate column that says T or F if the last entered range is lower than the lowest range of the last four sessions?

Hardly space efficient but functional


Last edited by Hinneni; October 3rd, 2016 at 09:27 PM.
Reply With Quote
 
  #54 (permalink)
Market Wizard
London UK
 
Futures Experience: Beginner
Platform: CQG
Favorite Futures: Futures
 
xplorer's Avatar
 
Posts: 3,045 since Sep 2015
Thanks: 6,553 given, 4,810 received
Forum Reputation: Legendary


Hinneni View Post

Hardly space efficient but functional

As long as it works... you can always think about beautifying it later

Reply With Quote

Reply



futures io > > > > Spreadsheet Advice for ZN pricing

Thread Tools Search this Thread
Search this Thread:

Advanced Search



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

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
bond pricing, beginner question fishtoeat Bonds and Interest Rates Trading 23 November 21st, 2015 05:38 PM
Good Advice on Bad Advice? afoxperson The Elite Circle 5 February 18th, 2015 11:36 PM
Daily volume on ES and ZN Identical but no Movement on ZN ? lexxmd Bonds and Interest Rates Trading 6 May 12th, 2014 12:54 AM
Can someone help with new TT pricing? Makololo Reviews of Brokers and Data Feeds 0 October 12th, 2013 01:14 PM
Newbie Q: on Grain Pricing JVentura Commodities Futures Trading 4 January 19th, 2011 05:39 PM


All times are GMT -4. The time now is 02:17 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, 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 2017-12-12 in 0.08 seconds with 28 queries on phoenix via your IP 54.163.209.109