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


Spreadsheet Advice for ZN pricing
Started: by Hinneni Views / Replies:2,915 / 53
Last Reply: Attachments:13

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

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: 8 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: 1,795 since Sep 2015
Thanks: 3,263 given, 2,362 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: 8 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: 1,795 since Sep 2015
Thanks: 3,263 given, 2,362 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)

2016 True Edge Awards: Voting is open until Jan 21!

Now
 

Anthony Drager: Pulling the trigger with confidence

Elite only
 

Leo Murphy: The Art and Science of Technical Analysis

Elite only
 

FuturesTrader71: Ask Me Anything

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 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 11:29 AM.

no new posts
Page generated 2017-01-21 in 0.10 seconds with 29 queries on phoenix via your IP 174.129.120.155