1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Get daily historic data from a web source's csv archives to mysql

Discussion in 'MySQL' started by ProjectA, Sep 16, 2018 at 10:39 AM.

  1. #1
    I need to get historic daily data from nseindia.com since 1994. I need this data to be pulled from nseindia website to my mysql online database for research purpose.

    The download link is https://nseindia.com/products/content/equities/equities/archieve_eq.htm
    I have to select Bhavcopy (csv) from dropdown and select dates manually to download csv file.

    I've created a table in my db with same columns of csv file. Using PhpMyadmin & Adminer.
    SEMrush
    What i wanted now is, to automate the process of importing historic day by day data to my mysql database online server. Is it possible? If yes, how simple or hard is the process.

    I am novice left with no capital.
     
    Last edited: Sep 16, 2018 at 10:54 AM
    ProjectA, Sep 16, 2018 at 10:39 AM IP
    SEMrush