← Back

Product - March 27, 2019

Product Update: New & Improved Timeseries Analysis

YCharts’ Timeseries Analysis tool enables you to access, format, and export historical stock, mutual fund, and ETF metrics, as well as economic indicators. Because Timeseries Analysis is a vital resource for data-driven investment decisions, YCharts has updated the tool’s interface to better serve our users.

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.

For more information on how Timeseries Analysis can improve your process, start your 7 Day Free Trial, visit www.ycharts.com or reach out to your support contact.

Stay up to date,
subscribe to the YCharts blog