Changes in the Standalone Front-End Interface
CHANGING MFMOD FRONT-END
INTERFACE
Overview of the Standalone Front-End
Changing
the Standalone Front-End
•
Unhide columns B and C of the NIA-Vols Sheet
Changing the Standalone Front-End
•
Now we can see the variable codes and variable triggers
Changing the Standalone Front-End
Column C has the
variable code – this tells
Eviews what series to
load into this row of the
spreadsheet
Changing the Standalone Front-End
For endogenous
variables we have three
codes per variable
Changing the Standalone Front-End
1)
NECONPRVTKN
(variable)
2)
_M model
suggestion
3)
_A Add-Factor
Changing the Standalone Front-End
Column B sets the
triggers of the
model. It tells the
model if you change
the “mode” of one
variable, how it
should change the
other variable
Changing the Standalone Front-End
Here we tell the
model that if you
change private
consumption to x
“exog” that it should
make the private
consumption add-
factor e “endog”
Changing the Standalone Front-End
Here we tell the
model that if you
change private
consumption to x
“exog” that it should
make the private
consumption add-
factor e “endog”
Changing the Standalone Front-End
Column E Sets the
“Modes” of the
model
X = Exogenous
E = Endogenous
I = Identity
Changing the Standalone Front-End
To Change the
Options in a Drop-
Down List in Excel –
go to the Data
Validation Button
Changing the Standalone Front-End
Change the Allow to
“LIST”
Write Each Option
You Want in the
Source: Box
Separate the
options with a
comma “,”
Changing the Standalone Front-End
Column F Sets the
Display Options for
Each Variable
G = Growth Rate
L = Level
Cont = contribution
to Growth
%gdp = Percent of
GDP
Changing the Standalone Front-End
To Change the
Options in a Drop-
Down List in Excel –
go to the Data
Validation Button
Changing the Standalone Front-End
Change the Allow to
“LIST”
Write Each Option You
Want in the Source:
Box
Separate the options
with a comma “,
"
Overview of the Standalone Front-End
“Reports” Page
Changing the Reports Page
Changing the Reports Page
First Difference is variable codes
You can write a formula in this
column now: for example
‘@pcy(NPLneconprvtkn)/@pcy(NPL
nygdpmktpkn)
calculates income elasticity to
consumption
In the display mode column F we add the
option ‘r’ which reports the calculation
from column C
Changing the Reports Page
If you want to just report a variable from
the model (from a different sheet)
without transformation, you can follow
the same logic as the other sheets
Adding sheets to Front-end
2 types of adding
Directly in the front-end
Programmatically (2 places to add based on sheet types) of the string
MFMSAOptions
Discover how the Standalone Front-End Interface integrates Eviews and Excel to facilitate calculations, enabling users to manipulate inputs, forecasts, and simulations seamlessly. Learn about un-hiding columns, variable codes, triggers, and model suggestions for effective data analysis and interpretation.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
CHANGING MFMOD FRONT-END INTERFACE
Overview of the Standalone Front-End What is the Front-End Loads Eviews in the Background to do all the calculations But uses Excel as the user-input User can make changes to inputs, forecasts, simulations in Excel and let Eviews do the hard work
Changing the Standalone Front-End Unhide columns B and C of the NIA-Vols Sheet
Changing the Standalone Front-End Now we can see the variable codes and variable triggers
Changing the Standalone Front-End Column C has the variable code this tells Eviews what series to load into this row of the spreadsheet
Changing the Standalone Front-End For endogenous variables we have three codes per variable
Changing the Standalone Front-End 1) NECONPRVTKN (variable) 2) _M model suggestion 3) _A Add-Factor 4)
Changing the Standalone Front-End Column B sets the triggers of the model. It tells the model if you change the mode of one variable, how it should change the other variable
Changing the Standalone Front-End Here we tell the model that if you change private consumption to x exog that it should make the private consumption add- factor e endog
Changing the Standalone Front-End Here we tell the model that if you change private consumption to x exog that it should make the private consumption add- factor e endog
Changing the Standalone Front-End Column E Sets the Modes of the model X = Exogenous E = Endogenous I = Identity
Changing the Standalone Front-End To Change the Options in a Drop- Down List in Excel go to the Data Validation Button
Changing the Standalone Front-End Change the Allow to LIST Write Each Option You Want in the Source: Box Separate the options with a comma ,
Changing the Standalone Front-End Column F Sets the Display Options for Each Variable G = Growth Rate L = Level Cont = contribution to Growth %gdp = Percent of GDP
Changing the Standalone Front-End To Change the Options in a Drop- Down List in Excel go to the Data Validation Button
Changing the Standalone Front-End Change the Allow to LIST Write Each Option You Want in the Source: Box Separate the options with a comma ,"
Overview of the Standalone Front-End Reports Page Reports Page Allows user to have a preset list of variables that they can easily find in one sheet Can mix fiscal, real, nominal, BOP, etc. Page also allows for custom calculations so you can report any type of transformation or mix of variables you are interested in. Very similar to other pages in how it operates
Changing the Reports Page In the display mode column F we add the option r which reports the calculation from column C First Difference is variable codes You can write a formula in this column now: for example @pcy(NPLneconprvtkn)/@pcy(NPL nygdpmktpkn) calculates income elasticity to consumption
Changing the Reports Page If you want to just report a variable from the model (from a different sheet) without transformation, you can follow the same logic as the other sheets
Adding sheets to Front-end 2 types of adding Directly in the front-end Programmatically (2 places to add based on sheet types) of the string MFMSAOptions
