I need an automatic gathering machine, the project is about getting stock data from Yahoo, the machine should be in python language and work with AWS (Amazon web server) as the process should be automatic.
the process is easy I should give the program a CSV file with the columns date, symbol, Open, High, Low, Close, Adjsuted close, Volume, amc/bmc (which I will refer later).
1. the program will access the CSV file and pull the stock symbol and enter it in this URL: https://finance.yahoo.com/quote/"Stock
name goes here!!"/history?period1=1178139600&period2=1555102800&interval=1d&filter=history&frequency=1d
(inside the page where it says "Time Period:" should be on MAX.)
2.then go back to the CSV pull the date and search for it on the web page. then when found scrape the "open, high, low, close, adj close, Volume" and implement it back on to the CSV. (if needed create a new CSV file with the same columns).
3. if the stock got amc at the "amc"/"bmo" column then search for the day after the date that was given and repeat step 2. if the stock got bmo then search for the day before the date that was given and repeat step 2.
**possible errors on the Yahoo page there sometimes a duplicate of the date anted as one date have no info for it only says "Dividend". in that case search for the correct date/