scrape site and add data into mysql

Write script that will work in linux server that will scrape below sites.

1. It will retrieve calls and puts for the volume field over 10k and insert them into the mysql db.

This process of insert into db will be replicated for 20 indicators of my choosing.

Here is 3 indicators of 20

[login to view URL]

[login to view URL]

[login to view URL]

2. It will save all of these fields.

Contract Name Last Trade Date Strike

Last Price Bid Ask Change % Change Volume Open Interest Implied Volatility

3. So there should be a table for each indicator.

DB = FINANCE

TSLA - CALLS

- PUTS

SPY - CALLS

- PUTS

4. Every 15 minutes the script needs to run, and if the Contract changes.

i.e SPY201028C00210000

It will update the latest changes to the fields.

Then I want the results displayed via webpage.

There should be a drop down where I can select the indicator.

i.e TSLA, AMD, SPY and it should show the results related to that indicator.

5. When the day changes at UTC +0

It will use the next day's data

[login to view URL]

Uploaded is an example of CALLS over 10k in volume.

Bid Now, Accept Now, Start now.

Should be finished or 75% done by end of today.

Taidot: Tietojen kaavinta verkosta

Näytä lisää: script add data mysql, add rss data mysql, add data php mysql, web scraping python, best database for web scraping, web scraping api, web scraping into sql, web scraping using api, web scraping, extract data from website to sql server, web scraping using sql, php script scrape site data, add data php mysql enrollment system, mysql add data, php mysql list add data, add data mysql using ajax cakephp, add data mysql form, php add data mysql form, php scrape data site add mysql, flex add data mysql

Projektin tunnus: #27947436