So basically I got some finance project, and being new to finance I need to know even the basic shit to know how to do stuff.
Basically I'm working on a OHLC (Open-High_Low-Close) Chart in Excel, its basically about a company of course, and the stats (opens, highs lows and closes ) are Monthly, total 60 months.
I now have to calculate the "monthly return" and "average monthly return" from the given chart, how can i do that? Maybe a formula or some necessary explanation will help out
if not i think i can send the chart to the person willing to help
please guys this is kinda urgent ill love u if u help me out thanks
Also before that, how do i calculate the simple profit of a single month from those values?
Basically I'm working on a OHLC (Open-High_Low-Close) Chart in Excel, its basically about a company of course, and the stats (opens, highs lows and closes ) are Monthly, total 60 months.
I now have to calculate the "monthly return" and "average monthly return" from the given chart, how can i do that? Maybe a formula or some necessary explanation will help out
if not i think i can send the chart to the person willing to help
please guys this is kinda urgent ill love u if u help me out thanks
Also before that, how do i calculate the simple profit of a single month from those values?