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