Closed

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

Skills: Excel, Data Entry, Data Processing, Visual Basic

See more: excel sheet marketing research survey data entry, getafreelancercom extract data website excel sheet, extracting data website excel sheet, how to get stock quotes in excel 2016, excel stock data type, download historical stock data into excel, excel stock quotes 2018, get stock quotes in excel from yahoo finance, real time stock quotes excel 2016, get stock quotes in excel from google finance, how to import stock prices into excel from google finance, can copy website data excel sheet, extracting data website excel, extract data website excel sheet, php extracting data excel sheet, copy data website excel sheet, excel vba download yahoo financial data, excel macros download yahoo financial data, can stock market data website, can extract selected data website import excel sheet

About the Employer:
( 37 reviews ) faridabad, India

Project ID: #20308861

30 freelancers are bidding on average ₹1073 for this job

maguirrer

Hello, I can help you with this project, I made something similar with yahoo finance, amazon and news sites. Please send me a message with the OK and I will start working on it immediately.

₹1500 INR in 3 days
(24 Reviews)
3.9
bktk

Hi, Sir After reading the project, I have reviewed your job description as well and very confident to handle this project perfectly. Sir I am ready to start work on project right now. Sir I have done many projects suc More

₹600 INR in 2 days
(44 Reviews)
4.0
kayemhussain

Dear hiring manager,, Fully understand your requirements & i am ready to start your work now & deliver to you within next 8 hour.I am highly experienced .Please sir give me a chance .I will start your work now. Tha More

₹1050 INR in 1 day
(12 Reviews)
3.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 More

₹1500 INR in 7 days
(10 Reviews)
2.7
superdev1888

Hello! Nice to meet you. I am available to you task. Hope to hear from you soon. if you want see what i do , i will provide u anytime. Thanks!

₹1050 INR in 7 days
(1 Review)
2.0
kulwantrana7

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. I am a hard worker, productive and worthy of yo More

₹600 INR in 7 days
(1 Review)
1.7
Rikuman

Hello, I have a good knowledge in using ms office especially excel. I am good at creating spreadsheet.

₹1250 INR in 3 days
(2 Reviews)
0.9
deendyalp421

I am interested in doing your work. Give a chance

₹750 INR in 5 days
(0 Reviews)
0.0
Cuambe

Hello, I read your project and identified all the steps as you posted and now feel confident to do the task. I am exposed to financial information on my day to day so I can understand financial data and so I've identif More

₹1500 INR in 7 days
(0 Reviews)
0.0
waqarahmadmughal

I can do this. I can provide you a quality of work I understand your requirments Give me a chance to enhance my skills

₹1300 INR in 1 day
(0 Reviews)
0.0
₹600 INR in 1 day
(0 Reviews)
0.0
kader09

Hi, I'm interested to work on your data entry project. I have read your job description and understand. I'll try my best to give you better service. I have a team who can work quickly without losing any quality of yo More

₹2000 INR in 4 days
(0 Reviews)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0
esguerraronaldv

I am a stock enthusiast myself and very aware of stock market terminologies. I have excellent MS Excel skills: from data management, pivot, essential macros, graph design and presentation, and even translating Excel da More

₹600 INR in 5 days
(0 Reviews)
0.0
akrewamp

I am very good a data entry . my speed is good .you can depend on me and complete the project on time.

₹1050 INR in 7 days
(0 Reviews)
0.0
husnainakhtar22

I have experience in administrative and clerical work  such as data entry/encoding,editing and copying, internet researching and diffirent kinds of paper works.I also have experience in IT software testing.i am profici More

₹850 INR in 5 days
(0 Reviews)
0.0
Gagansri

Gagansri $5 USD / hour Summary I am of experts in white hat SEO, Social media promotion, Website design and data entry

₹1300 INR in 1 day
(0 Reviews)
0.0
imechi

Hi, I work 16 hours a day with data, I'm Statistician, Data Scientist, Web Developer and I know I can help you to save time and have something with great quality. Can I extract information from pages to an excel table. More

₹600 INR in 7 days
(0 Reviews)
0.0
ppari442

I am fresher I have completed my graduation in this year I am free at home so I can easily give you 6 hours a day and I assure you that I will complete my work on time my typing speed is 32 wpm

₹1750 INR in 14 days
(0 Reviews)
0.0
gopalpbxx

I WILL DO MY JOB WITH 100% INVOLVEMENT , THIS IS MY FIRST BIDDING IN THIS WEBSITE , I WILL DO IT VERY WELL THANKING YOU

₹1050 INR in 5 days
(0 Reviews)
0.0