My return calculations look wrong

1 visualizzazione (ultimi 30 giorni)
P_Alpha
P_Alpha il 13 Ott 2015
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!

Risposte (0)

Categorie

Scopri di più su Startup and Shutdown in Help Center e File Exchange

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by