export to excel help - futures io
futures io futures trading



export to excel help


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one kidvic with 3 posts (0 thanks)
    2. looks_two Silent warrior with 3 posts (0 thanks)
    3. looks_3 Cheech with 1 posts (0 thanks)
    4. looks_4 rleplae with 1 posts (0 thanks)
    1. trending_up 1,445 views
    2. thumb_up 1 thanks given
    3. group 5 followers
    1. forum 9 posts
    2. attach_file 1 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • 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 and simple.

-- Big Mike, Site Administrator

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

 
Search this Thread
 

export to excel help

(login for full post details)
  #1 (permalink)
Los Angeles, CA
 
 
Posts: 92 since Mar 2015
Thanks: 13 given, 3 received

I am trying to get my print values on output to export to excel. I tried using exportdata strategy, but im getting a file path / variable error.
is there an easier way to do it? I would like to overwrite each new time the bar calculates, i dont need to keep the old values when the new one overwrites.
Im looking for something that is realtime in excel. thanks.

Reply With Quote

Can you help answer these questions
from other members on futures io?
Neurological explanations for trading Success
Psychology and Money Management
NT8 indicator to simulate a Funding Evaluation where to …
NinjaTrader
Indicators for pair trading MES and M2K
Platforms and Indicators
Automatic pattern research with NT
Elite Algorithmic NinjaTrader Trading
Work with historical tcks data on MUltichart NET PowerLa …
MultiCharts
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Battlestations: Show us your trading desks!
111 thanks
Selling Options on Futures?
109 thanks
Rank your Futures vs Stocks trading priority
37 thanks
Want your NinjaTrader indicator created, free?
26 thanks
Bitcoin storage wallet recommendations
18 thanks
 
(login for full post details)
  #3 (permalink)
Gits (Hooglede) Belgium
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 2,991 since Sep 2013
Thanks: 2,437 given, 5,801 received


If you want it to update, then import is not a good option.

Excel RTD (Real Time Data) is the replacement for DDE. It allows you to push values to a cell whenever updates are available. If the process providing the updates is an external application, setting up a WCF channel between the RTD server and the external app should allow you to feed real-time updates into Excel.

Here are some links:

https://support.microsoft.com/en-us/kb/285339
Kenny Kerr - Excel RTD Servers: Minimal C# Implementation
Kenny Kerr - Excel RTD Servers: A Topic?s Initial Value
Kenny Kerr - Excel RTD Servers: How to use UpdateNotify Properly

Follow me on Twitter Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #4 (permalink)
Los Angeles, CA
 
 
Posts: 92 since Mar 2015
Thanks: 13 given, 3 received


rleplae View Post
If you want it to update, then import is not a good option.

Excel RTD (Real Time Data) is the replacement for DDE. It allows you to push values to a cell whenever updates are available. If the process providing the updates is an external application, setting up a WCF channel between the RTD server and the external app should allow you to feed real-time updates into Excel.

Here are some links:

https://support.microsoft.com/en-us/kb/285339
Kenny Kerr - Excel RTD Servers: Minimal C# Implementation
Kenny Kerr - Excel RTD Servers: A Topic?s Initial Value
Kenny Kerr - Excel RTD Servers: How to use UpdateNotify Properly

Thanks for that, this is beyond my scope of programming.
Does anyone have an indicator/strategy already working realtime with excel, would like a template.

Reply With Quote
 
(login for full post details)
  #5 (permalink)
Boston, MA
 
Experience: Advanced
Platform: NinjaTrader
Broker: Rithmic/IQFeed
Trading: ES, ZB, GC, 6E, CL
 
Silent warrior's Avatar
 
Posts: 57 since Feb 2015
Thanks: 127 given, 12 received

were you able to source a solution for the task?

Reply With Quote
 
(login for full post details)
  #6 (permalink)
Boston, MA
 
Experience: Advanced
Platform: NinjaTrader
Broker: Rithmic/IQFeed
Trading: ES, ZB, GC, 6E, CL
 
Silent warrior's Avatar
 
Posts: 57 since Feb 2015
Thanks: 127 given, 12 received

were you able to source a solution for this?

Reply With Quote
 
(login for full post details)
  #7 (permalink)
Los Angeles, CA
 
 
Posts: 92 since Mar 2015
Thanks: 13 given, 3 received


Silent warrior View Post
were you able to source a solution for this?

unfortunately Not.

Reply With Quote
 
(login for full post details)
  #8 (permalink)
Melbourne
 
Experience: None
Platform: NinjaTrader
Broker: Amp/CQG
Trading: NQ
 
shuglu's Avatar
 
Posts: 70 since Jul 2012
Thanks: 312 given, 93 received

Dionysus New Year Present Ninja & Excel - NinjaTrader Support Forum Dionysus New Year Present Ninja & Excel - NinjaTrader Support Forum

Reply With Quote
The following user says Thank You to shuglu for this post:
 
(login for full post details)
  #9 (permalink)
Boston, MA
 
Experience: Advanced
Platform: NinjaTrader
Broker: Rithmic/IQFeed
Trading: ES, ZB, GC, 6E, CL
 
Silent warrior's Avatar
 
Posts: 57 since Feb 2015
Thanks: 127 given, 12 received

Indicator Mall

Reply With Quote
 
(login for full post details)
  #10 (permalink)
Mesa, AZ/USA
 
Experience: Intermediate
Platform: NinjaTrader, ThinkorSwim
Broker: AMP Futures/CQG, TDA
Trading: Currency Futures, my Harley Davidson
 
Posts: 107 since Jun 2012
Thanks: 43 given, 132 received


I posted this file here because I really didn't know where else to post it.

The attached file is a Excel (2007) template for an export Indicator (NT7) I just posted. It's only use is to define the .csv headers more clearly as they are mostly non-descriptive in the file. There are two worksheets in the file, one id for the Detail file and the other is for the directory file.

This spreadsheet does not do any data analysis of the exported data.

ExportCsvSS.xlsx

Reply With Quote


futures io Trading Community Platforms and Indicators NinjaTrader > export to excel help


Last Updated on December 6, 2017


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Battlestations! Show us your trading desk - $1,500 in prizes!

March
 

Importance of Finding Your Own Way w/Adam Grimes

Elite only
 

Journal Challenge w/Jigsaw

April
     



Copyright © 2021 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