Download series to Excell regrouped by dates - NinjaTrader Programming | futures io social day trading
futures io futures trading


Download series to Excell regrouped by dates
Updated: Views / Replies:1,043 / 12
Created: by Remo Attachments:0

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 
Thread Tools Search this Thread
 

Download series to Excell regrouped by dates

  #1 (permalink)
Elite Member
Siveria
 
Futures Experience: Intermediate
Platform: Ninja Trader
Broker/Data: Mirus
Favorite Futures: FUTURES
 
Posts: 23 since Dec 2011
Thanks: 2 given, 2 received

Download series to Excell regrouped by dates

Hello, my name is Carlos, a greeting to all, not very well how the forum works, I'm happy to meet you, you are a great help.
I hope to share positive things.



I have a problem with Ninja and I need help.


I try to excel to download data series to make a backtest Combined with several instruments at the same time in Ninja.

Those who know her ninja you know that by optimizing more than one instrument, ninja puts all the data merged into Combined section, but these data can not be analyzed well, since the DD is not real and I would like to download trade to trade with date, profit, loss, etc., in order to analyze well, in excell.

It is possible in some way to dump all series optimized with all the data to excell automatically and regroup for automatic form dates?, And have a complete sequence, and to analyze well?

Please help.

Thank you very much.

Reply With Quote
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

 
  #3 (permalink)
Elite Member
las vegas
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: Velocity/IB
Favorite Futures: 6E
 
Posts: 1,147 since Feb 2010
Thanks: 304 given, 836 received


I've not used them, but I am pretty sure there are tools to do this, do a search for nt excel.

Reply With Quote
 
  #4 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 46,240 since Jun 2009
Thanks: 29,352 given, 83,223 received

There are lots of tools, like this one:

https://futures.io/elite-circle/7307-dionysus-xmas-present-ninja-excel.html

To share data between NT and Excel.

But if I understand correctly, you are wanting to use Strategy Analyzer (not an indicator or individual strategy) to take a group or basket of backtested stocks, and dump all the trade results for the entire basket into Excel.

It is quite interesting you made this post, because I also need to do the same thing for something I'm working on and haven't been able to figure out a way to do it yet.

Basically, it's the creation of portfolio trading which NT lacks.

I need to create a singular equity curve, for example, that consists of all trades in all markets for all strategies (or even a single strategy), and then be able to analyze things like portfolio draw down, portfolio run up, and basically all the other traditional metrics but from a portfolio wide viewpoint.

I will shout at @NinjaTrader to see if I am wrong, but I don't think it's possible as part of NT. And that includes the forthcoming NT8 as well I think, unfortunately. But, anything is possible in C# and that is the route I am exploring. Basically my idea is to use my own SQL database in my strategy to store all the trade performance metrics on my own, and then use Excel to import the SQL data and create my analysis.

Basic info here on that kind of relationship:
https://futures.io/elite-circle/21733-using-excel-query-mysql-database.html

Mike

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following 2 users say Thank You to Big Mike for this post:
 
  #5 (permalink)
Elite Member
Siveria
 
Futures Experience: Intermediate
Platform: Ninja Trader
Broker/Data: Mirus
Favorite Futures: FUTURES
 
Posts: 23 since Dec 2011
Thanks: 2 given, 2 received

Vegasfoster Hello, hello Mike, thanks for help.


If this appears in the Ninja version 8 would be a major improvement for all, to optimize portfolios.

I have seen, if there are several things you can do to volacr excell data, but still do not quite understand, I need help to understand and be able to do.

Simplifying the matter, as I can do to have Excell Ninja connected to the application and trade system in Strategy Analyzer, data from the Trades tab excell overturn the automatic way.

I have two basic questions.

1-How I can connect Ninja + Excell.

2-That lines of code and which part should I write so that all function well and dump the data so the tab --- (Trades-) - to excell and go turning properly.


Greetings to all.

Reply With Quote
 
  #6 (permalink)
Elite Member
Denver, CO
 
Futures Experience: Advanced
Platform: NinjaTrader
Broker/Data: NinjaTrader Brokerage
Favorite Futures: ES
 
NinjaTrader's Avatar
 
Posts: 1,260 since May 2010
Thanks: 153 given, 1,890 received


Big Mike View Post
There are lots of tools, like this one:

https://futures.io/elite-circle/7307-dionysus-xmas-present-ninja-excel.html

To share data between NT and Excel.

