Can't figure out what I'm doing wrong. Using daily EOD data, I'm trying to run Exploration reports on Monthly data.
First I compress the Close to Monthly mc = TimeFrameCompress( C, inMonthly , compressLast); During the current month, the latest value for "mc" represents a mid-month value. Therefore, to get the prior month's close in an Exploration I need to take some steps. I can get the expected result using the Ref -1 approach: Range = n last days AddColumn(Ref(mc,-1), "Close (monthly)", 1.2); I think I should be able to get the correct value without using Ref -1 by setting the range to the end of the prior month. However, this does not work: Range = from 6/30/2010 to 6/30/2010 AddColumn(mc, "Close (monthly)", 1.2); When I do this it produces the monthly close from a year ago 6/30/09. Why am I getting one-year old data when setting the range to a past date?