in commodity the current month exp is on 31 aug...i want sept futures to align with old data..means aug n previous data... what to do?
There are different ways to do that.
Create watch list for September and link them to Excel.
1. Start Real time feed and merge the August scrips into Sept. scrips in Amibroker Menu Symbol-Merge. However, you will see a spike in price on the 1st day since future of next month will be above the future of current month due to interest differential. Your oscillators like stochastic will go bonkers.
2. Backfill data for the new month scrips for what ever period available. Delete the data for last month scrips for that period and merge the remaining. This will give you smoother alignment. Do it after market hours.
3. In the first column in Excel, you may overwrite scrip name manually say NIFTY-I and link only the rest of the columns. So you get the same effect as in 1.