robertogozzi wrote:

Importing the attached ITF file will spare you from having to add variables.

Sorry to be a pain Rob, I’ve hit a wall of sorts and it looks similar to the ITF you kindly provided back in the day (it too hits the same wall when plotting past the end of the old month and into a new month). Not posting this as a bump because I know you have your hands full more so to say there’s a bit of consistency here and it could be a simple one for your IP.

I can plot lines half a dozen different ways (just about) and they work well w/in a given month, it’s only when you lean into the next months plot(s) that it falls over.

I’ve even peeled out the last day of the month compute and it has no effect, so I’m guessing in there is the solution vs DayCount cfg perhaps.

I know the dates are in numeric format and the ‘additional days’ are in integer form but I’ve not been able to push by what appears to be a hard limit (for me). Probably my lack of IP … !

Below is a basic setup that manifests in the same way as the previously linked ITF. Just pushout the NumberOfDays variable past months end and it should break. The ITF linked a few pages back by you will also error. I feel like a bit of a dill not having picked up on it back in the day – would’ve prevented the need to revisit now but it’s now that as I’m putting together a housekeeping guide for family that I’ve come back to it. The historical ITF was extremely helpful in identifying where APAC and EU sessions influence, so many thanks for that input (was foundational for me with PRT).

/rant

Cheers,

inv

defparam drawonlastbaronly=true



// Define the anchor date (MyDate1), month (MyMM), and year (MyYY)
MyDate1 = 20240118  // Assign the anchor date
//MyMM = 10     // Assign the month
//MyYY = 23     // Assign the year






// Initialize the number of days ahead for each subsequent Date
NumberOfDays = 00 // Change this value to adjust the number of days ahead
NumberOfDays1 = 09 // Change this value to adjust the number of days ahead
NumberOfDays2 = 12 // Change this value to adjust the number of days ahead





// Calculate subsequent dates
MyDateA = MyDate1 + NumberOfDays
MyDateB = MyDate1 + NumberOfDays1
MyDateC = MyDate1 + NumberOfDays2





//


drawvline(datetobarindex(MyDateA))style(dottedline,2)coloured("red")
drawvline(datetobarindex(MyDateB))style(dottedline,2)coloured("red")
drawvline(datetobarindex(MyDateC))style(dottedline,2)coloured("red")



//inc. to POC formatt could be okay and straightup plots vlines where it should
//drawvline(datetobarindex(20240215))style(dottedline,2)coloured("red")
//drawvline(datetobarindex(202402150000+000000140000))style(dottedline,2)coloured("red")
//drawvline(datetobarindex(20240215000000+00000014000000))style(dottedline,2)coloured("red")






// Initialize MyDD, MyMM, and MyYY
MyDD = Day
MyMM = Month
MyYY = Year



//
DayCount       = NumberOfDays
While DayCount > 00 DO
//
// make sure it’s the same number of digits for days < 10
//If MyDD < 10 Then  //was 10 but needed to go to 0
//
If MyDD < 00 Then
MyDate = (MyYY * 10000) + (MyMM * 1000) + MyDD
Else
MyDate = (MyYY * 10000) + (MyMM * 100) + MyDD
Endif






// 1. compute the last day of the month
LastDay = 31


// 2. it’s max 30 on a few months
If MyMM = 4 or MyMM = 6 or MyMM = 9 or MyMM = 11 Then
LastDay = 30
Endif


// 3. it’s max 28 days in February, 29 on a leap year
If MyMM = 2 Then
LastDay = 28


If Year MOD 4 = 0 Then
If Year MOD 100 = 0 Then
If Year MOD 400 = 0 Then
LastDay = 29
Endif
Else
LastDay = 29
Endif
Endif
Endif
//
MyDD = MyDD + 1



// 4. if it’s greater than LastDay it’s the next month
If MyDD > LastDay Then
MyDD = 1
MyMM = MyMM + 1


// 5. if it’s greater than 12 it’s a new year
If MyMM > 12 Then
MyMM = MyMM - 12
MyYY = MyYY + 1
Endif
Endif
//
DayCount = DayCount - 1     //one day has been plotted
wend
return

Many thanks Rob, your feedback is appreciated!

I’ll have a look when I get a moment, probably closer to weekend, could be sooner, kind of eager to iron this one out or shelve it if need be, yet, I’m ever hopeful it can be sorted … 🙂

