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