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,257 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

(login for full post details)
  #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?
TPO letter distribution for E-mini?
Emini and Emicro Index
convert tradingview pinescript to ninjascript indicator …
The Elite Circle
Any experience with Affordable Indicators - Duplicate Ac …
Trading Reviews and Vendors
PowerLanguage/EasyLanguage Trying to use a Function as a …
EasyLanguage Programming
Optimal Futures Trading Workflow
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
GFIs1 1 DAX trade per day journal
26 thanks
Big Mike in Ecuador
18 thanks
Vinny E-Mini & Algobox Review TRADE ROOM
11 thanks
King Of The Nasdaq
10 thanks
Sam fired from OpenAI!
9 thanks

(login for full post details)
  #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,860


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
(login for full post details)
  #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
(login for full post details)
  #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
(login for full post details)
  #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
(login for full post details)
  #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
(login for full post details)
  #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
The following user says Thank You to shuglu for this post:
(login for full post details)
  #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
(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 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


© 2023 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