export to excel help - futures io
futures io



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,488 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)
kidvic
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?
Need help with strategy PriceActionSwingPro
NinjaTrader
options data for chart
NinjaTrader
Multichart NET: where can i find esplanation on CustomIn …
MultiCharts
need help writing easylanguage radarscreen weekly perfor …
EasyLanguage Programming
Is there a way to rename an existing trade?
MultiCharts
 
Best Threads (Most Thanked)
in the last 7 days on futures io
The Crude Dude Oil Trading System
89 thanks
Spoo-nalysis ES e-mini futures S&P 500
67 thanks
I finally blew up an account
63 thanks
The tiyfTradePlanFactory indicator
33 thanks
FIO Journal Challenge - April 2021 w/Jigsaw Trading
17 thanks
 
(login for full post details)
  #3 (permalink)
 rleplae 
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,802 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)
kidvic
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)
 Silent warrior 
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)
 Silent warrior 
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)
kidvic
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)
 shuglu 
Melbourne
 
Experience: None
Platform: NinjaTrader
Broker: Amp/CQG
Trading: NQ
 
shuglu's Avatar
 
Posts: 71 since Jul 2012
Thanks: 312 given, 94 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)
 Silent warrior 
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)
 Cheech 
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

The Cold Hard Truth: Maybe I Am Not Good Enough w/Chris Gray @ Earn2Trade

Elite only
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), 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