NexusFi: Find Your Edge


Home Menu

 





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 2,405 views
    2. thumb_up 1 thanks given
    3. group 5 followers
    1. forum 9 posts
    2. attach_file 1 attachments




 
Search this Thread

export to excel help

  #1 (permalink)
kidvic
Los Angeles, CA
 
Posts: 92 since Mar 2015
Thanks Given: 13
Thanks Received: 3

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 NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
REcommedations for programming help
Sierra Chart
What broker to use for trading palladium futures
Commodities
How to apply profiles
Traders Hideout
 
  #3 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
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
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863


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 NexusFi Trade Journal Reply With Quote
  #4 (permalink)
kidvic
Los Angeles, CA
 
Posts: 92 since Mar 2015
Thanks Given: 13
Thanks Received: 3


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
  #5 (permalink)
 
Silent warrior's Avatar
 Silent warrior 
Boston, MA
 
Experience: Advanced
Platform: NinjaTrader
Broker: Rithmic/IQFeed
Trading: ES, ZB, GC, 6E, CL
Posts: 69 since Feb 2015
Thanks Given: 133
Thanks Received: 13

were you able to source a solution for the task?

Reply With Quote
  #6 (permalink)
 
Silent warrior's Avatar
 Silent warrior 
Boston, MA
 
Experience: Advanced
Platform: NinjaTrader
Broker: Rithmic/IQFeed
Trading: ES, ZB, GC, 6E, CL
Posts: 69 since Feb 2015
Thanks Given: 133
Thanks Received: 13

were you able to source a solution for this?

Reply With Quote
  #7 (permalink)
kidvic
Los Angeles, CA
 
Posts: 92 since Mar 2015
Thanks Given: 13
Thanks Received: 3


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

unfortunately Not.

Reply With Quote
  #8 (permalink)
 
shuglu's Avatar
 shuglu 
Melbourne
 
Experience: None
Platform: NinjaTrader
Broker: Amp/CQG
Trading: NQ
Posts: 71 since Jul 2012
Thanks Given: 312
Thanks Received: 94

Dionysus New Year Present – Ninja & Excel - [AUTOLINK]NinjaTrader[/AUTOLINK] Support Forum Dionysus New Year Present – Ninja & Excel - [AUTOLINK]NinjaTrader[/AUTOLINK] Support Forum

Reply With Quote
Thanked by:
  #9 (permalink)
 
Silent warrior's Avatar
 Silent warrior 
Boston, MA
 
Experience: Advanced
Platform: NinjaTrader
Broker: Rithmic/IQFeed
Trading: ES, ZB, GC, 6E, CL
Posts: 69 since Feb 2015
Thanks Given: 133
Thanks Received: 13

Indicator Mall

Reply With Quote
  #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 Given: 43
Thanks Received: 133


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




Last Updated on December 6, 2017


© 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