Product - March 27, 2019
Product Update: New & Improved Timeseries Analysis
In-depth investment research often requires large data sets with multiple challenges: locating the data needed amongst various resources, aligning dates and frequencies for accuracy, then adjusting data sets to a format conducive to your analysis.
YCharts’ Timeseries Analysis was designed to help you overcome these challenges. Access raw historical data for stocks, funds, indices, and economic indicators from a single tool, select the reporting frequency of your choice with a click of the mouse, and easily export to Excel to run investment models.
YCharts’ Timeseries Analysis tool has been updated for even more time savings and greater ease of use. Below, we’ve outlined a few key ways in which Timeseries Analysis can be leveraged to easily build flexible and manageable data sets.
Organize Data With Unlike Frequencies
While making comparisons between two or more companies’ share price performance is pretty straightforward, comparing more granular metrics such as sales revenue, cost of goods sold, or R&D spend is slightly more complicated due to fiscal year reporting.
For example, Apple’s (AAPL) fiscal year ends in September, Microsoft’s (MSFT) ends in June, and Amazon’s (AMZN) in December. To accurately compare revenues for the three companies, we have to reconcile these period differences.
Timeseries Analysis enables you to organize this data with just a few clicks. As seen below, we can align sales figures and even add monthly retail sales as an economic bellwether.
Analyze Returns By Calendar Period
For analyzing security performance under certain market conditions, it can be helpful to frame performance by calendar year. This formatting will ensure an appropriate comparison between price movements and broader market events.
A common workflow is to compare returns for several asset classes in the years leading into and following the 2008 financial crisis. Creating a year-over-year returns table can be easily accomplished in Timeseries Analysis.
Aggregate Fundamental Data Historically Across a Group of Securities
What was the average P/E Ratio of the 30 stocks in the DOW each quarter for the last 10 years? How does that compare to the current average?
Just a few clicks in Timeseries Analysis will give you the answer along with the ability to scan for any outliers or trends.
Uncover Economic & Sector Trends
Economic Data comes in many formats and frequencies, not to mention from hundreds of sources. Timeseries Analysis allows you to compile a quarterly view of how several indicators are trending — helping you to notice valuable patterns in the economy. Add Sector returns to the table to see how each major sector is affected by these economic trends.
With a dedication to listening to and incorporating client feedback, YCharts continues to make investment data and research more accessible. The updated Timeseries Analysis tool delivers faster and more powerful analyses, greater ease of use, and is just another way YCharts enables smarter investment decisions.