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.
33 freelancer bu iş için ortalamada 161£ teklif veriyor
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 projects.Ping me for my work samples.Will give you 100% accurate and efficient output................. Thank you