Info
Questa domanda è chiusa. Riaprila per modificarla o per rispondere.
% Change Calc looks wrong
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hey everyone, I am trying to calculate the returns of stock prices, and my output from Matlab looks wrong when compared to excel. I have a 196x2 double named "TickeradjClose" where col 1 is dates, with the most recent date at the top, and column two is closing prices. My formula for calculating the return, as a decimal, is below (Sorry, it is sloppy as I am new to Matlab).
Tickerreturns=(((TickeradjClose(1:end-1,2)))-((TickeradjClose(2:end,2))))./TickeradjClose(2:end,2);
Please let me know what I am doing wrong. I have been asking some very basic questions recently, but hopefully I can pick this up as quickly as I picked up SQL and VBA so that I can begin to answer questions for others :)
Best!
0 Commenti
Risposte (1)
Walter Roberson
il 16 Ott 2015
Your calculation is algebraically equivalent to
Tickerreturns = TickerAdjClose(1:end-1,2)./TickerAdjClose(2:end,2) - 1;
Is that what you want?
Let us take the simple case of two values, which might be called Open and Close, then your calculation is (Open-Close)/Close which is Open/Close - 1 . Are you sure that is the order you want? For example alternatives would include (Close-Open)/Close and (Close-Open)/Open and (Open-Close)/Open .
Suppose something was 5 at day 1 and 10 at day 2. Then your current formula would be (5-10)/10 which would be -1/2 . Does that make sense to you? Wouldn't it make more sense to calculate (10-5)/5 = 2 ?
0 Commenti
Questa domanda è chiusa.
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!