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"
Error message with usespssDear all, I'm trying to open a dataset with over 25 million observations using usespss. After runni…
"assert inrange(var1,1,5)" and "assert inrange(var1,1,5)&!missing(var1)"What's the difference between "assert inrange(var1,1,5)" and "assert inrange(var1,1,5)&!missing(…
Generating New Variable As A Function of Group-Level Differences Of Another VariableHello All, and Thanks in Advance. I have a very large dataset for which I need to create a variable…
rifreg and oaxaca8 error In order to analyze gender wage gap, the following is conducted. However, It is impossible to proce…
repeatedly getting error when trying to create a panel "repeated time values within panel r(451)"I have the following data type. I have four countries with 50 companies each for three years. I was …
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