Thursday, 12 June 2014

Visualising time series data – An example with share price information



Something I have been thinking about recently is how students new to the use of financial information come to grips with visualising the information as data. Now my corporate sensibilities may come out somewhat in this post as much of my use of financial information as data was taught there but the key element is to make the information into data that can be a weapon that you use for your assignment.

Let us look at the example of the share price of a company (I have picked Papa John’s Pizza) and I can go to the investor relations page of the company and obtain this information.

Just type in the company name followed by the phrase “investor relations” and you should get a top hit of the investor relations page (which is a page where listed companies need to disclose and publish particular affairs).

 
 

Now somewhere within the investor relations page is a section that will show the share price, Company A and Company B may call the section a different thing but fundamentally we are looking for the section of the investor relations page focused on the share price.

  


For this particular company the page was called Stock Information and I was able to obtain the last share price as well as the highest and lowest share price throughout the year.

The most interesting  part is what I am going to call the time series chart at the bottom of the screen grab that tells an interesting story. Here we have the share price of the company according to set dates throughout the year. By visualising the information to data we can see that there had been a steady rise from May 2013 up to April 2014 and that has subsequently followed by a fall in the share price to the present day.

Consequently there is the temptation to look at key time periods where there has been a significant shift in the share price. However, Papa John’s International is one company amongst thousands in an interconnected stock exchange system. With this line of thought wanting to look at the comparison between Papa John’s share price and that of the stock exchange where it is listed (NASDAQ) makes sense.

I go to the Reuters website (and there are many other sources that can do similar), lookup Papa John’s and in the Charts section see a section called Comparisons where I can compare Papa John’s International with NASDAQ.

 


Now that I am comparing two related sets of information against each other the performance of Papa John’s International has essentially followed the performance of the market (a possible exception could be from April 2014-June 2014). It is after recognising, retrieving and visualising information on the connection between company and stock market can share price performance be judged.

A word of warning for those considering a similar type of visual for their assignments is to make sure they acknowledge the intellectual debt they owe. In other words, cite and reference it. The Learning Resources webpage has a referencing section under Library Guides that will prove useful but it is worth remembering that a visual like the one above will be referenced as a weblink. 

References: 
Papa John's Pizza (2014) Investor Relations Available at: http://ir.papajohns.com/ (Accessed 12 June 2014)
 Reuters (2014) Charts: Papa John's International Inc. Available at: http://uk.reuters.com/business/quotes/chart?symbol=PZZA.O (Accessed 12 June 2014)


 


Thursday, 1 May 2014

Drop in and see me.

  • Are you fed up trying to access the full text of articles and being asked to pay?  
  • Have you had feedback on your referencing skills and are wondering how to improve them?
  • Do you want to know how really useful the library catalogue can be?
I can answer these questions for you and many others and I will be in room F101b (the small room opposite Training Room 1) every Monday between 2pm and 3pm.   No appointment needed, no question too big or too small.  Just come and see me.

Wednesday, 23 April 2014

Tackling those tricky questions.



As we head towards end of year exams, graduations and possibly summer jobs - or maybe just jobs!  I thought this upcoming workshop at the City Business Library on the 29th April title 'Winning at Interviews' might be useful for some of you.

As you can see from the list there are lots of other sessions you also might find useful as well and all for the princely sum of £3 (plus train fare of course)!

You can find out how to get there here: http://www.cityoflondon.gov.uk/about-the-city/Documents/how-to-get-to-guildhall-map.pdf

Monday, 7 April 2014

Happy New Year! (Tax year that is)

Just to get you in the mood the BBC have compiled this short quiz:

 http://www.bbc.co.uk/news/business-26852265

I'm too embarrassed to tell you my score but see how you get on. 

Thursday, 3 April 2014

I'm Miley Surprised when reading the FT.

Well at first I  was going to show you this:http://www.bbc.co.uk/news/business-26865174

But then I saw this and if there was ever something I thought would never happen it would be finding Miley Cyrus on the front cover of the Financial Times (the online cover at least)! Yes you read that correctly - the FT has Miley Cyrus on their front page.  

Briefly summarising,  the young lady involved has a few concerts booked in a Helsinki venue owned by 3 Russians who appear on the recent US sanctions list; making it a little tricky to complete financial transactions between the concert organisers and venue.  

 If you have signed up to the FT website you can read it here: http://www.ft.com/cms/s/0/0a0dcbbe-ba6e-11e3-aeb0-00144feabdc0.html

Or the entire article will appear in our newspaper database, Newsbank, soon (there is a slight time delay). 

Or head on over to Level 1 of the library where we have the hard copy on our newstand.