Find Jobs
Hire Freelancers

Do some Excel Work

£20-250 GBP

已关闭
已发布超过 9 年前

£20-250 GBP

货到付款
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
项目 ID: 6495629

关于此项目

32提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
32威客以平均价£163 GBP来参与此工作竞价
用户头像
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 在3天之内
5.0 (206条评论)
6.8
6.8
用户头像
A proposal has not yet been provided
£142 GBP 在3天之内
4.8 (238条评论)
7.1
7.1
用户头像
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 在5天之内
4.9 (162条评论)
7.0
7.0
用户头像
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 在10天之内
4.9 (175条评论)
6.5
6.5
用户头像
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 在3天之内
5.0 (7条评论)
4.8
4.8
用户头像
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 在3天之内
5.0 (1条评论)
4.3
4.3
用户头像
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 在3天之内
4.9 (12条评论)
3.9
3.9
用户头像
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 在30天之内
5.0 (6条评论)
3.0
3.0
用户头像
A proposal has not yet been provided
£133 GBP 在3天之内
5.0 (1条评论)
2.6
2.6
用户头像
Hello. I have experience wirking with excel and can guarantee you an excellent quality. Contact me so we can start working!
£90 GBP 在3天之内
4.6 (1条评论)
2.3
2.3
用户头像
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 在5天之内
4.2 (4条评论)
2.3
2.3
用户头像
A proposal has not yet been provided
£150 GBP 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
£150 GBP 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
£150 GBP 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
£166 GBP 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
£150 GBP 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
stockport, United Kingdom
0.0
0
付款方式已验证
会员自9月 23, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。