But if I understand correctly, you are wanting to use Strategy Analyzer (not an indicator or individual strategy) to take a group or basket of backtested stocks, and dump all the trade results for the entire basket into Excel.

It is quite interesting you made this post, because I also need to do the same thing for something I'm working on and haven't been able to figure out a way to do it yet.

Basically, it's the creation of portfolio trading which NT lacks.

I need to create a singular equity curve, for example, that consists of all trades in all markets for all strategies (or even a single strategy), and then be able to analyze things like portfolio draw down, portfolio run up, and basically all the other traditional metrics but from a portfolio wide viewpoint.

I will shout at @NinjaTrader to see if I am wrong, but I don't think it's possible as part of NT. And that includes the forthcoming NT8 as well I think, unfortunately. But, anything is possible in C# and that is the route I am exploring. Basically my idea is to use my own SQL database in my strategy to store all the trade performance metrics on my own, and then use Excel to import the SQL data and create my analysis.

Basic info here on that kind of relationship:
https://futures.io/elite-circle/21733-using-excel-query-mysql-database.html

Mike

Curious, after running a backtest, would selecting either the Trades or Executions tab and exporting that data from the grid not work for getting it to Excel?

Reply With Quote
 
  #7 (permalink)
Elite Member
Siveria
 
Futures Experience: Intermediate
Platform: Ninja Trader
Broker/Data: Mirus
Favorite Futures: FUTURES
 
Posts: 23 since Dec 2011
Thanks: 2 given, 2 received

No sir, I mean the conbined excell dump in full, with all trades of all instruments included in the Combined.


Mr. NinjaTrader can help?, Connecting to dump ninja + excell combined data, please.

Thank you very much.


Greetings.

Reply With Quote
 
  #8 (permalink)
 Vendor: www.probabletrades.com 
OC, California, USA
 
Futures Experience: Advanced
Platform: IB/TWS, NinjaTrader, thinkorswim
Favorite Futures: stocks, options, futures, VIX
 
shodson's Avatar
 
Posts: 1,859 since Jun 2009
Thanks: 480 given, 3,254 received


OPTIMUSS View Post
No sir, I mean the conbined excell dump in full, with all trades of all instruments included in the Combined.


Mr. NinjaTrader can help?, Connecting to dump ninja + excell combined data, please.

Thank you very much.


Greetings.

Amigo, no hay manera de hacer esto. Tienes que exportar los datos del examen historico por cada instrumento seperadamente y, de alguna manera, unir los resultados de cada instrumento. Entiendo que es dificil y doloroso el necesitar hacerlo asi pero asi es Ninjatrader.

Reply With Quote
 
  #9 (permalink)
Elite Member
Siveria
 
Futures Experience: Intermediate
Platform: Ninja Trader
Broker/Data: Mirus
Favorite Futures: FUTURES
 
Posts: 23 since Dec 2011
Thanks: 2 given, 2 received

Shodson Hi, thanks for your answer,

Hopefully in Ninja 8 can do this.

If Ninja wants to be number 1, should introcudir this option in the platform,

A greeting.

Reply With Quote
 
  #10 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 46,240 since Jun 2009
Thanks: 29,352 given, 83,223 received


Ray had stated nt8 will not have portfolio trading at launch.

I hope it comes in 8.1.

Sent from my Nexus 4

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote

Reply



futures io > > > > > Download series to Excell regrouped by dates

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Jigsaw Trading: TBA

Elite only

FuturesTrader71: TBA

Elite only

NinjaTrader: TBA

Jan 18

RandBots: TBA

Jan 23

GFF Brokers & CME Group: Futures & Bitcoin

Elite only

Adam Grimes: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing rollover dates for CL DarrenH Reviews of Brokers and Data Feeds 57 February 4th, 2015 01:30 PM
CTA - Series 3, Series 7, Series 9, Series 10, Series 56 NASD exams certifications Big Mike Traders Hideout 41 January 15th, 2015 10:27 AM
Strategy trade certain dates r3algood TradeStation 3 January 16th, 2013 05:14 AM
MATLAB Dates on the x - axis jakfourie Matlab, R project and Python 11 June 27th, 2011 03:55 AM
Web Tool for Bulk Price Series Download strimp099 Matlab, R project and Python 1 July 16th, 2010 05:40 PM


All times are GMT -4. The time now is 07:02 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts
Page generated 2017-12-13 in 0.13 seconds with 19 queries on phoenix via your IP 54.90.92.204