Dark
Theme
Light
Theme
Register
Username or Email
Username or Email
Password
Password
Forgot
Signup
Forgot
Browse
Register
Downloads / Indicators
Articles
Upgrade to Elite
Unanswered Posts
My Posts
Return to Homepage
Today's Posts
Trading Reviews and Vendors
Futures Brokers Reviews
Traders Hideout (general)
Platforms and Indicators
Trading Journals
Elite Trading Journals
Psychology and Money Management
Off-Topic
The Elite Circle
Webinars
Trading Articles
Main Trading Articles Index
Article Categories
Help, Tutorials, How-To's
Traders and Trading Methods
Platforms, Tools and Indicators
Terms (Glossary)
Article Tools
List New Articles
List Recent Article Changes
Random Article
Most Popular Articles
Category Groupings
Wanted Articles
Most Linked to from Forum
Go to Page...
Quotes
by TradingView
>
Search Forums
>
Showing results 1 to 8 of 8
Filter subforums listed
Search:
Posts Made By:
SMCJB
Forum:
Treasury Notes and Bonds
September 28th, 2016, 10:20 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
I use a lot of user defined functions, saves...
I use a lot of user defined functions, saves rewriting long functions and makes reading my own spreadsheets a lot easier.
One word of caution, VBA functions actually compute significantly slower...
Forum:
Treasury Notes and Bonds
September 28th, 2016, 10:07 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
Yeah me either. Live & Learn
Yeah me either. Live & Learn
Forum:
Treasury Notes and Bonds
September 16th, 2016, 09:14 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
Since the price is quoted in 64ths and not...
Since the price is quoted in 64ths and not decimals, we first need to know how many 64ths we have and then convert that to decimals. We find out how many 64ths we have by first dividing by 0.005 and...
Forum:
Treasury Notes and Bonds
September 13th, 2016, 10:16 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
Oh yeah.. that's kind of important! I never...
Oh yeah.. that's kind of important! I never mentioned that!
Forum:
Treasury Notes and Bonds
September 13th, 2016, 09:55 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
This bit... (INT(J2)*64+(J2-INT(J2))/0.005) ......
This bit... (INT(J2)*64+(J2-INT(J2))/0.005) ... turns the price in cell J2 into "number of ticks" price. Hence since minimum price increment is 1/64 then a price of 131 becomes 131*64 = 8384. It...
Forum:
Treasury Notes and Bonds
September 12th, 2016, 10:06 PM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
You could just convert everything to a decimal by...
You could just convert everything to a decimal by using something similar to what xplorer's posted.
Specifically if your price is in Cell A1 then my decimal price would be...
Forum:
Treasury Notes and Bonds
September 12th, 2016, 11:13 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
It's quoted in 32nds, but you can trade half...
It's quoted in 32nds, but you can trade half points (which are then 64ths). So
Open 131,120 = 131 +12/32 [or 131.375 decimal]
High 132 = 132 [or 132 decimal]
Low 131,095 = 131 + 9.5/32 (same as...
Forum:
Treasury Notes and Bonds
March 16th, 2016, 08:09 PM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,444
Posted By
SMCJB
I believe that you will find today's settle...
I believe that you will find today's settle 129'095 is equivalent to 129 & 9.5/32nds (which is of course equal to 129 & 19/64ths) which is equal to 129.296875 in decimal.
Showing results 1 to 8 of 8
What unexpected challenges have you encountered while trading on a "Funded Trader" platform?
Limited trading instruments
High platform usage fees
Lack of support or mentorship
Unrealistic rules and requirements
No significant challenges
Something else (discuss in thread)
View Results
Discuss Poll
futures io is now NexusFi
Trading Webinars How-to's
Trading Reviews & Products
Join Markets Chat waitlist
NinjaTrader Brokerage (Broker)
Ninja Mobile Trader (Server Hosting)
Apex Trader Funding (Prop Trading)
Tradovate (Trading Platform)
NinjaTrader (Trading Platform)
SharkIndicators (Trading Software)
© 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.