Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/22/2005(UTC)
Posts: 7
Location: NO
|
I am using MetaStock 9 Pro - I have problem to create OLE links from my custom indicators.
When I paste Special into excel I receive a message: havent link to paste.
Someone can help me?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
So you select PASTE SPECIAL, PASTE LINK, CSV and you get this error?
That's kinda weird, do you more info that could help?
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/22/2005(UTC)
Posts: 7
Location: NO
|
Exactly. When I do these steps I received error messages.
I am curious about syntax of cell.
May you copy and paste an example to me from excel?
Maybe this syntax could be useful.
Best Regards
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Are we talking about an OLE or a DDE link?
There are no syntax / code involved with ole links ...
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Hey just a though before I got to sleep ... Make sure you right click on only one cell and then select paste special ...
...
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/22/2005(UTC)
Posts: 7
Location: NO
|
Dont work. definitely dont work!!
I tried everything. (When I go in Excel/Insert/Object I cant see Metastock icon, probably isnt install)
I am in Brazil and my MsOffice 2000 and XP are in portuguese both with last windowsupdate.
I want create in excel a real-time calculate custom indicator from 100 securities.
I dont know which diference between OLE and DDE link. Now I am researching about this feature (DDE Link)
Is it possible? Because now I need run exploration to see result, but I would like to see in real time.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Quote: (When I go in Excel/Insert/Object I cant see Metastock icon, probably isnt install)
Well Metastock does not install anything in excel ...
Quote:I want create in excel a real-time calculate custom indicator from 100 securities.
That does not sound like a very good idea. I don't think your computer will handle 100 securities updating real time through excel ... Also most real time data providers will limit the amount of securities you can have open at the same time ...
Quote:Is it possible? Because now I need run exploration to see result, but I would like to see in real time.
I usually would answer that this is the job of the expert advisor, but for a 100 securities ........
Now to create an OLE link here are the steps again:
open a chart in Metastock
Right click on the price bars and select copy
Open excel, right click on the first cell ( and only one cell )
Select past special, select paste link, select csv and click on ok.
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Are you using QuoteCenter data?
|
|
|
|
|
|
| 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.
