How to get a list in XL or HTML including each company in the market with its
Turnover (Sales) and profit (Earnings before tax and interest EBIT)
preferably by market segment for both of the London Stock Exchange
(LSE) and the Alternative Investment Market (AIM) |
Request for Question Clarification by
rainbow-ga
on
13 Sep 2005 09:54 PDT
Hi petercoo,
Please take a look at the following website:
http://www.londonstockexchange.com/en-gb/pricesnews/statistics/listcompanies/
The website provides various excel sheets for download. Here's one:
All Listed Companies - updated monthly (MS Excel 3411Kb)
What additional information do you require that can be manually added to the sheet?
Looking forward to your clarification.
Best regards,
Rainbow
|
Clarification of Question by
petercoo-ga
on
13 Sep 2005 10:59 PDT
Hi Rainbow-ga
The fields shown on the document link are
List date Company Group Sub sector Country of Origin Market Ord
Shs Dep Rcpts Fxd Int Wts Mkt Cap £m techMARK Company URL.
The fields don't include what I want which is for each of those
companies listed, SALES and EBIT. I hope that this clarifies the
question
|
Request for Question Clarification by
rainbow-ga
on
13 Sep 2005 11:13 PDT
Thank you for your clarification.
Please take a look at this example for 1st Dental Laboratories PLC:
http://www.londonstockexchange.com/LSECWS/IFSPages/MarketNewsPopup.aspx?id=965429&source=RNS
Correct me if I'm wrong; the turnover is £5,835,517 and EBIT £928,183.
If these figures were added manually to the list for all the countries
in the excel file, would this suffice as an answer to your question?
Regards,
Rainbow
|
Clarification of Question by
petercoo-ga
on
13 Sep 2005 12:09 PDT
Hi rainbow
regarding 1st Dental -those are the numbers I'm looking for! If those
2 numbers could be added for the 3000+ companies on the list, it would
completely answer my question.
Rgds Petercoo
|
Request for Question Clarification by
rainbow-ga
on
13 Sep 2005 12:23 PDT
Hi Petercoo,
Unless there is a list of this information already compiled, manually
searching for and adding these figures to the excel sheet would take
days, if not more. I will keep searching and let you know of any
progress I have.
Best regards,
Rainbow
|
Clarification of Question by
petercoo-ga
on
13 Sep 2005 14:22 PDT
Hi rainbow
The infomation I am seeking is a matter of public record and so I
thought that it must be available on the web somewhere
|
Request for Question Clarification by
rainbow-ga
on
14 Sep 2005 05:25 PDT
Hi Petercoo,
After further research, I was not able to locate this information.
Hopefully another researcher will have better luck.
All the best,
Rainbow
|
Clarification of Question by
petercoo-ga
on
14 Sep 2005 06:02 PDT
Thanks for trying rainbow
Rgds Petercoo
|
