Rank: Newbie
Groups: Registered, Registered Users
Joined: 6/28/2010(UTC)
Posts: 2
|
Hi guys,
I'm using a formula in the explorer scan which looks at closing price, but it keeps returning securities which haven't traded in months (like expired options). I'm interested in looking at the day before's closing price, not the securities last closing price
I've tried adding the Alert and Reference functions but they haven't made a difference. I've also tried changing the periodicity to "Specific Date" and only load "Minimum Records", but still no go.
Is there any easy way to scan for things that have occurred in the last day / couple days ? Thanks for your help :)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/25/2010(UTC)
Posts: 55
|
This may or may not complete address your question but you can run an exploration for the last date traded:
col A: Month()
col B: DayOfMonth()
col C: Year()
If you see anything that hasn't been traded in a while then right click, Edit Data (opens The Downloader), and change or delete symbol.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/15/2005(UTC)
Posts: 24
|
Give this a try. I use it all the time.
Choose an Explorer tab, say column A and label it "Date". Add the following code within it:
dy := xx;
mn := yy;
yr := zzzz;
(DayOfMonth() = dy) AND (Month() = mn) AND
(Year() = yr)
where xx, yy and zzzz are the particular day, month and year for which you want Explorer to evaluate your criteria. Also, when in the Explorer Editor, click on the "Options" button and select "Specific Date" for the "Exploration Date" and enter those same day, month and year. Then check the "Use Filter" box.
Finally, in the "Filter" tab, enter colA if that is the tab where you placed this code, as I suggested for this example. If you have other filter critera, then connect them with this one using "AND colA".
Systematic
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
