Find Jobs
Hire Freelancers

Do some Excel Work

£20-250 GBP

Closed
Posted over 9 years ago

£20-250 GBP

Paid on delivery
I require someone with extensive excel knowledge who can create an excel spreadsheet for me. I currently have a number of investments that trade, mostly over the London stock exchange (mostly AIM companies). And i have created my own spreadsheet that i collate most my information on. On my spreadsheet i allocate a tab for each company that takes my interest and usually copy previous financial data and also forecast future expected data... profit/losses etc which helps me understand if i should buy stock in that company. I then link a number of cells from one page (for company x) onto my main tab which is essentially a "shares league table". So i will have several tabs for different companies and i link a few cells from each individual tab to my main page "share league table page". My main page is just a league table which includes a number of cells where i populate key information about each stock, for example. name, number of shares in issue, assets, liabilities, predicted profits etc. Essentially once i input all the data the table will tell me if a stock is over/under valued. This is what i require: A new spreadsheet which is essentially a copy of my current layout, but i want the spreadsheet to automatically link to live streaming prices for each share. I currently have something similar where microsoft money provides live price data but i then have to press refresh to update the actual price. So, the spreadsheet will: * link to live streaming prices (its ok if this is delayed by 15 minutes but the spreadsheet must refresh this automatically.). * my league table will automatically moves shares up or down my table. (So if for any reason a share price jumps by 100% for example the market cap of that said company will have doubled. This is likely to move the share in question lower down my league table as it is no longer undervalued). Thats pretty much what i require. I will provide my current spreadsheet as a template as all the headed columns will be required to stay the same and you will need to keep the sums in place as each row has formulas in it will calculate certain metrics. Thanks, Phil
Project ID: 6495629

About the project

32 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
32 freelancers are bidding on average £163 GBP for this job
User Avatar
Hi Phil, my name is Cristian. I have a degree in Business and I am Financial Advisor. Besides working with excel every day. I have much experience with spreadsheets, formulas and macros. So I have the knowledge and experience necessary to make the changes you need in your spreadsheet. Check my excel reviews and chat with me. Greetings.
£150 GBP in 3 days
5.0 (206 reviews)
6.8
6.8
User Avatar
A proposal has not yet been provided
£142 GBP in 3 days
4.8 (238 reviews)
7.1
7.1
User Avatar
Hi : Here are few similar projects that I have done: https://www.freelancer.com/projects/Data-Entry-Excel/some-Excel-Work.5749498.html https://www.freelancer.com/projects/Excel-Web-Scraping/Australian-Stock-Screener-Excel.html Please note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects are related to Excel and macros. Please connect with me to discuss more.
£133 GBP in 5 days
4.9 (162 reviews)
7.0
7.0
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£150 GBP in 10 days
4.9 (175 reviews)
6.5
6.5
User Avatar
Great project and one that is very familiar to me, having just built a very similar application for my own share portfolio (although I do not use the league table approach). I used to use MSN Money as the price link, but that has since stopped working in the later version of excel, so I have rebuilt this using Yahoo finance. I have spent the last 14 years working in an investment back in back office operations, so the details of this sort of project are very familiar to me. I have great communication skills (check my references for corroboration), and a project management background to ensure this project is delivered promptly and to your requirements. I would need to see your template spreadsheet, but have some additional suggestions that I believe will help streamline your process, such as utilising a template sheet for new stocks (could be automatically created using VB code, with all links to the league table and I would include that in the bid price). I am available on messenger or Skype should you want to get a better understanding of my background and skills and am readily available to start this project as soon as possible. I look forward to working with you if I am successful in the bid. Regards Steve
£150 GBP in 3 days
5.0 (7 reviews)
4.8
4.8
User Avatar
Hi, I understand your requirement of a spreadsheet that automatically reflects current share price from some online source, predicts future share price and populates the most profitable shares on the league page. I possess excellent excel skills and can complete this task for you. Please acknowledge my proposal. Regards Vikas
£250 GBP in 3 days
5.0 (1 review)
4.3
4.3
User Avatar
I have over 8 years of experience in Excel and Access VBA. I have developed several Tools, Dashboard, Automation and Online Tools using VBA. I would be able to do this with Excel VBA, as i have done similar project for one of my client using Yahoo Live Data.
£150 GBP in 3 days
4.9 (12 reviews)
3.9
3.9
User Avatar
Hello Phil, I understand your requirement well since I myself built a vb app once to show streaming data which updated in real time. I am not sure if I can do that in Excel. Best regards, AccuPro.
£250 GBP in 30 days
5.0 (6 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
£133 GBP in 3 days
5.0 (1 review)
2.6
2.6
User Avatar
Hello. I have experience wirking with excel and can guarantee you an excellent quality. Contact me so we can start working!
£90 GBP in 3 days
4.6 (1 review)
2.3
2.3
User Avatar
Hi, I have more than 10+ years of experience in building customize utility tools for my client. Do count me for this project so that i can complete it on time. Regards Suresh.
£222 GBP in 5 days
4.2 (4 reviews)
2.3
2.3
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are a team of financial and IT experts with vast experience on the job hoping to do excellent job for you and you shall forever be happy doing business with us. Try us and reap the benefits of a good job done devoid of mistakes.
£222 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very interested in what you have to offer. I can be your mainstay in working on this project. I am sure, I will do it on time, so you can see the results of my work. and as an additional information, I have a team that will help me. BR///:D Jethro
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a MA in Finance and I worked on Excel & VBA in Largest banks in the world. I can create a file that pull data from internet and update your table. Do you have a prefered website where you would like get data from ? I hope we can work together.
£261 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£166 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a talented and experienced Data Entry Operator having good experience with Data Entry. If hired by you I will be responsible to complete the task within the stipulated time frame and with utmost confidence. Technical Skills: MS Word, MS Excel, Typing skills - 60wpm, Excellent spelling and grammar skills
£133 GBP in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
stockport, United Kingdom
0.0
0
Payment method verified
Member since Sep 23, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.