Heiken Ashi - first bar?

[c.chugani]

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.

 

[c.chugani]

37 views.. yet no one knows how to calculate this indicator?

 

[IronFist]

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.