|
PureBytes Links
Trading Reference Links
|
I have a post of what to do on my other computer that is in the shop.
But in a nutshell. Place the securities that you are interested in into
a separate folder. Then create a custom formula for the close and put
this in the chart. Save as a smart chart and close it. Next in the
options for number of days select one day and then open your security
back up. You'll need to select an object then cursor around to get to
the close then go to the menu and copy then OLE past to EXCEL.
Each time you update your data and update the OLE link you will end up
getting the last days price. There will be more than just the close
OLEed to Excel, so you may want to have a sheet with your OLE and then
linked to the other worksheets the info you specifically need. This will
get you started.
Harley
Guy R. Tann wrote:
> Paula
>
> I've linked my MS commodities with my Excel spreadsheets.
> Haven't been able to spend too much time on just returning
> the last days activities as I've been spending too much
> time programming VBA. Got my stuff all coded into the
> spreadsheet. Now, I will be coding the actual decision
> tables. Ideally, being able to just pick up the current
> activity would be great, as then I wouldn't have to
> reconstruct everything from scratch daily.
>
> If you discover anyway to do this, please drop me a line.
>
> Thanks
>
> Guy
>
> -----Original Message-----
> From: Paula & John [SMTP:jhl3@xxxxxxxxx]
> Sent: Monday, February 23, 1998 9:27 PM
> To: metastock-list@xxxxxxxxx
> Subject: Excel 97 Question
>
> I'm trying to link some data in Metastock (6.0) to Excel
> spreadsheets, so
> that I can combine technical analysis number crunching with
> fundamental
> data number-crunching (which data I get from my Zacks
> database). I'm able
> to update stock prices en masse--i.e. one complete set of
> data from
> Metastock to Excel, adding the current day's data to the
> previous data--but
> all I want to do, for now, is replace yesterday's price of
> a given stock
> with today's price: change the data in a single cell, in
> other words.
>
> I'm sure there is a simple way to do this, but my knowledge
> of Excel is
> limited to pretty simple functions.
>
> Thanks for any help you can give.
>
> Paula
|