Suoritettu

Build excel sheet extracting stock/financial data from website

I need data [login to view URL] extracted from cashflow/income statements on www.marketwatch.com. I have provided an excel sheet with a list of stocks (stock ticker and name) and filled out the first row as an example . I require the following data entered.

Cashflow for 5 previous years

Cashflow for previous 5 quarters

revenue for previous 5 years

revenue for previous 5 quarters

step 1. go to [login to view URL] and search stock ticker (verify company name)

step 2. Scroll down and select financials tab

step 3. Select cashflow statement on lefthand side

step 4. scroll to the bottom and extract the data from the free cashflow row for past 5 years (as a number, without 'M' or 'B')

step 5. scroll up and select quarterly financials from right hand side

step 6. ensure cashflow statement is selected on the left

step 7. scroll to the bottom and extract the data from the free cashflow row for past 5 quarters (as a number, without 'M' or 'B')

step 8. Select income statement on the left

step 9. Select annual financials

step 10. Extract data from sales/revenue row for past 5 years (as a number without 'm' or 'b')

step 11. Select quarterly financials

step 12. Extract data from sales/revenue row for past 5 quarters (as a number without 'm' or 'b')

step 13. Repeat process for rest of stocks

Taidot: Excel, tiedonsyöttö, tietojenkäsittely, Visual Basic

Näytä lisää: excel sheet marketing research survey data entry, getafreelancercom extract data website excel sheet, extracting data website excel sheet, excel stock quotes 2018, download historical stock data into excel, get stock quotes in excel from google finance, how to import stock prices into excel from google finance, real time stock quotes excel, excel stock data type, how to get stock quotes in excel 2016, real time stock quotes excel 2016, can copy website data excel sheet, extracting data website excel, extract data website excel sheet, excel vba download yahoo financial data, excel macros download yahoo financial data, can stock market data website, put stock market data website, import real time stock exchange data website, excel sheet reorder stock

Tietoa työnantajasta:
( 0 arvostelua ) Dubai, United Arab Emirates

Projektin tunnus: #20302393

Myönnetty käyttäjälle:

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$50 USD 1 päivässä
(338 Arvostelua)
8.0

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

sparkingboy2010

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many Lisää

$20 USD 1 päivässä
(234 arvostelua)
6.9
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can move forward with your pr Lisää

$20 USD 7 päivässä
(55 arvostelua)
5.6
sergeyprince

Hello. I can do your project perfectly. I have got 8 years of rich experience in VBA. I can do VBA programming as fast as you want. I am Data Processing, Excel VBA Expert who knows the value of time, very hard workin Lisää

$30 USD 7 päivässä
(10 arvostelua)
2.7
kreativeapostle

Kindly let me handle the task for you. I am very proficient in financial matters and analysis. I am also very good at research.

$15 USD 1 päivässä
(2 arvostelua)
1.4
electronblood

Thanks step by step explanation and excel file, Total no of companies: 2100 companies For all these companies,i have to find below mentioned data: Cashflow for 5 previous years Cashflow for previous 5 quarters revenue Lisää

$210 USD 5 päivässä
(1 arvostelu)
0.7
michaelpackers

Will get this done ASAP and make changes if you are unsatisfied with results. Dedicated and diligent.

$10 USD 2 päivässä
(0 arvostelua)
0.0
eng3melbadry

Dear, I'm a Planning and Cost Engineer, bilingual (Arabic: Native, English: fluent), also I'm a freelancer planner, scheduler, Tekla Detailing, Auto-Cad Drawing, translator, data entry, admin assistant, Web search, web Lisää

$20 USD 2 päivässä
(0 arvostelua)
0.0
CAGOKULRANGAN

Hi, I am excited to help you to complete this project. Having 5 years of experience in accounting & tax field, 1-year experience in teaching field (Tally ERP 9, Microsoft office) I am educated as CA IPCC & Bachelor of Lisää

$15 USD 7 päivässä
(0 arvostelua)
0.0
kalinzahariev

I will develop a script that wll automate the process. In addition of the excel file containin all of the data you requested, I will also provide you with the script and instructions how to run it so you can use it aga Lisää

$60 USD 7 päivässä
(0 arvostelua)
0.0
sameera21

I'm a BSc degree holder and during my research period I did lots of things using Microsoft Office package so I can do it correctly

$40 USD 4 päivässä
(0 arvostelua)
0.0