|
PureBytes Links
Trading Reference Links
|
On Thu, 25 Sep 1997, Alain Jossart wrote:
> If this is the case, how would you integrate the Access and Metastock
> databases (splits, delisting, symbol modification, etc) ?
Let's look at your 3 example problems:
Splits
Find a web site where split info is published. Use a Perl script to
retrieve the info and parse to an input file for Access. In Access create
a table with fields Ticker, SplitDate, Ratio. Create a macro which imports
the split data file into the Splits table and runs an update query which
applies the split ratio to the data prior to the split date for each
ticker having a split.
Delisting
You might want to keep a table of delisted stocks and the date they were
delisted. Use referential integrity rules to tie your related tables
together, then delete the records for the delisted stocks from the master
table, taking related records with them.
Ticker and exchange changes
A good Master table is one containing the Ticker, CompanyName, Exchange.
If you have your referential integrity established as above (cascade
update, cascade delete) then making a change to this table will change
the entries in the related tables.
Add any other data maintenance items you need (how about volume
adjustment after changing data sources?) and use a query to create
the table with the same fields as your input file for MS, then export to
a text file in the appropriate format. Import the data via the Downloader.
Hope this helps.
Cheers,
Jim
|