[EquisMetaStock Group] help sought in designing a scan to report nil or n/a for days whenthere are no trades

[VasanthMohan G Buddaan <vgbudawn@xxxxxxx>]

Discussions about EquisMetaStock

I need to get a report on open interest variations in the Open Interests of 1 month and 2 month futures. 

I used the Ref() function to retrieve the data of previous days. But on certain days there are no trades in the 2 month futures resulting in a data hole in the file. With the Ref() function, this in turn results in getting the data of the day before which is not what I want.

Tried using the Day of Month() function but the scan says nothing to report for both the month futures.

I need the scan report me either 'nil' data or 'n/a' on the days when there are no trades in the futures. 

Will appreciate any help in solving my problem.

gv


[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/