Download to excel file in PC?

Discussion in 'Stocks' started by jk90029, Mar 19, 2011.

  1. jk90029

    jk90029

    Dear-

    It is well known and quite open to public that we can use yahoo.com finance site to download past 1000 daily to an excel data, ONE-BY-ONE.

    Now if I have interest in 200 stocks (like, MSFT, BAC, BRK, .................................................. ............... ), should I repeat download the same way as above 200 times?

    I believe there is some easy way to download with one click. For example my input file has 200 items of interest stock such as MSFT, BAC, .................................................. and hope output file has 1000 rows(last 1000 daily close) and 200 columns Excel format after downloading.

    Any link or trading tool info is(are) appreciated.

    Thanks in advance.

    -Jay

    PS) Hope, if download at noon, of course last daily close at firts row will be the present price at noon.