Best way to Copy tables is go via Notepad to Excel (inserting commas in Notepad if needed). Hope you can make sense of it. Note. 5 Cols of Nos in for all dets Except ProjP - 4 Cols - 1st col meaningless, ProjP for last Year (Price known!) This is part of a much bigger system I have, so not sure if everything is correct - ie hacked it all together! As an accountant I imagine you are an Excel wizard, but am I old fashioned and don't know if you bother with that any more? Not really looked at… Read More
Apologies for spacing! Last looked right when I sent it but ignores Tabs and shrinks Spaces. What a Pain. bkgh Fac 0.98 Date Apr-15 Apr-16 Apr-16 Apr-16 Apr-16 Price 2639 2894 2198 2198 2198 N Eps 276.9 405.9 231.0 231.0 231.0 Eps Gr 46.6 46.6 -16.7 43.0 43.0 Per 9.5 7.1 9.5 9.5 9.5 Peg 0.205 0.153 -0.570 0.221 0.230 Proj Prc 3849 2198 3774 3922
bvs Fac 0.31 Date Dec-15 Apr-16 Dec-16 Dec-16 Dec-16 Price 989 832 1153 1153 1153 N Eps 93.6 112.1 109.0 109.0 109.0 Eps… Read More
Excel Calcs. To estimate current share price and next YearEnd share price. Assumptions. No Brexit! The last results of Coys reporting are not very different from previous results, which infers that EpsG, Margins ... .should not change much (regardless of forecasts!) Explanation of Table to follow. Price, N Eps & EpsG – fixed Data. Your Data, for next YE price. Enter your estimate for EpsG, 2nd last Col (in EpsG row) & Copy to Last Col Enter your estimate for Peg, Last Col… Read More
Well done Bazz.. an excellent level to buy in at- welcome aboard!
Crest has now outperformed the entire sector for two days consecutively after its heavy sell off- very pleasing to see it well above £5 again so quickly.
Half year end this week, followed by a trading update 2 weeks later and interim results mid June. This strong news pipeline should be supportive of the share price if sentiment remains reasonable.. hoping for a positive update from TW. on Thursday too.
Datafeed and UK data supplied by NBTrader and Digital Look.
While London South East do their best to maintain the high quality of the information displayed on this site,
we cannot be held responsible for any loss due to incorrect information found here. All information is provided free of charge, 'as-is', and you use it at your own risk.
The contents of all 'Chat' messages should not be construed as advice and represent the opinions of the authors, not those of London South East Limited, or its affiliates.
London South East does not authorise or approve this content, and reserves the right to remove items at its discretion.