Pengfei LI
Wednesday, 15 July, 2020
In this section, only the short data summary will be presented due to the complicated. All the data in this project is from Thomsom Reuters Datastream.
price_index <- read.csv("price_index.csv")
str(price_index)
'data.frame': 3310 obs. of 11 variables:
$ Exchange.Date: chr "2006-02-06" "2006-02-07" "2006-02-08" "2006-02-09" ...
$ Nasdaq : num 10798 10750 10859 10883 10919 ...
$ DJI : num 2259 2245 2267 2256 2262 ...
$ CSI300 : num 128 128 128 127 128 ...
$ SSEC : num 160 159 160 158 159 ...
$ FTSE100 : num 10086 10018 9968 10112 10053 ...
$ FTSE250 : num 16228 16113 16090 16310 16262 ...
$ CAC40 : num 5903 5909 5851 5937 5843 ...
$ DAX : num 6779 6792 6772 6880 6784 ...
$ year : int 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 ...
$ month : int 2 2 2 2 2 2 2 2 2 2 ...
The application in this project is also on the shiyapps website. The URL is as follows. https://skyspero.shinyapps.io/Stock_indices/
The application UI separate into two sections.
Left pane: 1. Select the area for the stock indices from North America, Europe and China; 2. Selcet the time horizon for data output in the right pane
Right pane: 1. Summary: This area presents the summary statistics for the select stock indices. 2. Structure: Here shows the data structure of the whole dataframe. 3. Data: The display for the data frame 4. Plot: the plot for dataframe
The file are also are available in the Github repository. The link is: https://github.com/Pengspero/Developing-Data-Products
In the repo, the downloaded data files of all the involved stock indices are presented in xlsx format. There is also a R markdown format report to give the description about this project. “Week 4.R” is an local file with all the data pre-processing code inside.
Thank you for your noble efforts to review this project!
Have a good day!