I need SQL that will run in Microsoft Access 2010 that calculate the 5 day exponential moving average of a stock price ("ticker"). I intend to cut and paste your code into Access. It must run without modifications. I have attached a spreadsheet that shows the calculation.
Table Name = Export
Field Names = Ticker, Date, Close, EMA5
I need to SQL to update the EMA5 field with that correct values.
See attached spreadsheet.
Note that there are multiple ticker values in the table.