Hi Shengui,
This new project leverages the work you completed in the last project where you scraped a web page using simple_html_dom, cURL and created an array of values and saved as a file. If you recall, your previous work scraped a single table of financial metrics across five columns from this web site:
[login to view URL]
This new project will use the same approach, but will need to collect the financial data from two sets of three different pages/tables:
Annual Data
[login to view URL]
[login to view URL]
[login to view URL]
Quarterly Data
[login to view URL]
[login to view URL]
[login to view URL]
Given your current code, it's easy enough to pass these different URLs and save the values of the annual reports as individual arrays or to individual files.
You will find that these six pages/tables consist of three unique financial reports -- income statement, balance sheet and cash flow. Each of the three different types of financial reports might have 50 different metrics so after analyzing the three reports, the array for a single period might have 150 elements. Each report has annual and quarterly values.
In short, I want to populate a mySQL database table that contains a record for each financial period -- both annual and quarterly. The table (schema attached) has many columns to store most of the attributes in the array for each period.
So after scraping the MSFT pages and inserting into the mySQL database table, the table might look something like this...
ID ID_company Fiscal Type Fiscal Period Ending Sales COGS RD etc
1 MSFT Annual 2015-12-31 41B 15B 4.5B etc
2 MSFT Annual 2014-12-31 33B 11B 3.9B etc
3 MSFT Annual 2013-12-31 25B 10B 3.5B etc
4 MSFT Annual 2012-12-31 22B 10B 2.9B etc
5 MSFT Annual 2011-12-31 18B 11B 2.3B etc
6 MSFT Quarterly 2014-09-30 2.1B 1.2B 1.4B etc
7 MSFT Quarterly 2014-12-31 1.9B 1.2B 1.4B etc
8 MSFT Quarterly 2015-03-31 1.3B 1.2B 1.4B etc
9 MSFT Quarterly 2015-06-30 2.0B 1.2B 1.4B etc
10 MSFT Quarterly 2015-09-30 1.1B 1.2B 1.4B etc
Since I do not need to store every financial metric that will be in your large array, I will most likely need to populate the SQL statement to insert the records as follows:
$sales_revenue = $this->result[$i]['Sales / Revenue'];
$sales_growth = $this->result[$i]['Sales Growth'];
$cost_of_goods_sold = $this->result[$i]['Cost of Goods Sold (COGS) incl. D&A'];
INSERT INTO financials (id_company, sales_revenue, sales_growth, cost_of_goods_sold, etc...)
VALUES ('MSFT', $sales_revenue, $sales_growth, $cost_of_goods_sold,...);
Hi..
I am very interested in your project, because I have ever worked on your project,
Please award the project, then I will finish it in a short time.
Thanks.
$170 USD 3 päivässä
4,9 (37 arvostelua)
5,2
5,2
4 freelancerit tarjoavat keskimäärin $188 USD tätä projektia
Hello,
I am Sanjay Bodhale. Over the last 6 years, I have enjoyed quite wide range of experience in developing web sites using PHP/MySQL including web sites for small companies.
I am expertise in WordPress,Yii,CakePHP, PHP 4/5, CSS 3, HTML 5, JavaScript and jQuery.
Looking forward to hear you soon.
Thanks,
sanjay
Having 8 years of extensive work experience in Wordpress,PHP5 , HTML5,MYSQL, CSS, JS. Successfully completed many complex project in the career path.
The approach to the job is very professional. Main aim is client satisfaction.
I am looking to here from you very soon.