logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Creating a Chartbook: OLE & XL - not responding.... - Creating a Chartbook: OLE & XL - not responding....
Options
Go to last post Go to first unread
Previous Topic Next Topic
Taylor  
#1 Posted : Thursday, June 28, 2007 4:19:32 AM(UTC)
Taylor

Rank: Newbie

Groups: Registered, Registered Users
Joined: 6/28/2007(UTC)
Posts: 4
Dear Listmembers,
I am trying to create a "Chartbook" in XL.
I would like to have a few Metastock charts
dynamicaly linked into XL so when they are
updated, the spreadhsheet will be updated as well.
I have crated a few charts (not smartcharts)
and I do the following:
(i) right click on Metastock Chart > Copy
(ii) right click on XL > Past Special > Paste Link > MetaStock Chart Object
However the chart does not get copied.
How can I fix this ?
Thanks in advance for your help.
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
wabbit  
#2 Posted : Thursday, June 28, 2007 5:58:13 AM(UTC)
wabbit

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)
Taylor,

I guess the real question to answer your problem would be, "Why would you want to copy the information from one charting package (MetaStock) into another charting package (Excel)?"

Might I recommend that you investigate creating a custom list of the stocks that you want to include in the ChartBook, or a layout in MetaStock. Either of these solution could replace the Excel function.

If you absolutely require to use Excel, then refer to the MS Users Manual for the procedures to establish and maintain OLE connectivity between MetaStock and Excel.


Hope this helps.

wabbit [:D]
Back to top
Taylor  
#3 Posted : Thursday, June 28, 2007 6:23:30 AM(UTC)
Taylor

Rank: Newbie

Groups: Registered, Registered Users
Joined: 6/28/2007(UTC)
Posts: 4
Hi Wabbit,

and thanks for the reply.

The reason I want to copy the charts in XL is because I want to create a Chartbook.
In this case "size does matter" and copying these in XL can be at a larger scale
(when printed). Unfortunately I cannot attach a jpeg in order to provide an example.

I used MS Users Manual and did the following:
(i) right click on Metastock Chart > Copy
(ii) right click on XL > Past Special > Paste Link > MetaStock Chart Object
However the chart does not get copied.

Any idea ?
This is VERY important to me, so any kind of help would be highly appreciated
Back to top
wabbit  
#4 Posted : Thursday, June 28, 2007 7:27:38 AM(UTC)
wabbit

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)
Taylor,

Although I don't understand the importance of this, it is obviously important to you. (Perhaps later we can discuss the printing of charts...)

For the meantime let's see if we can sort out why the OLE between MS and Excel is not working!?

The first thing to check is that the OLE registration process has been achieved when you installed MS.

Start > Programs > Accessories > System Tools > System Information
Select Software Environment > Software Registration from the left hand menu tree
Check to see that MetaStock Chart and the correct path are listed in the right hand pane.

If all is good here then we need to check elsewhere... if the correct settings are not here then you can either manually register the OLE (which I have forgotten how to achieve for MS, but could find again should I REALLY need to) or simpler, reinstall MS to ensure the proper OLE service is registered with the Operating System.

--

In Excel, after you have selected Paste Special etc, what code appears in the formula window for the destination cell? It should say something along the lines of

=MetaStock.Chart|'C:\etc\MSSmart\C1.MWS'!\EntireChart

Do you get this far?

If so the problem appears to lie with Excel and its instantiation of a linked object. This might require a bit more research to figure out how to fix? In the mean time, more for my amusement than anything else, in Excel, Tools > Options > General and uncheck Ignore Other Applications. It shouldn't make any difference to OLE, but then again it might??

Hope this helps for the mean time. Keep us informed of your progress and maybe someone else might have had similar problems and fixed them somehow?


wabbit [:D]

P.S. I have tried the process described in the MS Users Manual on three different computers with 4 different versions of MS and two different versions of Excel and have no troubles???
Back to top
wabbit  
#5 Posted : Thursday, June 28, 2007 7:49:36 AM(UTC)
wabbit

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)
... just had another idea....

Can you create an OLE link with any other application?

Start simply, try creating an OLE link with WordPad, then try other MS Office Apps like MS Word or PowerPoint?

Is the problem with the Operating System, MetaStock or somewhere else?


wabbit [:D]
Back to top
Taylor  
#6 Posted : Thursday, June 28, 2007 9:51:40 AM(UTC)
Taylor

Rank: Newbie

Groups: Registered, Registered Users
Joined: 6/28/2007(UTC)
Posts: 4
Wabbit,

I am just posting to say that I have re-installed MS and the OLE function
is working fine now.

A very big THANK YOU is in order.
You have been very helpful.

Take care
Jim Taylor
Back to top
wabbit  
#7 Posted : Thursday, June 28, 2007 8:35:24 PM(UTC)
wabbit

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)
Jim,

Was the problem with the OLE registration?
wabbit wrote:
The first thing to check is that the OLE registration process has been achieved when you installed MS.

Start > Programs > Accessories > System Tools > System Information
Select Software Environment > Software Registration from the left hand menu tree
Check to see that MetaStock Chart and the correct path are listed in the right hand pane.


I am curious to discover the cause so that if it happens again in the future we can have a better idea of what to recommend as corrective action.



wabbit [:D]
Back to top
Taylor  
#8 Posted : Friday, June 29, 2007 1:06:32 AM(UTC)
Taylor

Rank: Newbie

Groups: Registered, Registered Users
Joined: 6/28/2007(UTC)
Posts: 4
Wabbit,

I checked the OLE registration before re-installing Metastock.
I appeared to be fine.
However I could still not make a connection of Metastock & XL.

So I decided to re-installed MS (like you suggested) and it was OK.

I hope this helps
Again, thanks for your suggestions
Back to top
T712  
#9 Posted : Saturday, May 1, 2010 11:47:19 PM(UTC)
T712

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 5/2/2010(UTC)
Posts: 2
Dear Sir,

By the way, when I copy the chart data onto Excel, using paste link, the excel cells appears to have a link, however, the result is showing #NAME?, or #N/A.

I use metastock 9.1 and excel 2000 and excel 2010 also showed the same result.

So just wonder if there is anything missing?

Thank you.,

TL712
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET