as below
Excel Sheet Stock & Company Infos Hi!
Here is a very straight forward Explanation of the task! If you have a question pls contact me anytime. 1. Ticker & Company Name
The Ticker ist he shortening of the company name that you use in financial databases to identiy stocks of different companies. E.g. Amazon = AMZ, Netflix = NFLX, Apple = AAPL
If you type in the Ticker in the left corner, the excel sheet you then load all the right accompanying financial information of the stock/company. 2. Stockmetrics
Here all data regarding the stock should be listed. In this box you have to source the data from different sources.
Trailing P/E is the current P/E. Forward P/E is the expected P/E
ROE
Company Sector and Industry.
Target Price
Beta
3. Financials Box
This is exactly loaded from marketscreener. The only thats calculated manually is EBITA Marging (EBITA/SALES).
4. Debt
The same source as the financial box. Market screener.
5. Sales per Region
Also Market screener but this time a different tab. Use the Company Tab for Sales per Region.
6. Sales per Business
Also Market screener but this time a different tab. Use the Company Tab for Sales per Region
7. Surprises
Use the Calender Tab from Marketscreener.
8. Peer Group Figures.
Also under the company tab you will find the sector/industry peers. Just load the top 4 into the peer table and beneath the valuations.
9. Company Description
Use Reuters About:
10. Company News
https://www.reuters.com/companies/CPB.A/events
11. Volume & MAV
Just use sesssion volume and av volume of 20 sessions.
Sources:
Stockrow.com
Marketscreener.com
Yahoofinance.com