oldDate  = 20210723
DD       = oldDate MOD 100        //get DAY
tempDate = (oldDate - DD) / 100
MM       = tempDate MOD 100       //get MONTH
YY       = (tempDate - MM) / 100  //get YEAR
tempDD   = DD + 99                //add 68 days to compute the new date
tempX    = DD






oldDate1  = 20210823
DD1       = oldDate1 MOD 100        //get DAY
tempDate1 = (oldDate1 - DD1) / 100
MM1       = tempDate1 MOD 100       //get MONTH
YY1      = (tempDate1 - MM1) / 100  //get YEAR
tempDD1   = DD1 + 233                //add 68 days to compute the new date
tempX1    = DD1






While 1 Do
LastDay = 31
IF MM = 4 OR MM = 6 OR MM = 9 OR MM = 11 THEN
LastDay = 30
ELSIF MM = 2 THEN
LastDay = 28
IF YY MOD 4 = 0 THEN
IF YY MOD 100 = 0 THEN
IF YY MOD 400 = 0 THEN
LastDay = 29
ENDIF
ELSE
LastDay = 29
ENDIF
ENDIF
ENDIF

myRemainder = tempDD - LastDay
IF myRemainder <= 0 THEN
break
ENDIF
tempDD = tempDD - LastDay
MM = MM + 1
IF MM > 12 THEN
YY = YY + 1
MM = 1
ENDIF
tempX = 0

Wend




While 1 Do
LastDay = 31
IF MM1 = 4 OR MM1 = 6 OR MM1 = 9 OR MM1 = 11 THEN
LastDay = 30
ELSIF MM1 = 2 THEN
LastDay = 28
IF YY1 MOD 4 = 0 THEN
IF YY1 MOD 100 = 0 THEN
IF YY1 MOD 400 = 0 THEN
LastDay = 29
ENDIF
ELSE
LastDay = 29
ENDIF
ENDIF
ENDIF

myRemainder = tempDD1 - LastDay
IF myRemainder <= 0 THEN
break
ENDIF
tempDD1 = tempDD1 - LastDay
MM1 = MM1 + 1
IF MM1 > 12 THEN
YY1 = YY1 + 1
MM1 = 1
ENDIF
tempX1 = 0



Wend





newDate = (YY * 10000) + (MM * 100) + tempDD  //pack data into a new date

newDate1 = (YY1 * 10000) + (MM1 * 100) + tempDD1  //pack data into a new date



drawvline(datetobarindex(olddate))style(dottedline,2)coloured("red")
drawvline(datetobarindex(newdate))style(dottedline,2)coloured("red")
drawvline(datetobarindex(newdate1))style(dottedline,2)coloured("red")


return

The above works but as you can see it’s a replication of one process to add another single plot, which I’m happy to say works well, so there’s wins here.

Is there another way to do this without replicating large chunks I wonder?

Needing to ‘decompose’ the anchoring date each time is the crux here (thanks for emphasizing this Rob) , so we can ‘add’ too it and create the subsequent day counts, then run though the lastday/date loop to process the plot accordingly.

I can tweak the lastday/date loop, to ‘bundle’ all the dates and years w/in the single loop (I think) but if I wanted 30 of them, wow, I’m hoping there’s an easier way.

I’ll have a go at it again and see if I can compress a little, no doubt it’ll be a right mess but I’ll have a go. Any words of wisdom are welcomed and appreciated.

Cheers,

inv

I don’t know what to say Rob. Thankyou. Honestly wow.

I’ll give this a lookover, so I can do it a bit of justice.

The current setup from, your workings, as I have tweaked it, adds days to a single date as well, as seen further on up above, my last effort, so will try that with myDateCaller, where I’ll have a series of numbers to be added to the date or dates. We count forward random day counts from a single date.

So we’ll have say:

$myDate[1]  = 20210723

plus 3 days

plus 12 days

plus 20 days

plus 27 days

We’ll plot these days.

It’s here where I became unglued if you will and had to create multiple DateSums equiv. but here you’re calling it to calc out.

Yes, I think this will do nicely on that front but will I be able to handle the multiple days as above, 3, 12, 20 etc or will I need to call the days as well.

I have a go and let you know how it goes, fingers crossed … 🙂

Many thanks again.

All works well … 🙂