NexusFi: Find Your Edge


Home Menu

 





Export volume date to excel


Discussion in Emini and Emicro Index

Updated
      Top Posters
    1. looks_one Flyboy1966 with 4 posts (3 thanks)
    2. looks_two Barz with 2 posts (2 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 xplorer with 1 posts (4 thanks)
      Best Posters
    1. looks_one xplorer with 4 thanks per post
    2. looks_two iantg with 4 thanks per post
    3. looks_3 Barz with 1 thanks per post
    4. looks_4 Flyboy1966 with 0.8 thanks per post
    1. trending_up 1,491 views
    2. thumb_up 13 thanks given
    3. group 3 followers
    1. forum 8 posts
    2. attach_file 1 attachments




 
Search this Thread

Export volume date to excel

  #1 (permalink)
 Flyboy1966 
Chiang Mai Thailand
 
Experience: Intermediate
Platform: NinjaTrader 8
Broker: Ninjatrader/Philips
Trading: YM
Posts: 16 since Jun 2018
Thanks Given: 14
Thanks Received: 6

Hi, I would like to export volume data to create bar graphs etc for YM (or any instrument) in excel. Would like to be able to compare hour of day, day of week similar to what the strategy analyzer does. Thanks very much..

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Futures True Range Report
The Elite Circle
Better Renko Gaps
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Exit Strategy
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
Battlestations: Show us your trading desks!
26 thanks
The Program
18 thanks
  #3 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,944 since Sep 2015
Thanks Given: 15,446
Thanks Received: 15,291



Flyboy1966 View Post
Hi, I would like to export volume date to create bar graphs etc for YM (or any instrument) in excel. Would like to be able to compare hour of day, day of week similar to what the strategy analyzer does. Thanks very much..

If it's for NinjaTrader, I don't know a native way to do this.

Here's a few pointers

https://forum.ninjatrader.com/forum/ninjatrader-7/platform-technical-support/47682-exporting-price-and-indicator-data-from-chart?t=46521

https://forum.ninjatrader.com/forum/ninjatrader-8/platform-technical-support-aa/99661-exporting-everything-i-have-on-chart


Reply With Quote
  #4 (permalink)
 Flyboy1966 
Chiang Mai Thailand
 
Experience: Intermediate
Platform: NinjaTrader 8
Broker: Ninjatrader/Philips
Trading: YM
Posts: 16 since Jun 2018
Thanks Given: 14
Thanks Received: 6


xplorer View Post
If it's for NinjaTrader, I don't know a native way to do this.

Here's a few pointers

https://forum.ninjatrader.com/forum/ninjatrader-7/platform-technical-support/47682-exporting-price-and-indicator-data-from-chart?t=46521

https://forum.ninjatrader.com/forum/ninjatrader-8/platform-technical-support-aa/99661-exporting-everything-i-have-on-chart


Yes it is for Nt 8

Started this thread Reply With Quote
Thanked by:
  #5 (permalink)
 
Barz's Avatar
 Barz 
Kansas City, MO/US
 
Experience: Beginner
Platform: NinjaTrader
Trading: Futures
Posts: 18 since Jul 2018
Thanks Given: 35
Thanks Received: 15

Could you offer more details on what you want to do? From your post I can't tell. You say "similar to Strategy Analyzer." What do you mean by this? You say, "export volume data to create bar graphs." I'm confused. You need more than volume data to create a bar graph, don't you?

Reply With Quote
Thanked by:
  #6 (permalink)
 Flyboy1966 
Chiang Mai Thailand
 
Experience: Intermediate
Platform: NinjaTrader 8
Broker: Ninjatrader/Philips
Trading: YM
Posts: 16 since Jun 2018
Thanks Given: 14
Thanks Received: 6


Barz View Post
Could you offer more details on what you want to do? From your post I can't tell. You say "similar to Strategy Analyzer." What do you mean by this? You say, "export volume data to create bar graphs." I'm confused. You need more than volume data to create a bar graph, don't you?

Sure...

First off, I realize that Date should be Data.... fumble fingers... lol's

Mataf.net has some cool stuff for forex ( https://www.mataf.net/en/forex/tools/volatility ) which is exactly what I would like....

I think it would be relatively simple to go thru a specific time frame on one instrument and get an actual number of the volume such as what the volume indicator tells you when you click on a specific volume bar. Export these values out into excel and create my own bars.... The strategy analyzer does this as well with the day of week, or hour, or half hour etc.

Started this thread Reply With Quote
Thanked by:
  #7 (permalink)
 
Barz's Avatar
 Barz 
Kansas City, MO/US
 
Experience: Beginner
Platform: NinjaTrader
Trading: Futures
Posts: 18 since Jul 2018
Thanks Given: 35
Thanks Received: 15


Flyboy1966 View Post
Sure...

First off, I realize that Date should be Data.... fumble fingers... lol's

Mataf.net has some cool stuff for forex ( https://www.mataf.net/en/forex/tools/volatility ) which is exactly what I would like....

I think it would be relatively simple to go thru a specific time frame on one instrument and get an actual number of the volume such as what the volume indicator tells you when you click on a specific volume bar. Export these values out into excel and create my own bars.... The strategy analyzer does this as well with the day of week, or hour, or half hour etc.

Alright, let me see if I have this straight. Sounds like there are two things you're trying to do:

1) You want to export volume data
2) You want to rescale it so you can see daily volume, weekly volume, monthly volume, etc.

If I understand correctly, you really don't want to try rescaling data in Excel unless you're an expert Excel programmer. Instead you might want to consider adding the different dataseries timescales to the same chart in NinjaTrader (hourly, daily, weekly, monthly,e tc.) and then you could create an indicator to export the volume from each series into a file. Then you might be able to import that into Excel and do something with it.

Reply With Quote
Thanked by:
  #8 (permalink)
 iantg 
charlotte nc
 
Experience: Advanced
Platform: My Own System
Broker: Optimus
Trading: Emini (ES, YM, NQ, ect.)
Posts: 408 since Jan 2015
Thanks Given: 90
Thanks Received: 1,147

I got you bro... Just try this. Run this as a strategy with whatever instrument, time frame you want in market replay.
Just open an output window and this will print to your output window.

Once you have ran this for a day or whatever, just hit control A (to select all), then control C (to copy it).
From here paste it into excel. It will hit excel all in one column, so you will need to delimit it. I have delimiter logic built in.... Just hit Data > Text to Columns > Delimited > Other > and finally type the delimiter /

If you look at the code this is what I used to separate each column

Print(
Time[0] +"/"+
Time[0].Hour +"/"+
Time[0].Minute +"/"+
Time[0].Second +"/"+
Time[0].Millisecond +"/"+
GetCurrentBid() +"/"+
GetCurrentAsk() +"/"+
GetCurrentBidVolume() +"/"+
GetCurrentAskVolume() +"/"+
cumvol);

Piece of cake, play with it, hack a way, reverse engineer it, add to it etc.

Happy analyzing!

Ian

In the analytical world there is no such thing as art, there is only the science you know and the science you don't know. Characterizing the science you don't know as "art" is a fools game.
Attached Files
Elite Membership required to download: BasicLevelChange.cs
Visit my NexusFi Trade Journal Reply With Quote
  #9 (permalink)
 Flyboy1966 
Chiang Mai Thailand
 
Experience: Intermediate
Platform: NinjaTrader 8
Broker: Ninjatrader/Philips
Trading: YM
Posts: 16 since Jun 2018
Thanks Given: 14
Thanks Received: 6


iantg View Post
I got you bro... Just try this. Run this as a strategy with whatever instrument, time frame you want in market replay.
Just open an output window and this will print to your output window.

Once you have ran this for a day or whatever, just hit control A (to select all), then control C (to copy it).
From here paste it into excel. It will hit excel all in one column, so you will need to delimit it. I have delimiter logic built in.... Just hit Data > Text to Columns > Delimited > Other > and finally type the delimiter /

If you look at the code this is what I used to separate each column

Print(
Time[0] +"/"+
Time[0].Hour +"/"+
Time[0].Minute +"/"+
Time[0].Second +"/"+
Time[0].Millisecond +"/"+
GetCurrentBid() +"/"+
GetCurrentAsk() +"/"+
GetCurrentBidVolume() +"/"+
GetCurrentAskVolume() +"/"+
cumvol);

Piece of cake, play with it, hack a way, reverse engineer it, add to it etc.

Happy analyzing!

Ian

Thank you Ian,

I will give that a shot and play with it. Just starting to get into working with ninjascript (C#) so this should be fun.

Michael

Started this thread Reply With Quote




Last Updated on November 30, 2018


© 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
no new posts