Ive been trying to write DDE formulas in excel that contain references to the symbol and the field being requested. Was hoping i could have a list of my variables in one column to use in all the formulas that way i wouldnt have to manually write every single formula. Can this be done or not?
Thanks,
Dean
Hi Dean,
I had the same concern. I wasn't able to find a solution at that time (I remember I read this might be feasible using VBA scripts, but I didn t want to go that way)
So I just created a global table with all the DDE values I needed so that I would just use a regular lookup/match Excel formula to recover the right data (aka a given V# or T# for a given instrument..) I wanted to display on my summary pages...
Cheers
Eddy
Note : For the record, all calculations were done on the IRT side, i was just exporting the relevant V# outputs through the DDE
Eddy,
Thanks for the response. I was thinking about lookup/match solution last night but it was late and i couldnt wrap my head around the proper way to do it. Im going to work on making a separate table and implement your solution now. Question for you, assuming you are using DDE regularly... How many variables are you pumping out to excel and for how many symbols? Just curious because at the moment im exporting about 115 variables for ES alone using RTX ExportData on a layout with about 7 charts. My excel project runs calcs all day and even makes 2 of my Bookmap cloud note files automatically. Problem is i want to be able to look at CL and NQ also during day. Im just not sure if having 3 layouts running in the background while i do my regular charting is a good idea so i wanted to give DDE a try since i havent in the past, Im hoping ill be able to split all the variables across 4 or 5 quotepages on a new layout and have everything work without issues.
Thanks for the info and thanks for responding,
Dean
Hi Dean,
I must have at least a total of +/- 1000 V# and T# updated by a DDE (for ca 15 instruments), so you should be fine with DDE.
I don't have any experience with the RTX export data indicator (with this number of V#), so I don't know the typical CPU time for this indicator, but the DDE should work fine (at least, I haven't seen any impact of running the DDE on my IRT CPU usage).
What I don't know is whether the RTX export data indicator can provide a faster update frequency than the DDE method (which has a native limitation of updating data every second or two, but that's not a problem on my side...).
Of course, whenever possible (if you can split the tasks), it is always best to run several IRT instances on the same PC to minimize any risk of a slowdown, ie having one instance for screening purposes with all the heavy computations for a bunch of instruments, and another lighter version with all the live charts you need for trading specific instrument.
Eddy
Eddy,
Wow. Thats a lot of variables. I def should be fine then. I am running multiple programs on PC also during the day, but I seem to have everything set up pretty efficiently. I never see any lags and only have hiccups at the close sometimes. I just didnt realize what i was getting myself into. I was using SessionPrices and Profile indicators on my charts which allowed me to set multiple variable all at once in groups and now it looks like i have to make custom indicators for every single variable. I do have some of the indicators already but i have them set to calculate more then i need. For instance, i have some profile data that is setup already via chart profiles but some are set to calculate the last 50 profiles and others are set to calculate the last 1000 profiles. Do you know if its Ok to use those or am i better off creating duplicates for all of them and changing the number of profiles needed accordingly?
Also, do you know if its better to control session while setting up custom column via its setting or by using MPD in custom indicator?
Is one way more efficient then the other?
Thanks again,
Dean