Historical Simulation VaR

Last updated 9 November 2026

Function reference › Value at Risk (VaR) › Historical

61 GIAnalyzer functions for Excel. Optional arguments are shown in [brackets].

GIA_VaR_Historical_BondPortfolioChangeOnDate

Returns the change in the yield curve, FX rate or Credit Spread on the provided date.

GIA_VaR_Historical_BondPortfolioChangeOnDate(HYieldCurves, CurrencyData, SpreadData, VDate, Horizon, StartDate, EndDate, ChangeDate, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Change in the yield curve, FX rate or Credit Spread on the provided date

ArgumentUseDescription
HYieldCurvesRequiredThe array of historical yield curves.
CurrencyDataRequiredThe array of historical currency curves.
SpreadDataRequiredThe array of historical credit spreads by rating.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
ChangeDateRequiredWhich date's change to return.
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, Spread)
RiskFactorRequiredWhich bond market, FX pair, Rating class' change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_BondPortfolioDateOfScenario

Returns the date corresponding to the n-th worst scenario of a Bond portfolio, given historical prices.

GIA_VaR_Historical_BondPortfolioDateOfScenario(Portfolio, HYieldCurves, CurrencyData, SpreadData, VDate, Horizon, StartDate, EndDate, WhichScenario, Interpolation, ValueCalcType, InputFilter, VaRCurrency)

