Cancelled

Excel spreadsheet that grabs stock data

create an excel 2010 spreadsheet that does the following

has stock tickers in rows in column A - up to 300 rows needed

goes to: [url removed, login to view]

and grabs the following data, and places the data in columns, in one row per stock, for each ticker in col a:

last price, todays change, next earnings date, beta, dividend yield, dividend freq*, dividend amount, Ex-Dividend Date, Dividend Payable Date

* return M for monthly, Q for quarterly, Y for yearly

so that's 10 columns of data. ALL 10 are req'd. I picked etrade, b/c it has reliable data. Yahoo finance cannot be used.

it needs to auto refresh at open; & every 10 minutes.

that's it - should be pretty straight forward.

Skills: Excel, Visual Basic, Web Scraping

See more: etrade excel spreadsheet, dividend excel spreadsheet, etrade stock data excel, excel dividend payable spreadsheet, etrade spreadsheet data, stock, snapshot, row spreadsheet, row b, price excel, finance excel, finance excel data, excel finance, excel ex, data visual, create spreadsheet, asp stock, spreadsheet columns, change refresh, excel row column, refresh excel spreadsheet, finance data excel, stocks data, excel column row, excel refresh

About the Employer:
( 0 reviews ) San Diego, United States

Project ID: #1279016

18 freelancers are bidding on average $48 for this job

srinichal

I can deliver the macro for the same

$80 USD in 3 days
(52 Reviews)
6.4
vbexcel

Data mining expert - ten years experience

$70 USD in 1 day
(28 Reviews)
5.4
jyothi009

Please view PM

$45 USD in 2 days
(19 Reviews)
5.0
muthumuni

Hi, I am expert for this job. So kindly see my review and contact me to get done it with in few hours. 100% satisfaction is my key... thank you. your satisfaction is my success. muthumuni

$30 USD in 0 days
(12 Reviews)
3.9
habayabah

Please read my PM for details of my bid.

$30 USD in 1 day
(3 Reviews)
3.2
jkumarsanson

Please refer my inbox

$30 USD in 1 day
(8 Reviews)
3.0
gravitysoftwares

Please check PMB.

$70 USD in 2 days
(2 Reviews)
2.6
tranvuongtrung

I have 5 experience years in Excel VBA, I did manything like this. I'm looking for 1st project in Freelancer, so I'll try my best to do it carefully. Thanks and best regards, Trung Tran

$45 USD in 3 days
(2 Reviews)
1.2
MDCTAS

Please see PMB.

$70 USD in 2 days
(0 Reviews)
0.0
ankit03

Hello MrZues , I am a computer engineer by profession with an experience of 5 years in coding . Got to recently know about this site and would be elated and interested to work in collaboration with you . Can prov More

$50 USD in 1 day
(0 Reviews)
0.0
sirshahbaz

I can to this project so give me a chance to complete this project

$50 USD in 4 days
(0 Reviews)
0.0
madu76

I am a full time online worker and i would like to work with you, i am new to freelancer

$30 USD in 10 days
(0 Reviews)
0.0
hartett

hi, would like to start working as a freelancer. i am new and have the required skills. i am competent and energetic and will deliver on time.

$30 USD in 2 days
(0 Reviews)
0.0
jw77

I am a trader and i do excell quickly.

$40 USD in 3 days
(0 Reviews)
0.0
mihiHarshana

Hi ..! I am capable of doing this. If you are interested please contact me thanks

$30 USD in 4 days
(0 Reviews)
0.0
Mashsoldier

none nothing

$50 USD in 3 days
(0 Reviews)
0.0
morzol

Dear Sir/Madame, I can create a desktop program runnable in Windows OS what will grab the web data each 10 minutes and produce a Excel spread sheet from it. Yours faithfully, Marian Morzol

$50 USD in 3 days
(0 Reviews)
0.0
saradawn

Hi my name is Sara, I have 10 years experience in writing, typing, and proofreading, and data entry, perfect skills in excel. If I am hired for the job relating to these requirements and skills, I promise you my work w More

$70 USD in 1 day
(0 Reviews)
0.0