Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/21/2011(UTC)
Posts: 4
|
is it possible conectong trading signals from expert advisor in MS pro with excell ? I mean for example if formula in expert advisor give us signal for long position, in excell we have in box world "buy"?
BRGS
Stive
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
The simplest way is to use the MDK to open a pipe between applications, but another way is to create an indicator for the trading signal and then use DDE to read this value in Excel.
wabbit [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
If you plot the code from the Expert as an Indicator on a chart, you can
then right-click it, click COPY and then PASTE it into Excel. You will
get the dates and signal.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Yup jj,
My post should have read OLE, not DDE.
wabbit [:D]
[It must be Guinness time by now?]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Wabbit -- Good point. I forgot to mention that the data can be Static or Live... Stive -- If you just want "raw" data, use Paste. It won't change, and you can modify it in Excel. If you want a "live" link (known as OLE -- Object Linking and Embedding), which updates from Metastock the next time you open the worksheet, it's a little different. 1. Select the COLUMNS (not the cells) for the link 2. Use Paste Special 3. Select "Paste link:" 4. Click on "Csv". 5. Click the OK button. If you don't select the columns first, the data will update, but will not "advance" over time. You can also go from Excel and/or CSV back to Metastock, at least two ways: 1. See this. 2. There is an addon from MasterData, here.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
