|
PureBytes Links
Trading Reference Links
|
I know of no way to get Excel to "grow" as the chart grows. The
limitation is there and unless it is overcome you will have the first
day dropped off to get the last day added.
Equis Support
> -----Original Message-----
> From: Ian Mitchell [SMTP:ianm@xxxxxxxxxxxxx]
> Sent: Friday, June 13, 1997 9:27 AM
> To: metastock-list@xxxxxxxxxxxxx
> Subject: Fw: Excel links to Metastock6
>
>
> How then do I link from "price bars or indicators in Metastock Chart".
> I
> have tried copy from Metastock, and Paste Link special csv into Excel.
> This
> copies all the data across including todays prices. After the next
> days
> data is added, it is not added to the Excel spreadsheet even if I
> update
> the link manually or automatically. The reason as spelt out in the
> Equis
> FAQ is that Excel can't create another row simply because of the link.
> Hence one has to load one less period in the chart. This means the
> first
> date drops off, and the Excel link gives me the closing data.
> Now I am forced to view a fixed number of periods in my chart, when
> they
> are in fact growing each day. I want to be able to look back over all
> the
> data I have collected not just the periods locked in by this
> procedure.
>
> >Any help is appreciated
> >Regards
> >Ian
> >(ianm@xxxxxxxxxxxxx)
> > ----
> >From: Metastock List <MetastockList@xxxxxxxxx>
> >To: 'metastock-list' <metastock-list@xxxxxxxxxxxxx>
> >Date: Thursday, 12 June 1997 12:15 am
> >Subject: RE: Excel links to Metastock6
> >
> >>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
> >>
> >>
> >
|