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 9 of 9
Filter subforums listed
Search:
Posts Made By:
xplorer
Forum:
Treasury Notes and Bonds
October 4th, 2016, 05:21 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
As long as it works... you can always think about...
As long as it works... you can always think about beautifying it later :)
Forum:
Treasury Notes and Bonds
October 3rd, 2016, 05:31 PM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
Correct Excel simplifies that for you...
Correct
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)...
Forum:
Treasury Notes and Bonds
October 3rd, 2016, 05:15 PM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
The spreadsheed attached does not contain dates,...
The spreadsheed attached does not contain dates, so I am going to assume that the 'last four sessions' are the 4 top ones.
What you are looking for is the type of Conditional Formatting...
Forum:
Treasury Notes and Bonds
October 2nd, 2016, 05:42 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
In general you can use Conditional Formatting in...
In general you can use Conditional Formatting in Excel to get cells to change appearance based on values or a formula.
Can you post a screenshot of the cells and headings you want to change, to...
Forum:
Treasury Notes and Bonds
September 28th, 2016, 10:29 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
I guessed as much. To do away with the complexity...
I guessed as much. To do away with the complexity I tend to create extra columns, so instead of having one big formula I have a series of smaller formulae and then I hide the columns I don't need.
...
Forum:
Treasury Notes and Bonds
September 28th, 2016, 10:11 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
Live & learn indeed... there's also the User...
Live & learn indeed... there's also the User Defined functions (http://www.wikihow.com/Create-a-User-Defined-Function-in-Microsoft-Excel) that one can create in Excel, but to be honest I can't be...
Forum:
Treasury Notes and Bonds
September 28th, 2016, 08:52 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
Thanks TGN, I wasn't familiar with these 2...
Thanks TGN, I wasn't familiar with these 2 functions.
Forum:
Treasury Notes and Bonds
September 13th, 2016, 10:10 AM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
Hinneni Basically with this instrument to...
Hinneni
Basically with this instrument to get from ticks to dollars you just multiply the tick value by 15.625
Forum:
Treasury Notes and Bonds
September 12th, 2016, 12:30 PM
Replies:
53
Spreadsheet Advice for ZN pricing
Views:
17,560
Posted By
xplorer
This is the Excel formula I use for T-notes (10...
This is the Excel formula I use for T-notes (10 Y)
...
Showing results 1 to 9 of 9
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.