Returns: Date corresponding to the n-th worst scenario of a Bond portfolio

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
HYieldCurvesRequiredThe array of historical yield curves.
CurrencyDataRequiredThe array of historical currency curves.
SpreadDataRequiredThe array of historical credit spreads by rating.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichScenarioRequiredWhich scenario's date to return.
InterpolationRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (KR, FullValuation).
InputFilterRequiredWhether to trim the portfolio down to only some assets (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_BondPortfolioDateOrChange

Returns the date corresponding to the VaR scenario of a Bond portfolio, given historical prices.

GIA_VaR_Historical_BondPortfolioDateOrChange(Portfolio, HYieldCurves, CurrencyData, SpreadData, VDate, Horizon, StartDate, EndDate, ConfidenceLevel, Interpolation, ValueCalcType, InputFilter, VaRCurrency, PercentileCalcMethod, OutputType, IfContinuous, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Date corresponding to the VaR scenario of a Bond portfolio

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
HYieldCurvesRequiredThe array of historical yield curves.
CurrencyDataRequiredThe array of historical currency curves.
SpreadDataRequiredThe array of historical credit spreads by rating.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
ConfidenceLevelRequiredThe VaR confidence level.
InterpolationRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (KR, FullValuation).
InputFilterRequiredWhether to trim the portfolio down to only some assets (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutputTypeRequiredThe type of output (Date, Change).
IfContinuousRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, Spread)
RiskFactorRequiredWhich bond market, FX pair, Rating class' change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_BondPortfolioRisk

Returns the risk (DV01, Macaulay duration or Modified duration) of a bond portfolio.

GIA_VaR_Historical_BondPortfolioRisk(Portfolio, HYieldCurves, CurrencyData, SpreadData, VDate, Horizon, StartDate, EndDate, WhichDate, Interpolation, InputFilter, OutputFilter, VaRCurrency, RM)

Returns: Risk (DV01, Macaulay duration or Modified duration) of a bond portfolio

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
HYieldCurvesRequiredThe array of historical yield curves.
CurrencyDataRequiredThe array of historical currency curves.
SpreadDataRequiredThe array of historical credit spreads by rating.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichDateRequiredWhich date's return to calculate.
InterpolationRequiredThe interpolation method.
InputFilterRequiredWhether to trim the portfolio down to only some assets (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
RMRequiredThe risk measure type (DV01, MacaulayDuration, ModifiedDuration)

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_BondPortfolioValueOrPL

Returns the simulated value of a Bond portfolio at the chosen date, given historical prices.

GIA_VaR_Historical_BondPortfolioValueOrPL(Portfolio, HYieldCurves, CurrencyData, SpreadData, VDate, Horizon, StartDate, EndDate, WhichDate, Interpolation, ValueCalcType, InputFilter, OutputFilter, VaRCurrency, PLOrValue)

Returns: Simulated value of a Bond portfolio at the chosen date

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
HYieldCurvesRequiredThe array of historical yield curves.
CurrencyDataRequiredThe array of historical currency curves.
SpreadDataRequiredThe array of historical credit spreads by rating.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichDateRequiredWhich date's return to calculate.
InterpolationRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (KR, FullValuation).
InputFilterRequiredWhether to trim the portfolio down to only some assets (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_BondPortfolioVaR

Returns the value at risk of a bond portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_BondPortfolioVaR(Portfolio, HYieldCurves, CurrencyData, SpreadData, VDate, Horizon, StartDate, EndDate, ConfidenceLevel, Interpolation, ValueCalcType, InputFilter, OutputFilter, VaRType, VaRCurrency, PercentileCalcMethod)

Returns: Value at risk of a bond portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
HYieldCurvesRequiredThe array of historical yield curves.
CurrencyDataRequiredThe array of historical currency curves.
SpreadDataRequiredThe array of historical credit spreads by rating.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
ConfidenceLevelRequiredThe VaR confidence level.
InterpolationRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (KR, FullValuation).
InputFilterRequiredWhether to trim the portfolio down to only some assets (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate

Returns the date corresponding to the VaR scenario of a Bond portfolio, given historical prices.

GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate(FX_M, FX_H, EQ_M, EQ_H, EQ_DH, B_HCurves, B_HSp, Interp, IND_HInf, IND_HCPI, IND_DH, VLag, VDate, SDate, Horizon, Start, End, ChangeDate, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Date corresponding to the VaR scenario of a Bond portfolio

ArgumentUseDescription
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
ChangeDateRequiredWhich date's change to return.
RiskFactorGroupRequiredWhich variable's change to return (FX, EQ, Curve, Spread)
RiskFactorRequiredWhich bond market, FX pair, Rating class' change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario

Returns the date corresponding to the n-th worst scenario of an Equity+FX+Bond portfolio, given historical prices.

GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, IRD_P, VDate, SDate, Horizon, Start, End, WhichScenario, Comp, Days, CCY)

Returns: Date corresponding to the n-th worst scenario of an Equity+FX+Bond portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
WhichScenarioRequiredWhich scenario's date to return.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange

Returns the date corresponding to the VaR scenario of a Bond portfolio, given historical prices.

GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, Conf, PercCalc, CCY, Out, IfCont, RFGroup, RF, RFT)

Returns: Date corresponding to the VaR scenario of a Bond portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfRequiredThe VaR confidence level.
PercCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
CCYRequiredWhich currency to calculate the VaR in.
OutRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RFGroupRequiredWhich variable's change to return (Curve, FX, Spread)
RFRequiredWhich bond market, FX pair, Rating class' change to return.
RFTRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDATES, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedIRDPortfolioDATES(FX_Present, FX_M, FX_H, EQ_Present, EQ_M, EQ_H, EQ_DH, Bond_Present, B_HCurves, B_HSp, Interp, B_CalcT, IND_Present, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, IRD_Present, VDate, SDate, Horizon, Start, End)
ArgumentUseDescription
FX_PresentRequiredWhether FX data is present.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PresentRequiredWhether EQ data is present.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
Bond_PresentRequiredWhether bond data is present.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PresentRequiredWhether IND data is present.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PresentRequiredWhether IRD data is present.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL

Returns the simulated value of an Equity+FX+Bond portfolio at the chosen date, given historical prices.

GIA_VaR_Historical_CombinedIRDPortfolioValueOrPL(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, IRD_P, VDate, SDate, Horizon, Start, End, WhichDate, Comp, Days, CCY, PnLOrValue)

Returns: Simulated value of an Equity+FX+Bond portfolio at the chosen date

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
WhichDateRequiredWhich date's return to calculate.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
PnLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedIRDPortfolioVaR

Returns the value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_CombinedIRDPortfolioVaR(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, Conf, PercCalc, CCY, OutFilter, VaRType)

Returns: Value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfRequiredThe VaR confidence level.
PercCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
CCYRequiredWhich currency to calculate the VaR in.
OutFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedPortfolioChangeOnDate

Returns the date corresponding to the VaR scenario of a Bond portfolio, given historical prices.

GIA_VaR_Historical_CombinedPortfolioChangeOnDate(FX_M, FX_H, EQ_M, EQ_H, EQ_DH, B_HCurves, B_HSp, Interp, IND_HInf, IND_HCPI, IND_DH, VLag, VDate, SDate, Horizon, Start, End, ChangeDate, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Date corresponding to the VaR scenario of a Bond portfolio

ArgumentUseDescription
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
ChangeDateRequiredWhich date's change to return.
RiskFactorGroupRequiredWhich variable's change to return (FX, EQ, Curve, Spread)
RiskFactorRequiredWhich bond market, FX pair, Rating class' change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedPortfolioDateOfScenario

Returns the date corresponding to the n-th worst scenario of an Equity+FX+Bond portfolio, given historical prices.

GIA_VaR_Historical_CombinedPortfolioDateOfScenario(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, VDate, SDate, Horizon, Start, End, WhichScenario, Comp, Days, CCY)

Returns: Date corresponding to the n-th worst scenario of an Equity+FX+Bond portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
WhichScenarioRequiredWhich scenario's date to return.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedPortfolioDateOrChange

Returns the date corresponding to the VaR scenario of a Bond portfolio, given historical prices.

GIA_VaR_Historical_CombinedPortfolioDateOrChange(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, VDate, SDate, Horizon, Start, End, Comp, Days, Conf, PercCalc, CCY, Out, IfCont, RFGroup, RF, RFT)

Returns: Date corresponding to the VaR scenario of a Bond portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfRequiredThe VaR confidence level.
PercCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
CCYRequiredWhich currency to calculate the VaR in.
OutRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RFGroupRequiredWhich variable's change to return (Curve, FX, Spread)
RFRequiredWhich bond market, FX pair, Rating class' change to return.
RFTRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedPortfolioValueOrPL

Returns the simulated value of an Equity+FX+Bond portfolio at the chosen date, given historical prices.

GIA_VaR_Historical_CombinedPortfolioValueOrPL(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, VDate, SDate, Horizon, Start, End, WhichDate, Comp, Days, CCY, PnLOrValue)

Returns: Simulated value of an Equity+FX+Bond portfolio at the chosen date

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
WhichDateRequiredWhich date's return to calculate.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
PnLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_CombinedPortfolioVaR

Returns the value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_CombinedPortfolioVaR(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, B_HCurves, B_HSp, Interp, B_CalcT, IND_P, IND_HInf, IND_HCPI, IND_Seasons, IND_DH, VLag, VDate, SDate, Horizon, Start, End, Comp, Days, Conf, PercCalc, CCY, OutFilter, VaRType)

Returns: Value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
B_HCurvesRequiredThe array of historical bond yield curves.
B_HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe bond interpolation method.
B_CalcTRequiredThe bond valuation method (KR, FullValuation).
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
IND_DHRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfRequiredThe VaR confidence level.
PercCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
CCYRequiredWhich currency to calculate the VaR in.
OutFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_EquityPortfolioDateOfScenario

Returns the date corresponding to the n-th worst scenario of an Equity portfolio, given historical prices.

GIA_VaR_Historical_EquityPortfolioDateOfScenario(Portfolio, FX_MarketData, FX_HistData, EQ_MarketData, EQ_HistData, FX_DatesHandling, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, WhichScenario, Comp, Days, Filter1, Filter2, VaRCurrency)

Returns: Date corresponding to the n-th worst scenario of an Equity portfolio

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
FX_MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
FX_HistDataRequiredThe array of historical asset dates and spots in columns.
EQ_MarketDataRequiredThe currency market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
EQ_HistDataRequiredThe array of historical currency dates and spots in columns.
FX_DatesHandlingRequiredWhether the asset historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichScenarioRequiredWhich scenario's date to return.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_EquityPortfolioDateOrChange

Returns date or asset price change falling on the confidence level borderline, given of a portfolio in multiple markets and historical prices.

GIA_VaR_Historical_EquityPortfolioDateOrChange(Portfolio, FX_MarketData, FX_HistData, EQ_MarketData, EQ_HistData, FX_DatesHandling, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, Comp, Days, ConfidenceLevel, PercentileCalcMethod, OutputType, IfContinuous, Filter1, Filter2, Underlying, VaRCurrency)

Returns: Date or asset price change falling on the confidence level borderline

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
FX_MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
FX_HistDataRequiredThe array of historical asset dates and spots in columns.
EQ_MarketDataRequiredThe currency market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
EQ_HistDataRequiredThe array of historical currency dates and spots in columns.
FX_DatesHandlingRequiredWhether the asset historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfidenceLevelRequiredThe VaR confidence level.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutputTypeRequiredThe type of output (Date, Change).
IfContinuousRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
UnderlyingRequiredWhich asset's change to output if the OutputType is Change.
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_EquityPortfolioValueOrPL

Returns the simulated value of an Equity portfolio at the chosen date, given historical prices.

GIA_VaR_Historical_EquityPortfolioValueOrPL(Portfolio, FX_MarketData, FX_HistData, EQ_MarketData, EQ_HistData, FX_DatesHandling, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, WhichDate, Comp, Days, Filter1, Filter2, OutputFilter, VaRCurrency, PnLOrValue)

Returns: Simulated value of an Equity portfolio at the chosen date

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
FX_MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
FX_HistDataRequiredThe array of historical asset dates and spots in columns.
EQ_MarketDataRequiredThe currency market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
EQ_HistDataRequiredThe array of historical currency dates and spots in columns.
FX_DatesHandlingRequiredWhether the asset historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichDateRequiredWhich date's return to calculate.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
PnLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_EquityPortfolioVaR

Returns the value at risk of a portfolio in multiple markets over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_EquityPortfolioVaR(Portfolio, FX_MarketData, FX_HistData, EQ_MarketData, EQ_HistData, FX_DatesHandling, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, Comp, Days, ConfidenceLevel, PercentileCalcMethod, Filter1, Filter2, OutputFilter, VaRType, VaRCurrency)

Returns: Value at risk of a portfolio in multiple markets over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
FX_MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
FX_HistDataRequiredThe array of historical asset dates and spots in columns.
EQ_MarketDataRequiredThe currency market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
EQ_HistDataRequiredThe array of historical currency dates and spots in columns.
FX_DatesHandlingRequiredWhether the asset historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfidenceLevelRequiredThe VaR confidence level.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_FXPortfolioDateOfScenario

Returns the date corresponding to the n-th worst scenario of an FX portfolio, given historical prices.

GIA_VaR_Historical_FXPortfolioDateOfScenario(Portfolio, MarketData, HistData, DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, WhichScenario, Comp, Days, Filter1, Filter2, VaRCurrency)

Returns: Date corresponding to the n-th worst scenario of an FX portfolio

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
HistDataRequiredThe array of historical asset dates and spots in columns.
DatesHandlingRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichScenarioRequiredWhich scenario's date to return.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_FXPortfolioDateOrChange

Returns date or asset price change falling on the confidence level borderline, given an FX portfolio and historical prices.

GIA_VaR_Historical_FXPortfolioDateOrChange(Portfolio, MarketData, HistData, DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, Comp, Days, ConfidenceLevel, PercentileCalcMethod, OutputType, IfContinuous, Filter1, Filter2, Underlying, VaRCurrency)

Returns: Date or asset price change falling on the confidence level borderline

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
HistDataRequiredThe array of historical asset dates and spots in columns.
DatesHandlingRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfidenceLevelRequiredThe VaR confidence level.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutputTypeRequiredThe type of output (Date, Change).
IfContinuousRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
UnderlyingRequiredWhich asset's change to output if the OutputType is Change.
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_FXPortfolioValueOrPL

Returns the simulated value of an FX portfolio at the chosen date, given historical prices.

GIA_VaR_Historical_FXPortfolioValueOrPL(Portfolio, MarketData, HistData, DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, WhichDate, Comp, Days, Filter1, Filter2, OutputFilter, VaRCurrency, PLOrValue)

Returns: Simulated value of an FX portfolio at the chosen date

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
HistDataRequiredThe array of historical asset dates and spots in columns.
DatesHandlingRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
WhichDateRequiredWhich date's return to calculate.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_FXPortfolioVaR

Returns the value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_FXPortfolioVaR(Portfolio, MarketData, HistData, DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, Comp, Days, ConfidenceLevel, PercentileCalcMethod, Filter1, Filter2, OutputFilter, VaRType, VaRCurrency)

Returns: Value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
MarketDataRequiredThe asset market data table, consisting of the following rows: asset name, spot, volatility, dividend yield.
HistDataRequiredThe array of historical asset dates and spots in columns.
DatesHandlingRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
ConfidenceLevelRequiredThe VaR confidence level.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
Filter1RequiredWhether to trim the portfolio down to only derivatives or underlyings (Underlyings, Derivatives, NoFilter). Optional, NoFilter by default.
Filter2RequiredWhether to trim the portfolio down to only one asset (NoFilter, list of asset IDs delimited by commas with no spaces). Optional, NoFilter by default.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_INDPortfolioARRAY

Returns the value at risk of an IND portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_INDPortfolioARRAY(Portfolio, H_Curves, H_Inf, H_FX, H_CPI, Seasons, FX_DatesHandling, CPI_DatesHandling, VLag, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency)

Returns: Value at risk of an IND portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_InfRequiredThe array of historical inflation curves.
H_FXRequiredThe array of FX spots.
H_CPIRequiredThe array of historical present CPIs.
SeasonsRequiredThe array of seasonalities.
FX_DatesHandlingRequiredWhether the FX historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
CPI_DatesHandlingRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_INDPortfolioChangeOnDate

Returns an asset change over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_INDPortfolioChangeOnDate(H_Curves, H_Inf, H_FX, H_CPI, FX_DatesHandling, CPI_DatesHandling, VLag, VDate, SDate, Horizon, StartDate, EndDate, Interp, ChangeDate, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: An asset change over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
H_CurvesRequiredThe array of historical curves.
H_InfRequiredThe array of historical inflation curves.
H_FXRequiredThe array of FX spots.
H_CPIRequiredThe array of historical present CPIs.
FX_DatesHandlingRequiredWhether the FX historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
CPI_DatesHandlingRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ChangeDateRequiredWhich date's change to return.
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, Inflation, CPI)
RiskFactorRequiredWhich curve, FX pair, inflation's change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_INDPortfolioDateOfScenario

Returns the date of the n-th worst scenario of an IND portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_INDPortfolioDateOfScenario(Portfolio, H_Curves, H_Inf, H_FX, H_CPI, Seasons, FX_DatesHandling, CPI_DatesHandling, VLag, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, WhichScenario)

Returns: Date of the n-th worst scenario of an IND portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_InfRequiredThe array of historical inflation curves.
H_FXRequiredThe array of FX spots.
H_CPIRequiredThe array of historical present CPIs.
SeasonsRequiredThe array of seasonalities.
FX_DatesHandlingRequiredWhether the FX historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
CPI_DatesHandlingRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
WhichScenarioRequiredWhich scenario's date to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_INDPortfolioDateOrChange

Returns the date or change of value at risk scenario of an IND portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_INDPortfolioDateOrChange(Portfolio, H_Curves, H_Inf, H_FX, H_CPI, Seasons, FX_DatesHandling, CPI_DatesHandling, VLag, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, ConfidenceLevel, PCalc, OT, IfCont, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Date or change of value at risk scenario of an IND portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_InfRequiredThe array of historical inflation curves.
H_FXRequiredThe array of FX spots.
H_CPIRequiredThe array of historical present CPIs.
SeasonsRequiredThe array of seasonalities.
FX_DatesHandlingRequiredWhether the FX historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
CPI_DatesHandlingRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
PCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OTRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, Inflation, CPI)
RiskFactorRequiredWhich curve, FX pair, inflation's change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_INDPortfolioValueOrPL

Returns the value or PL of an IND portfolio at a chosen date over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_INDPortfolioValueOrPL(Portfolio, H_Curves, H_Inf, H_FX, H_CPI, Seasons, FX_DatesHandling, CPI_DatesHandling, VLag, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, OutputFilter, WhichDate, PLOrValue)

Returns: Value or PL of an IND portfolio at a chosen date over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_InfRequiredThe array of historical inflation curves.
H_FXRequiredThe array of FX spots.
H_CPIRequiredThe array of historical present CPIs.
SeasonsRequiredThe array of seasonalities.
FX_DatesHandlingRequiredWhether the FX historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
CPI_DatesHandlingRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
WhichDateRequiredWhich date's return to calculate.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_INDPortfolioVaR

Returns the value at risk of an IND portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_INDPortfolioVaR(Portfolio, H_Curves, H_Inf, H_FX, H_CPI, Seasons, FX_DatesHandling, CPI_DatesHandling, VLag, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, ConfidenceLevel, PercentileCalcMethod, OutFilter, VaRType)

Returns: Value at risk of an IND portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_InfRequiredThe array of historical inflation curves.
H_FXRequiredThe array of FX spots.
H_CPIRequiredThe array of historical present CPIs.
SeasonsRequiredThe array of seasonalities.
FX_DatesHandlingRequiredWhether the FX historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
CPI_DatesHandlingRequiredWhether the CPI historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
PercentileCalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutFilterRequiredWhich assets' contributions to VaR to output.
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_IRDPortfolioARRAY

Returns the value at risk of an IRD portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_IRDPortfolioARRAY(Portfolio, H_Curves, H_FX, H_Sp, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency)

Returns: Value at risk of an IRD portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_IRDPortfolioChangeOnDate

Returns an asset change over a chosen time horizon (number of days) during a specified period, given historical prices..

GIA_VaR_Historical_IRDPortfolioChangeOnDate(H_Curves, H_FX, H_Sp, VDate, SDate, Horizon, StartDate, EndDate, Interp, ChangeDate, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: An asset change over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ChangeDateRequiredWhich date's change to return.
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, credit spread, CPI)
RiskFactorRequiredWhich curve, FX pair, credit spread's change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_IRDPortfolioDateOfScenario

Returns the date of the n-th worst scenario of an IRD portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_IRDPortfolioDateOfScenario(Portfolio, H_Curves, H_FX, H_Sp, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, WhichScenario)

Returns: Date of the n-th worst scenario of an IRD portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
WhichScenarioRequiredWhich scenario's date to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_IRDPortfolioDateOrChange

Returns the date or change of value at risk scenario of an IRD portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_IRDPortfolioDateOrChange(Portfolio, H_Curves, H_FX, H_Sp, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, ConfidenceLevel, PCalc, OT, IfCont, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Date or change of value at risk scenario of an IRD portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
PCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OTRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, credit spread, CPI)
RiskFactorRequiredWhich curve, FX pair, credit spread's change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_IRDPortfolioValueOrPL

Returns the value or PL of an IRD portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_IRDPortfolioValueOrPL(Portfolio, H_Curves, H_FX, H_Sp, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, OutputFilter, WhichDate, PLOrValue)

Returns: Value or PL of an IRD portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
WhichDateRequiredWhich date's return to calculate.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_IRDPortfolioVaR

Returns the value at risk of an IRD portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_IRDPortfolioVaR(Portfolio, H_Curves, H_FX, H_Sp, VDate, SDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, ConfidenceLevel, CalcMethod, OutFilter, VaRType)

Returns: Value at risk of an IRD portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutFilterRequiredWhich assets' contributions to VaR to output.
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newBondPortfolioARRAY

Returns the value at risk of a bond portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newBondPortfolioARRAY(Portfolio, H_Curves, H_FX, H_Sp, VDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency)

Returns: Value at risk of a bond portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newBondPortfolioDateOfScenario

Returns the date of the n-th worst scenario of a bond portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newBondPortfolioDateOfScenario(Portfolio, H_Curves, H_FX, H_Sp, VDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, WhichScenario)

Returns: Date of the n-th worst scenario of a bond portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
WhichScenarioRequiredWhich scenario's date to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newBondPortfolioDateOrChange

Returns the date or change of value at risk scenario of a bond portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newBondPortfolioDateOrChange(Portfolio, H_Curves, H_FX, H_Sp, VDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, ConfidenceLevel, PCalc, OT, IfCont, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Date or change of value at risk scenario of a bond portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
PCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OTRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, credit spread, CPI)
RiskFactorRequiredWhich curve, FX pair, credit spread's change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newBondPortfolioValueOrPL

Returns the value or PL of a bond portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newBondPortfolioValueOrPL(Portfolio, H_Curves, H_FX, H_Sp, VDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, OutputFilter, WhichDate, PLOrValue)

Returns: Value or PL of a bond portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
WhichDateRequiredWhich date's return to calculate.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newBondPortfolioVaR

Returns the value at risk of a bond portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newBondPortfolioVaR(Portfolio, H_Curves, H_FX, H_Sp, VDate, Horizon, StartDate, EndDate, Interp, ValueCalcType, VaRCurrency, ConfidenceLevel, CalcMethod, OutFilter, VaRType)

Returns: Value at risk of a bond portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_CurvesRequiredThe array of historical curves.
H_FXRequiredThe array of FX spots.
H_SpRequiredThe array of historical credit spread curves.
VDateRequiredThe value date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
InterpRequiredThe interpolation method.
ValueCalcTypeRequiredThe bond valuation method (FullValuation, KR).
VaRCurrencyRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutFilterRequiredWhich assets' contributions to VaR to output.
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedChangeOnDate

Returns the change of a risk factor of a combined portfolio.

GIA_VaR_Historical_newCombinedChangeOnDate(FX_M, FX_H, EQ_M, EQ_H, EQ_DH, HCurves, HSp, Interp, IND_HInf, IND_HCPI, VLag, VDate, SDate, Horizon, Start, End, ChangeDate, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: Change of a risk factor of a combined portfolio

ArgumentUseDescription
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
ChangeDateRequiredWhich date's change to return.
RiskFactorGroupRequiredWhich variable's change to return (FX, EQ, Curve, Spread, Inflation, CPI)
RiskFactorRequiredWhich bond market, FX pair, Rating class' change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedPortfolioARRAY

Returns the PL array of a combined portfolio.

GIA_VaR_Historical_newCombinedPortfolioARRAY(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, HCurves, HSp, Interp, IND_P, IND_HInf, IND_HCPI, IND_Seasons, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, CCY, Filter)

Returns: PL array of a combined portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
FilterRequiredWhich assets to include in the calculation.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedPortfolioDateOfScenario

Returns the date of the n-th worst scenario of a combined portfolio.

GIA_VaR_Historical_newCombinedPortfolioDateOfScenario(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, HCurves, HSp, Interp, IND_P, IND_HInf, IND_HCPI, IND_Seasons, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, CCY, WhichScenario)

Returns: Date of the n-th worst scenario of a combined portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
WhichScenarioRequiredWhich scenario's date to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedPortfolioDateOrChange

Returns the PL array of a combined portfolio.

GIA_VaR_Historical_newCombinedPortfolioDateOrChange(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, HCurves, HSp, Interp, IND_P, IND_HInf, IND_HCPI, IND_Seasons, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, CCY, ConfidenceLevel, CalcMethod, OT, IfCont, RiskFactorGroup, RiskFactor, RiskFactorTerm)

Returns: PL array of a combined portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OTRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorGroupRequiredWhich variable's change to return (Curve, FX, credit spread, CPI)
RiskFactorRequiredWhich curve, FX pair, credit spread's change to return.
RiskFactorTermRequiredWhich yield curve term's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedPortfolioValueOrPL

Returns the PL array of a combined portfolio on a given date or scenario number.

GIA_VaR_Historical_newCombinedPortfolioValueOrPL(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, HCurves, HSp, Interp, IND_P, IND_HInf, IND_HCPI, IND_Seasons, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, CCY, WhichDate, PLOrValue, ConsolidateToClasses)

Returns: PL array of a combined portfolio on a given date or scenario number

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
WhichDateRequiredWhich date's return to calculate (date in OADate format or scenario number preceeded by #).
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).
ConsolidateToClassesRequiredWhether to consolidate the VaR components into product classes (Bond, FX, EQ, IND, IRD) or keep them separated by IDs (Yes, No).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedPortfolioVaR

Returns the PL array of a combined portfolio.

GIA_VaR_Historical_newCombinedPortfolioVaR(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, HCurves, HSp, Interp, IND_P, IND_HInf, IND_HCPI, IND_Seasons, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, CCY, ConfidenceLevel, CalcMethod, OutFilter, VaRType)

Returns: PL array of a combined portfolio

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutFilterRequiredWhich assets' contributions to VaR to output.
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newCombinedPortfolioVaRComponents

Returns the PL array of a combined portfolio on a given date or scenario number.

GIA_VaR_Historical_newCombinedPortfolioVaRComponents(FX_P, FX_M, FX_H, EQ_P, EQ_M, EQ_H, EQ_DH, B_P, HCurves, HSp, Interp, IND_P, IND_HInf, IND_HCPI, IND_Seasons, VLag, IRD_P, VDate, SDate, Horizon, Start, End, Comp, Days, CCY, ConfidenceLevel, CalcMethod, ConsolidateToClasses)

Returns: PL array of a combined portfolio on a given date or scenario number

ArgumentUseDescription
FX_PRequiredThe FX portfolio.
FX_MRequiredThe FX asset market data.
FX_HRequiredThe FX historical data.
EQ_PRequiredThe EQ portfolio.
EQ_MRequiredThe EQ asset market data.
EQ_HRequiredThe EQ historical data.
EQ_DHRequiredWhether the historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
B_PRequiredThe bond portfolio.
HCurvesRequiredThe array of historical bond yield curves.
HSpRequiredThe array of historical bond credit spreads by rating.
InterpRequiredThe curve interpolation method.
IND_PRequiredThe portfolio data table, see example or documentation for formating.
IND_HInfRequiredThe array of historical inflation curves.
IND_HCPIRequiredThe array of historical CPIs.
IND_SeasonsRequiredThe array of seasonalities.
VLagRequiredThe difference in months between the month of the value date and the last month included in the latest CPI.
IRD_PRequiredThe portfolio data table, see example or documentation for formating.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartRequiredThe first date in the required period.
EndRequiredThe last date in the required period.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
CCYRequiredWhich currency to calculate the VaR in.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
ConsolidateToClassesRequiredWhether to consolidate the VaR components into product classes (Bond, FX, EQ, IND, IRD) or keep them separated by IDs (Yes, No).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newEQPortfolioARRAY

Returns the value at risk of an EQ portfolio over a chosen time horizon (number of days) during a specified period, given historical spots.

GIA_VaR_Historical_newEQPortfolioARRAY(Portfolio, H_FX, M_FX, H_EQ, M_EQ, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days)

Returns: Value at risk of an EQ portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
H_EQRequiredThe array of EQ spots.
M_EQRequiredThe array of supplemental EQ data.
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newEQPortfolioChangeOnDate

Returns an asset change over a chosen time horizon (number of days) during a specified period, given historical prices..

GIA_VaR_Historical_newEQPortfolioChangeOnDate(H_FX, M_FX, H_EQ, M_EQ, EQ_DatesHandling, Horizon, StartDate, EndDate, ChangeDate, RiskFactor)

Returns: An asset change over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
H_EQRequiredThe array of EQ spots.
M_EQRequiredThe array of supplemental EQ data.
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
ChangeDateRequiredWhich date's change to return.
RiskFactorRequiredWhich FX pair's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newEQPortfolioDateOfScenario

Returns the date of the n-th worst scenario of an EQ portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newEQPortfolioDateOfScenario(Portfolio, H_FX, M_FX, H_EQ, M_EQ, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, WhichScenario)

Returns: Date of the n-th worst scenario of an EQ portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
H_EQRequiredThe array of EQ spots.
M_EQRequiredThe array of supplemental EQ data.
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
WhichScenarioRequiredWhich scenario's date to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newEQPortfolioDateOrChange

Returns the date or change of value at risk scenario of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newEQPortfolioDateOrChange(Portfolio, H_FX, M_FX, H_EQ, M_EQ, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, ConfidenceLevel, PCalc, OT, IfCont, RiskFactor)

Returns: Date or change of value at risk scenario of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
H_EQRequiredThe array of EQ spots.
M_EQRequiredThe array of supplemental EQ data.
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
ConfidenceLevelRequiredThe VaR confidence level.
PCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OTRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorRequiredWhich FX pair's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newEQPortfolioValueOrPL

Returns the value or PL of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newEQPortfolioValueOrPL(Portfolio, H_FX, M_FX, H_EQ, M_EQ, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, OutputFilter, WhichDate, PLOrValue)

Returns: Value or PL of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
H_EQRequiredThe array of EQ spots.
M_EQRequiredThe array of supplemental EQ data.
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
WhichDateRequiredWhich date's return to calculate.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newEQPortfolioVaR

Returns the value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newEQPortfolioVaR(Portfolio, H_FX, M_FX, H_EQ, M_EQ, EQ_DatesHandling, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, ConfidenceLevel, CalcMethod, OutFilter, VaRType)

Returns: Value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
H_EQRequiredThe array of EQ spots.
M_EQRequiredThe array of supplemental EQ data.
EQ_DatesHandlingRequiredWhether the currency historical data table has only one shared column for dates and how to handle mismatched dates if it does not. (Yes, No_Fill, No_Discard).
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutFilterRequiredWhich assets' contributions to VaR to output.
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newFXPortfolioARRAY

Returns the value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical spots.

GIA_VaR_Historical_newFXPortfolioARRAY(Portfolio, H_FX, M_FX, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days)

Returns: Value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newFXPortfolioChangeOnDate

Returns an asset change over a chosen time horizon (number of days) during a specified period, given historical prices..

GIA_VaR_Historical_newFXPortfolioChangeOnDate(H_FX, M_FX, Horizon, StartDate, EndDate, ChangeDate, RiskFactor)

Returns: An asset change over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
ChangeDateRequiredWhich date's change to return.
RiskFactorRequiredWhich FX pair's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newFXPortfolioDateOfScenario

Returns the date of the n-th worst scenario of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newFXPortfolioDateOfScenario(Portfolio, H_FX, M_FX, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, WhichScenario)

Returns: Date of the n-th worst scenario of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
WhichScenarioRequiredWhich scenario's date to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newFXPortfolioDateOrChange

Returns the date or change of value at risk scenario of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newFXPortfolioDateOrChange(Portfolio, H_FX, M_FX, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, ConfidenceLevel, PCalc, OT, IfCont, RiskFactor)

Returns: Date or change of value at risk scenario of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
ConfidenceLevelRequiredThe VaR confidence level.
PCalcRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OTRequiredThe type of output (Date, Change).
IfContRequiredWhich date/change to consider falling on the borderline if the CalcMethod is Continuous (Low, High, Nearest).
RiskFactorRequiredWhich FX pair's change to return.

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newFXPortfolioValueOrPL

Returns the value or PL of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newFXPortfolioValueOrPL(Portfolio, H_FX, M_FX, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, OutputFilter, WhichDate, PLOrValue)

Returns: Value or PL of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
OutputFilterRequiredWhich assets' contributions to VaR to output (All, Underlyings, Derivatives, list of asset IDs delimited by commas with no spaces).
WhichDateRequiredWhich date's return to calculate.
PLOrValueRequiredWhether to return the profit/loss or raw value (PL, Value).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES

GIA_VaR_Historical_newFXPortfolioVaR

Returns the value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period, given historical prices.

GIA_VaR_Historical_newFXPortfolioVaR(Portfolio, H_FX, M_FX, VDate, SDate, Horizon, StartDate, EndDate, VaRCurrency, Comp, Days, ConfidenceLevel, CalcMethod, OutFilter, VaRType)

Returns: Value at risk of an FX portfolio over a chosen time horizon (number of days) during a specified period

ArgumentUseDescription
PortfolioRequiredThe portfolio data table, see example or documentation for formating.
H_FXRequiredThe array of FX spots.
M_FXRequiredThe array of supplemental FX data.
VDateRequiredThe value date.
SDateRequiredThe spot date.
HorizonRequiredThe VaR horizon, in days.
StartDateRequiredThe first date in the required period.
EndDateRequiredThe last date in the required period.
VaRCurrencyRequiredWhich currency to calculate the VaR in.
CompRequiredThe default compounding for when it's not provided in the portfolio.
DaysRequiredThe default time basis for when it's not provided in the portfolio.
ConfidenceLevelRequiredThe VaR confidence level.
CalcMethodRequiredThe percentile calculation method (Continuous, DiscreteNearest, DiscreteLow, DiscreteHigh).
OutFilterRequiredWhich assets' contributions to VaR to output.
VaRTypeRequiredThe type of VaR disaggregation (None, Component, Marginal, Incremental, Shortfall).

See also: GIA_VaR_Historical_BondPortfolioChangeOnDate, GIA_VaR_Historical_BondPortfolioDateOfScenario, GIA_VaR_Historical_BondPortfolioDateOrChange, GIA_VaR_Historical_BondPortfolioRisk, GIA_VaR_Historical_BondPortfolioValueOrPL, GIA_VaR_Historical_BondPortfolioVaR, GIA_VaR_Historical_CombinedIRDPortfolioChangeOnDate, GIA_VaR_Historical_CombinedIRDPortfolioDateOfScenario, GIA_VaR_Historical_CombinedIRDPortfolioDateOrChange, GIA_VaR_Historical_CombinedIRDPortfolioDATES