NexusFi: Find Your Edge


Home Menu

 


Quotes by TradingView
Go Back   >  Search Forums  > 

Showing results 1 to 16 of 16
Search: Posts Made By: Hinneni
Forum: Treasury Notes and Bonds October 3rd, 2016, 06:30 PM
Replies: 53
Views: 17,444
Posted By Hinneni
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...
Forum: Treasury Notes and Bonds October 3rd, 2016, 05:25 PM
Replies: 53
Views: 17,444
Posted By Hinneni
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
Forum: Treasury Notes and Bonds October 3rd, 2016, 04:18 PM
Replies: 53
Views: 17,444
Posted By Hinneni
NR4

I want to be able to notice the narrowest range of the last four sessions and when it occurs for that cell to change in appearance

I attached a screen shot of a spreadsheet for ZF
Forum: Treasury Notes and Bonds October 2nd, 2016, 03:31 AM
Replies: 53
Views: 17,444
Posted By Hinneni
NR4 in excel

How would I write a function where the cell containing the narrowest range of the last four days turns red or something else to signal it in another way?


Thanks in Advance :thumb:
Forum: Treasury Notes and Bonds October 1st, 2016, 03:56 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Much Thanks!!!

Belated Happy Birthday

Kind of getting more used to using Excel

It is fun to theorize about market activity and crunch numbers


thanks again
Forum: Treasury Notes and Bonds September 15th, 2016, 07:03 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Not to beat a dead horse but...

INT(A1)+((A1-INT(A1))/0.005/64) or INT(A1)+(A1-INT(A1))*3.125

in the above formulas what is the reason for 0.005/64 or *3.125

I was breaking things down and am curious?



...
Forum: Treasury Notes and Bonds September 13th, 2016, 09:43 AM
Replies: 53
Views: 17,444
Posted By Hinneni
I think I am getting it

I plugged in Explorers function and it is working... I seem to be making things more difficult

I went over the thread closer and it helped it clear things up

I admit that I do not fully grasp...
Forum: Treasury Notes and Bonds September 12th, 2016, 11:23 PM
Replies: 53
Views: 17,444
Posted By Hinneni
So 131,120 = 131 + 24/64 = 131.375 ...

So 131,120 = 131 + 24/64 = 131.375 that would be the basic arithmetic...I thought there was some ecel function or something

High 132 - Low 131,095 (131 + 19/64) 131.296875 ...
Forum: Treasury Notes and Bonds September 12th, 2016, 09:33 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Much thanks for your help! So in ZN, ZB,ZF ...

Much thanks for your help!

So in ZN, ZB,ZF I am having trouble entering in the values in Excel (which way to format the cells)
I think I see what you are saying... so in the ZN contract it...
Forum: Treasury Notes and Bonds September 12th, 2016, 08:00 AM
Replies: 53
Views: 17,444
Posted By Hinneni
Attempting to Revive this Thread

Hi Im still banging my head against the wall... Its a sickness :becky:

A ZN price as I take it from my chart in ninjatrader

Open 131,120 High 132,000 Low 131,095 Close ...
Forum: Treasury Notes and Bonds April 5th, 2016, 11:52 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Much Thanks

Thank you for the sheet and the advice! How did you import the data? I usually just eyeball it, day to day
using a zig zag indicator and manually recording the values (it is laborious).
Forum: Treasury Notes and Bonds March 25th, 2016, 12:30 AM
Replies: 53
Views: 17,444
Posted By Hinneni
A big Thanks!

The spreadsheet is great thanks! I am curious if I am interpreting it correctly? On a 5 minute timeframe, it resoundingly moves in 5 tick advance or decline moves in 9 bars?
Forum: Treasury Notes and Bonds March 22nd, 2016, 03:55 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Thank You

Wow Thanks

I watch 5 minute charts... I do scale down from 30 minute for Swing High/Lows and low volume zones.
Also, I have been looking at Point and Figure charts (1000 tick 3 reversal, 5...
Forum: Treasury Notes and Bonds March 22nd, 2016, 02:04 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Thank You

Thanks guys for all the replies...it has steered me on the right track...

Btw, any advice on figuring out the rotations on ZN contracts. What I mean is the impulse/retracement (give and go)...
Forum: Treasury Notes and Bonds March 16th, 2016, 07:16 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Thank You

I am curious how to set this up in a spreadsheet...to record daily fluctuations etc?


Sorry so green
Forum: Treasury Notes and Bonds March 15th, 2016, 10:46 PM
Replies: 53
Views: 17,444
Posted By Hinneni
Spreadsheet Advice for ZN pricing

I apologize in advance. This is a basic question. I am looking to add Ten Year (ZN) Note futures prices to a spreadsheet and am not sure how to proceed. the ZN contract is priced different then...
Showing results 1 to 16 of 16

What unexpected challenges have you encountered while trading on a "Funded Trader" platform?

View Results Discuss Poll
 

 
 


© 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