ASX Stock Information into excel

I have an excel file with a list of Australian Stock Exchange codes. I need to be able to have a job which I run by pushing a button in excel which will go and pick up the following stock information on these companies. Columns in excel file

Code - this is already populated by me, program to run down rows until there is now more, could be up to 2000 rows. The number of rows can vary depending upon what I have populated

Dividend ex date1 - all of the dividend ex date and dividend date and % Franked come from a page like the following [url removed, login to view] where the code Ax1 in the web address is populated from the Value stored in column A of the excel file. There will be 4 rows returned from the this page which should be returned in the columns which are listed next.

Dividend 1

% Franked 1

Gross Dividend 1 - will be excel formula I provide

Dividend ex date 2

Dividend 2

% Franked 2

Gross Dividend 2 - will be excel formula I provide

Dividend ex date 3

Dividend 3

% Franked 3

Gross Dividend 3 - will be excel formula I provide

Dividend ex date 4

Dividend 4

% Franked 4

Gross Dividend 4 - will be excel formula I provide

Latest Share Price - could come from following type of page [url removed, login to view] where the last 3 digits are the code from the first column in the excel file.

Today’s Date - this would populate with today’s date using standard excel today function formula

If you have a better way of retrieving this information I am more than open to hearing your alternate approach if easier.

Mention ‘carrot’ if you read to the bottom so I know that you have read the complete requirements.

I look forward to working with you.

This job was posted from a mobile device, so please pardon any typos or any missing details.

Skills: Excel Macros, Excel VBA, Python, Scripting, Web Scraping

See more: stock inventory information excel, stock information download excel, excel download stock information, download stock information excel, excel macro download stock information, projects information cost details database uae excel, updated bse nse stock prices excel format click, insert contact information excel, post information excel spreadsheet, visual basic text extract necessary information excel, project information excel dashboard, ways copy information excel, india stock market excel real time, web traffic information report details, stock data excel

About the Employer:
( 16 reviews ) City of Sydney, Australia

Project ID: #16360606

Awarded to:


"CARROT" Hi: I have read the project specs and I would suggest that a python script will be much better because it is better in handling web requests to servers. The overall process will still remain the same. You wou More

$111 AUD in 2 days
(36 Reviews)

8 freelancers are bidding on average $156 for this job


Hello, Thanks for your job posting. Having carefully looked at your project description. As a scraping expert, I can scrape any data from any website and save data to any databases using python,php,excel vba. If you More

$155 AUD in 3 days
(2 Reviews)

I have a lot of free time and I'm willing to work fast and effectively, so I would be very happy if I get awarded this [url removed, login to view] message me thanks

$55 AUD in 2 days
(2 Reviews)

Firstly, Carrot. Secondly, I have got my own excel file that keeps track of the Share Price for my portfolio, using an automatic script to download the info from the ASX site. I can adjust this code to work in your c More

$222 AUD in 5 days
(2 Reviews)

how are you,sir? I am a professional developer who has rich experience in this field. If you contact me, you and i will all be happy. Thank you for your reply in advance. ProjectName:ASX Stock Information into excel More

$155 AUD in 1 day
(1 Review)

"carrot" - Have good expertise in Excel macros data extraction, comparion and consolidation. - Have knowledge on Stocks, dividends and Options. Have done projects on End of Day stock prices, high, low, close and More

$200 AUD in 4 days
(1 Review)

A proposal has not yet been provided

$250 AUD in 1 day
(1 Review)

carrot. I have read from top to the bottom. I would like to discuss more on the problems. I am sure we can handle them. Thank you.

$100 AUD in 3 days
(1 Review)