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.

the etrade link i provided was redirecting to a log in page.
it looks like it uses cookies, you don't actually have to be logged in, but it does add a ton of characters to the link
you can see it by doing this:
go here
middle of page on the left is box for quotes, enter a ticker there - it gives a really long link
but then if you enter another quote, the link shortens to this:

If the above is too cumbersome, I am ok, with using
there links are straight forward:
stock info:
earnings date:

I have attached a mock up spreadsheet with the req'd 10 fields

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, yahoo-finance, www excel, etrade com, dividend com, create symbol, stock, Snapshot, row spreadsheet, row b, price excel, finance in excel, finance excel, finance excel data, excel finance, excel ex, data visual, create spreadsheet, create an excel, asp stock, spreadsheet columns

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

Project ID: #1279016

18 freelancers are bidding on average $48 for this job


I can deliver the macro for the same

$80 USD in 3 days
(52 Reviews)

Data mining expert - ten years experience

$70 USD in 1 day
(28 Reviews)

Please view PM

$45 USD in 2 days
(19 Reviews)

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)

Please read my PM for details of my bid.

$30 USD in 1 day
(3 Reviews)

Please refer my inbox

$30 USD in 1 day
(8 Reviews)

Please check PMB.

$70 USD in 2 days
(2 Reviews)

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)

Please see PMB.

$70 USD in 2 days
(0 Reviews)

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)

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

$50 USD in 4 days
(0 Reviews)

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)

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)

I am a trader and i do excell quickly.

$40 USD in 3 days
(0 Reviews)

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

$30 USD in 4 days
(0 Reviews)

none nothing

$50 USD in 3 days
(0 Reviews)

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)

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)