|
PureBytes Links
Trading Reference Links
|
I noticed the link choice that showed up in metastock. So here is the question.
In excel if I have two spread sheets linked across a LAN I must go and up date
the link in one of the spreadsheets. For example, computer 1 has the
spreadsheet that has the original input. Computer two has open the other
spreadsheet that has a link from the first spreadsheet on computer 1. In this
case I must update the link in computer 2 to get the data from computer 1.
So this is what I was basing my knowledge from. If I am droping prices from
metastock to excel I was looking at metastock as if it were computer 1 and
excel computer two. But when I drag an indicator from excel to metastock it is
now circular. But it sounds like Metastock as the link update controls.
But does it work the same for a LAN?
On Wed, 11 Jun 1997 08:07:06 -0600,
Metastock List wrote...
>Basically, Harley is correct. However, the links must come from the
>price bars or indicators in a MetaStock Chart originally.
>
>Equis Support
>
>> -----Original Message-----
>> From: Harley Meyer [SMTP:Harley.D.Meyer-2@xxxxxxxxxx]
>> Sent: Wednesday, June 11, 1997 8:03 AM
>> To: ianm@xxxxxxxxxxxxx
>> Cc: metastock-list@xxxxxxxxxxxxx
>> Subject: Re: Excel links to Metastock6
>>
>> Since they are out of the office I think this will help. In excel
>> there is a
>> menu selection EDIT scroll down and select LINKS then click on update.
>> then it
>> updates it for you. You can have this done automatically with a macro
>> in excel.
>>
>> Harley
>>
>> On Tue, 10 Jun 1997 09:41:26 +1000,
>> ianm@xxxxxxxxxxxxx wrote...
>> >Thanks for your response.
>> >
>> >After the end of day download, I would like my share portfolio in
>> Excel to
>> >be automatically updated with the day's closing prices.
>> >I don't want to have to to do this manually. I thought OLE provided
>> such
>> >linkages?
>> >
>> >Also once I can do this I can modify my Excel program to calculate
>> Capital
>> >Gains on buy/sells.
>> >
>> >Any help is appreciated
>> >Regards
>> >Ian
>> >(ianm@xxxxxxxxxxxxx)
>> >
>> > ----
>> >>From: Metastock List <MetastockL@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>> >>To: 'Ian Mitchell' <ianm@xxxxxxxxxxxxx>;
>> metastock-list@xxxxxxxxxxxxx
>> >>Date: Tuesday, 10 June 1997 2:44 am
>> >>Subject: RE: Excel links to Metastock6
>> >>
>> >>>I am not certain I understand exactly what you are asking, but you
>> could
>> >>>simply copy and paste the current days prices from the data sheet
>> to the
>> >>>spreadsheet.
>> >>>
>> >>>Perhaps a better explanation of exactly why you want all the data
>> in the
>> >>>Excel spreadsheet will lead me to some other possible solutions.
>> >>>
>> >>>Equis Support
>> >>>
>> >>>> -----Original Message-----
>> >>>> From: Ian Mitchell [SMTP:ianm@xxxxxxxxxxxxx]
>> >>>> Sent: Monday, June 09, 1997 10:01 AM
>> >>>> To: metastock-list@xxxxxxxxxxxxx
>> >>>> Subject: Excel links to Metastock6
>> >>>>
>> >>>> I am trying to update my share portfolio in Excel 97 with the
>> current
>> >>>> share
>> >>>> prices taken from Metastock V6 data which is updated
>> automatically at
>> >>>> end
>> >>>> of day.
>> >>>>
>> >>>> I can use OLE to link all data for a stock , but because of the
>> >>>> limitation
>> >>>> of Excel mentioned in the Equis FAQ, I am forced to limit the
>> loaded
>> >>>> data
>> >>>> to a fixed number of periods. Over time this means I am not
>> displaying
>> >>>> all
>> >>>> the data I could. Is it possible to simply read the current
>> prices
>> >>>> directly into Excel?
>> >>>>
>> >>>> If this is not the right place to ask this, my apologies - please
>> >>>> advise
>> >>>> where I should ask this.
>> >>>>
>> >>>> Thanks and Regards
>> >>>> Ian
>> >>>> (ianm@xxxxxxxxxxxxx)
>> >>>
>> >>
>> >>
>> >
>> >
>>
>> Harley Meyer
>> meyer093@xxxxxxxxxx
>
>
Harley Meyer
meyer093@xxxxxxxxxx
|