Alpha Geek
$10/per page/Negotiable
One evening your sister-in-law Yolanda, who you fear, tells you that she has developed a new investment strategy. She only holds gold bullion or Shares in an S&P500 index mutual fund, depending on the prices of these two investments. If the value of gold goes over $1261/oz. or the S&P index is below 1895 she sells gold and buys S&P Index; otherwise she holds her current position. I suggest, rather timidly, that with market volatility being high, she might also consider waiting for the conditions to remain the same for at least 3 trading days before executing the S&P500 purchase. She uncharacteristically agrees and even smiles at me. Yolanda asks you to create a logical function using the IF(), AND(), and OR() functions in Excel to tell her explicitly to either "Hold Current Investment Position, Yoli!" or "Sell Gold and Buy S&P Index, Yoli!". Base the logic on the three elements discussed above. Create your logical function in the model below. (Hint: The OR will be used for the first 2 conditions--1261 and 1895-- and AND will be used for the results of the OR and 3 days.) Please list all steps in order to complete this assignment in excel! Thank you!
Â