Kapalı

Do some Excel Work

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

Beceriler: Veri Girişi, Veri İşleme, Excel

Daha fazlasını görün: need someone to create a excel template for me, microsoft excel formulas, london data entry, excel work in company, excel spreadsheet companies, data entry metrics, microsoft excel price, data entry london on, data entry in london, data entry companies london, who provide the work excel, stock shares, share trade, create an excel, create league table excel, live table etc league, microsoft excel template, populate excel spreadsheet spreadsheet, excel financial forecast, refresh excel spreadsheet, etc excel template, live excel data, move data excel, excel live data, excel refresh

İşveren Hakkında:
( 0 değerlendirme ) stockport, United Kingdom

Proje NO: #6495629

33 freelancer bu iş için ortalamada 161£ teklif veriyor

fhasanbd

A proposal has not yet been provided

in 3 gün içinde142£ GBP
(121 Değerlendirme)
6.3
dpune

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 fazlası

in 10 gün içinde150£ GBP
(96 Değerlendirme)
5.8
aarifakhtar

Hi : Here are few similar projects that I have done: [url removed, login to view] [url removed, login to view] Daha fazlası

in 5 gün içinde133£ GBP
(32 Değerlendirme)
5.1
vikas0903

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 fazlası

in 3 gün içinde111£ GBP
(18 Değerlendirme)
4.9
elqueabandona

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 fazlası

in 3 gün içinde150£ GBP
(17 Değerlendirme)
4.3
stevephillpott

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 fazlası

in 3 gün içinde150£ GBP
(1 Değerlendirme)
3.4
vikasroy63

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 fazlası

in 3 gün içinde250£ GBP
(2 Değerlendirme)
2.9
AccuPro

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.

in 30 gün içinde250£ GBP
(4 Değerlendirme)
2.3
sureshoragadam

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.

in 5 gün içinde222£ GBP
(4 Değerlendirme)
2.3
leelaaswanth

Hi Aswanth here. Having 4 years of experience R software and Excel and done so many similar [url removed, login to view] me for my work [url removed, login to view] give you 100% accurate and efficient output................. Thank you

in 3 gün içinde198£ GBP
(5 Değerlendirme)
2.1
hyattsaleh

Hello. I have experience wirking with excel and can guarantee you an excellent quality. Contact me so we can start working!

in 3 gün içinde90£ GBP
(1 Değerlendirme)
1.5
sreejithakaz

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 fazlası

in 3 gün içinde150£ GBP
(1 Değerlendirme)
1.2
kristofpeto

Még nem kapott javaslatot

in 3 gün içinde166£ GBP
(0 Değerlendirme)
0.0
RichDigitalD

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 fazlası

in 2 gün içinde150£ GBP
(0 Değerlendirme)
0.0
programmerr

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 fazlası

in 3 gün içinde150£ GBP
(0 Değerlendirme)
0.0
shubhamgupta6159

A proposal has not yet been provided

in 4 gün içinde155£ GBP
(0 Değerlendirme)
0.0
abhijitpore1

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 fazlası

in 3 gün içinde200£ GBP
(0 Değerlendirme)
0.0
rajeshcomprse

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 fazlası

in 3 gün içinde150£ GBP
(0 Değerlendirme)
0.0
jhu0721

A proposal has not yet been provided

in 3 gün içinde150£ GBP
(0 Değerlendirme)
0.0
mariaamelia

A proposal has not yet been provided

in 3 gün içinde150£ GBP
(0 Değerlendirme)
0.0