|
PureBytes Links
Trading Reference Links
|
Hi megabanca12,
Take a note of the date(s) with the zeros, go to the Downloader, open
that stock, scroll to the noted date(s), and change the zeros to the
last not zero closing price. Then save the security, return to MS and
refresh.
If there are lots of such dates you may want to have an Excel routine do
the job for you, but it takes exporting - importing or at least
copy-pasting and a little VBA.
Good luck
Spyros from Athens.
Message: 2
Date: Tue, 30 Sep 2003 20:27:52 -0000
From: megabanca12
Subject: Simple question about data containing zero
Hi guys, i ve been downloading the daily data of Athens Stock
Exchange and i think there is a problem now. One security has no data
for a day. There are only 0 s. When trying using a tester, it gives
me the error message 'Unable to test because the price data contains
zero or negative values'.
So what should i do, in order to get the tester working?
By the way, when a security changes its nominal(? ) value, lets say
the company gives 3 new securities for one old, is there something i
must change through downloader?
Excuse me for the possibility in being wrong with the terminology, i
am little new in that kind of stuff:))
________________________________________________________________________
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|