Built-in formulas Extend() Extend with last value to the end of a period Extend with another value to a specified point in time Extend with last YoY percentage from same series ExtendLinear() vs LinearExtended() Extend trend from part of series Extend with value x observations from end of series Extend with x last values and … Continue reading “All about extending series”
How to: annualize a monthly P/P series with a formula? change the color of a series when it’s below / above 0 (or any other value)? create an if condition/statement? create a continuous growth rate? combine an if condition/statement with the logical operators and/or? disaggregate a series? make an index out of P/P series? replace … Continue reading “Calculations with formulas”
Overview Settings General Select method for creating matrix Select window type Output Example Overview Example of general use of Rolling principal components analysis: The Rolling principal components analysis (Rolling PCA) allows you to calculate a set of linearly uncorrelated series, or components, from a set of possibly correlated series. Rolling PCA enables you to do … Continue reading “Rolling principal components analysis”
Introduction Benefits of using Ratios Types of ratios How it works? Other macros Settings Frequency conversion Missing Data Seasonal adjustment Currency conversion Additional settings How to apply a ratio? Checking calculation behind a ratio Introduction With the Ratios feature, you can have most series as divided by common rations such as GDP or population in … Continue reading “Ratios”
Overview Estimation model References Settings Report Examples Questions If I’m getting p < 0.05 does that mean series has unit root or not? Overview Example of general use of Unit Root Test analysis showing report with various statistics: The Unit Root Test provides you with a tool to test if a series is non-stationary. More … Continue reading “Unit Root Test”
What is it for? Settings Any series All series All points Settings for Daily series Setting the Missing value method What is it for? The Observations setting allows you to adjust how inconsistencies between different calendars of observations should be treated. This is useful when time series have missing observations for certain calendar dates like … Continue reading “Observations setting”
Purpose Region key/Concept Change region / Change region & duplicate How to apply change? Change region in… Documents Series and expressions Series information Documents tab Multiple documents File > Open documents Presentation documents Purpose The Change region feature is used to replace a series in your document by an equivalent series for another country. Applying … Continue reading “Change Region”
Overview Settings Input series Automatic attributes for Value labels Calculations Settings for calculation methods Relative dates Point in time Time intervals Value labels Output series Methods Examples Questions How do I sort category series after Scalar? How to show date(s) of observation? What is the difference between the Rate of change analysis and selecting ‘Rate … Continue reading “Scalar”
Overview Estimation model Impulse Response Cholesky’s method for impulse response VECM Report Settings Examples Questions How to add and use dummy variable in VAR model? Overview Example of general use of Vector autoregression analysis: The Vector autoregression analysis (VAR) estimates the linear dependencies among a few series. The analysis can produce fitted values and forecasts … Continue reading “Vector autoregression”
Overview Settings Edit Value preference Missing value method Adding forecast Add a forecast at the beginning of the document Add a forecast after some calculations How to add forecast values? Keep in mind Examples Questions How to extend series with forecast? How to remove a forecast? How to disable the special presentation of forecast values? … Continue reading “Forecast”