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.
Bu iş için 33 freelancer ortalamada £161 teklif veriyor
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 Daha Fazla
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- Daha Fazla
Hi, I have done similar project, for betting websites. Program had features to automatically collect live odds from various links and update excel-sheet. You can view project details and feedback at this link [https:/ Daha Fazla
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 exp Daha Fazla
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, Daha Fazla
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 Daha Fazla
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.
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.
Hi Aswanth here. Having 4 years of experience R software and Excel and done so many similar [login to view URL] me for my work [login to view URL] give you 100% accurate and efficient output................. Thank you
Hello. I have experience wirking with excel and can guarantee you an excellent quality. Contact me so we can start working!
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 Daha Fazla
I've worked quite extensively with Excel 2007/2010 and I am confident I can make the adjustments to your sheet as needed. I already have an idea for how to implement the automatically refreshing stock quotes, I would j Daha Fazla
There appear to be a number of options to get delayed prices into excel that refresh automatically. I would be happy to explore which one is best for your purposes. Furthermore ranking of the stocks should be fairly ea Daha Fazla
We have been an established an excellent track record for the best client satisfaction. We believe in keeping the clients happy and providing services at a very tempting price. We are known for timely delivery and high Daha Fazla
Hello, I am expert in data analysis/research/entry project. We have done lots of project for First American Title Insurance company, Core Logic & Safe Rent, all are US based companies. Data Quality will be deliv Daha Fazla