Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Trading: The one I'm creating in the present....Index Futures mini/micro, ZF
Posts: 2,311 since Nov 2011
Thanks Given: 7,341
Thanks Received: 4,518
Totally willing.... And you will be able to soon too. In a few years you will amaze yourself.
Collaborating everybody wins.
What version of Microsoft Excel do you have?
Just in the past few months I upgraded to Office360 for $35 what a great steal for all my machines and devices and that's the total price for a year with 1TB (with a "T") storage on OneDrive. I like the changes I see in Excel Pivot Tables and the new "IFS" function to name a few things.
Are you able to get data into Excel from TS?
Ron
...My calamity is My providence, outwardly it is fire and vengeance, but inwardly it is light and mercy...
The steed of this Valley is pain; and if there be no pain this journey will never end.
Buy Low And Sell High (read left to right or right to left....lol)
3) Import the .txt file into Excel [or whatever spreadsheet program you use]
That's about it
TGN
**Note** I don't want to steal this conversation, @Blash is doing great work with you here @Hinneni,
I just posted this to explain how I downloaded a small amount of data into Excel to show you the =DOLLARFR function.
Trade Well,
TGN
R.I.P. John Bottomley (Botts), 1956-2022.
Please visit this thread for more information.
Trading: The one I'm creating in the present....Index Futures mini/micro, ZF
Posts: 2,311 since Nov 2011
Thanks Given: 7,341
Thanks Received: 4,518
This is helpful but reasonably out of reach for most people IMHO.
The issue with this method of exporting data from NT and importing into Excel is that is gives you info that is much harder to use for perhaps someone new to doing this and working with market data in Excel. It's every single trade where a typical ES day of tick trade data produces over 300,000 Excel rows and its just more work to turn it into bar data.
StreamWriter is an easier way than this..... and Rainbow tools easier still ...by a lot.....
Hi Im still banging my head against the wall... Its a sickness
A ZN price as I take it from my chart in ninjatrader
Open 131,120 High 132,000 Low 131,095 Close 131,315.... I used the 24 hour day
When I subtract the High and Low for the range, I get 905? Im still having problems formatting the spreadsheets and conceptualizing the daily movements. the ZN did not move 905 ticks for August 29th?
I know it has been discussed before, but could we please go over it again