Hi everyone,
I have a time series set of monthly currency spot rates from multiple countries. I also have portfolio weigths per currency of those countries in the same set (see pic 1), which is supposed to be launched as a carry investment strategy.
What I wanted to do is to create a loop command in order to compute net spot returns per country. Then I would like create another loop to multiply those monthly net spot returns by the portfolio weights per country.
I first tested it for the country of Austria, according to the following formula, which worked out fine btw:
gen time = _n
gen spotlogreturns2 =(((SpotAustria[_n]) - (SpotAustria[_n-1])) / (SpotAustria[_n]))
gen PfReturnsAustria = ((spotlogreturns2[_n]) * (WeightAustria[_n]))
Then I created a loop for the net spot returns based on that formula as follows:
foreach var of varlist SpotCzechRepublic - SpotUK {
gen netreturn_`var' = (((`var’[_n]) - (`var’[_n-1])) / (`var’[_n]))
}
However, I received error r(198) code dislaying "`var' invalid name"(see pic2). Do you guys have an idea of what went wrong here? SInce, I am a beginner I am not even sure whether I set the loop command right. It would be great if somebody could help me with this!
Thank you guys so much,
Hans
Related Posts with Beginner question, loop command for net returns, error code r(198) "`var' invalid name"
Estimating the significance of fixed effects with clustered standard errorsHi all, I am estimating the following equation. Code: xtreg lemp lunion lunemployment lfertilit…
Covariance matrix of residuals in VAR modelI am estimating a VAR model in STATA. The model is as follows: Code: var potgap defl interest, no…
Calculating adjusted proportionsThere are examples of analyses using Stata (14) that calculates proportion of one variable by adjust…
Multi level modelling cross level analysisI want to examine the effect of education(xvar) on prejudice(yvar) (both 1. level variables) moderat…
Merging Datasets -- Variable Responses DeletedHi all, I am merging a number of different datasets and am having trouble with the merge command "d…
Subscribe to:
Post Comments (Atom)
0 Response to Beginner question, loop command for net returns, error code r(198) "`var' invalid name"
Post a Comment