Completed

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: download yahoo finance data into excel vba, import stock prices into excel 2013, excel stock quotes 2017, how to download historical data from yahoo finance to excel, yahoo finance api, get stock quotes in excel from google finance, download historical stock data into excel, how to import stock prices into excel from google finance, 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

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

Project ID: #16360606

Awarded to:

aarifakhtar

"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)
5.8

8 freelancers are bidding on average $156 for this job

anatolygenay123

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)
2.4
mtdevil369

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 [login to view URL] message me thanks

$55 AUD in 2 days
(2 Reviews)
2.2
Sercho56

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)
2.1
bondwp322

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)
1.8
satishtl

"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)
1.7
usmanhassan123

A proposal has not yet been provided

$250 AUD in 1 day
(1 Review)
1.6
tbrifki64

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)
0.0