|
PureBytes Links
Trading Reference Links
|
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
|