Search

Categories

Show

Search Results

Searching for entries matching date, looking in keywords for any words
Found 1 matching entries

Entries

DateChecker: Identifies possible data gaps

I build this indicator to help me identify possible data gaps after importing historical data.

At this point, v001 simply looks at the yearly and monthly changes to make sure that if there is a change that the change is predicted (ie, 2009 comes after 2008; month 1 after month 12; month 4 after month 3).

I could have gotten more fancy with for statements and such, but instead I opted for a simple if-else framework so you can easily see what's going on.

If there is a data gap (ie, current month is 4 but the previous month is 11; current year is 2009 but the previous year is 2007), the indicator gives you a text visual alert.

I set up tick offsets off the High for the alert, month and year labels.

At some point in the future I may add in daily checks (or less), as well, but for the time being this serves my needs.

I'm happy to answer any reasonable questions or consider any reasonable improvements.

Good luck,

Aventeren

Category The Elite Circle

Details: DateChecker: Identifies possible data gaps
Category: The Elite Circle

February 11th, 2014
Size: 2.31 KB
Downloaded: 121 times

Keywords: alert date datechecker check year month