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