I'm trying to construct these bars with excel. I'm having a problem calculating the FIRST bar in a series though. How do you come up with the OHLC values for the FIRST bar if you don't have a previous bar for reference? The formula for Heiken Ashi is as follows: xClose = (Open+High+Low+Close)/4 o Average price of the current bar xOpen = [xOpen(Previous Bar) + Close(Previous Bar)]/2 o Midpoint of the previous bar xHigh = Max(High, xOpen, xClose) o Highest value in the set xLow = Min(Low, xOpen, xClose) o Lowest value in the set Am I missing something here? Thanks for any help in advance.
Maybe skip the first bar. Kind of like how if you have a 10 period MA you don't get any MA value for the first 9 bars.