CalcName: MXN_FXFwds_SpotDivByOR
FunctionName: CellFormula

MXN_FXFwds_SpotDivByOR
    0. Result
        =TargetCube(FxInput-30Yr) FxInput-30Yr(Days,"7d,14d,21d,1m,2m,3m,4m,5m,6m,7m,8m,9m,10m,11m,1y,15m,18m,21m,2y,3y,4y,5y,6y,7y,8y,9y,10y,11y,12y,13y,14y,15y,20y,25y,30y",{Currency})
        =TargetCube(FxInput-30Yr) FxInput-30Yr(SpotRatio,"7d,14d,21d,1m,2m,3m,4m,5m,6m,7m,8m,9m,10m,11m,1y,15m,18m,21m,2y,3y,4y,5y,6y,7y,8y,9y,10y,11y,12y,13y,14y,15y,20y,25y,30y",{Currency})
        =ThisCalc([Currency],{FXMultiplier=100|10000})
    1. Formula - [{2}-{1}]
        {2}-{1}
        1/(1+{4}/{5}/{3})
    2. Read Values
        =SourceCube(FxInput-30Yr) FxInput-30Yr(Dates,Spot,{Currency})
        =SourceCube(FxInput-30Yr) FxInput-30Yr(Dates,"7d,14d,21d,1m,2m,3m,4m,5m,6m,7m,8m,9m,10m,11m,1y,15m,18m,21m,2y,3y,4y,5y,6y,7y,8y,9y,10y,11y,12y,13y,14y,15y,20y,25y,30y",{Currency})
        =SourceCube(FxInput-30Yr) FxInput-30Yr(Forwards-Mid,Spot,{Currency})
        =SourceCube(FxInput-30Yr) FxInput-30Yr(Forwards-Mid,"7d,14d,21d,1m,2m,3m,4m,5m,6m,7m,8m,9m,10m,11m,1y,15m,18m,21m,2y,3y,4y,5y,6y,7y,8y,9y,10y,11y,12y,13y,14y,15y,20y,25y,30y",{Currency})
        ={FXMultiplier}
    3. Alert Strings (raised it expression is True)