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 [login to view URL] 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.
% Franked 1
Gross Dividend 1 - will be excel formula I provide
Dividend ex date 2
% Franked 2
Gross Dividend 2 - will be excel formula I provide
Dividend ex date 3
% Franked 3
Gross Dividend 3 - will be excel formula I provide
Dividend ex date 4
% Franked 4
Gross Dividend 4 - will be excel formula I provide
Latest Share Price - could come from following type of page [login to view URL] 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.
8 freelancers are bidding on average $156 for this job
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