After I download data from Yahoo and Google finance, how I do use a Perl script to send these to MySQL database automatically?
A:
You may find beancounter useful -- it already does this (and also supports PostgreSQL and SQLite). It is both a Perl module (Finance::BeanCounter) and an example / reference frontend (beancounter) Perl program.
You then just need to set up a scheduled (ie cron) job to run your task. This has worked for me for over a decade...
Dirk Eddelbuettel
2010-10-19 18:09:50
A:
How are you downloading the data? Can you modify that program to also insert the quotes into the database at that same time?
To handle databases in Perl, use the DBI interface. Connect to the database, insert the values, and there you are.
Which parts of that are giving you problems? What have you tried so far?
brian d foy
2010-10-19 19:32:54