English 中文(简体)
How do I get and compare stock quotes from Yahoo! and Google?
原标题:

How to get a history quote from Yahoo and Google Finance with Perl and save in DB to compare and validate. What´s the best/simple Perl/Windows DB to make this and the Perl/Algoritmo to compare this data?

问题回答
  • To get historical quotes (as opposed to current), you can either use existing CPAN modules (e.g. Finance::QuoteHist::Yahoo / Finance::QuoteHist::Google - which are top links if you bother Googling "cpan historical yahoo quotes" ) or roll your own as follows:

    • use LWP::Mechanize to retrieve Y! and G! historical data from relevant URLs as HTML (to the best of my knowledge, the official Yahoo CSV quote API doesn t do historical though I could be wrong).

    • use an HTML parser like HTML::TreeBuilder to parse that HTML and extract quote data.

  • To store the data, use pretty much any database - from a simple CSV file to SQLite database (or DBM file, or MySQL, but I m not sure the last 2 work on Windows). Which one to pick depends on how much data you want to store and what you want to do with it.

  • To compare, you can either run a database query/report, depending on what your comparison needs to compute; or retrieve data (in bulk or in a per-security loop) into your program and compare in Perl code. Can t provide any more specifics without a lot clearer explanation of WHAT you want to compare and how.

If you have more specific questions about each of these steps, please feel free to post what you ve done, what the problems are which arose and SO will be glad to help.





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签