Problem calculating a range of values

[MartinJWilliams]

Hi,

I'm trying to calculate a range of values between certain time frames but am getting some errors. The range calculates fine if I use the 'Now' feature but if I specify between 240-180 minutes for example, the calculation seem to run into an issue. Any ideas on what the issue may be?

22/11/2023 14:32:09: [G_Auto 3] : Unable to : Store (range calc) Value (Shared) for Either Or: ltp_4hr_average. Calculated value is invalid.
22/11/2023 14:32:09: [G_Auto 3] : Unable to : Store (range calc) Value (Shared) for Either Or: ltp_3hr_average. Calculated value is invalid.
22/11/2023 14:32:09: [G_Auto 3] : Unable to : Store (range calc) Value (Shared) for Either Or: ltp_2hr_average. Calculated value is invalid.
22/11/2023 14:32:09: [G_Auto 3] : Store (range calc) Value (Shared) for Either Or: ltp_1hr_average = 4.034 = 4

Screenshot 2023-11-22 143849.png

[Dallas]

Do you have a SV rule populating the history list 13
at least 4hrs before you are trying to run this calculation of the range of values?

[Dabbla]

Were the markets being refreshed in guardian during the 2 to 4 hours that the calculations can be done for ? ?

[MartinJWilliams]

Thanks for getting back to me.

I've been running it all day and the latest log remains the same 'calculate value is invalid', so within range of the specified period to collect data.
I have a separate SV collecting data and storing it to the history file, this is ticked as shared.
Guardian is refreshing at the fastest refresh rates.

[MartinJWilliams]

If I change the the periods from 240m until 'now' for example, the calculations then display the following. I'm a bit concerned that the numbers are all the same for each reading though as I'm sure they shouldn't be.


22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Katar: ltp_4hr_average = 8.995
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Katar: ltp_3hr_average = 8.995 = 9
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Katar: ltp_2hr_average = 8.995 = 9
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Katar: ltp_1hr_average = 8.995 = 9
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Yaahobby: ltp_4hr_average = 15.099
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Yaahobby: ltp_3hr_average = 15.099 = 15
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Yaahobby: ltp_2hr_average = 15.099 = 15
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Yaahobby: ltp_1hr_average = 15.099 = 15
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Cuban Grey: ltp_4hr_average = 24.793
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Cuban Grey: ltp_3hr_average = 24.793 = 25
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Cuban Grey: ltp_2hr_average = 24.793 = 25
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Cuban Grey: ltp_1hr_average = 24.793 = 25
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Teresa Grace: ltp_4hr_average = 34.356
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Teresa Grace: ltp_3hr_average = 34.356 = 34
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Teresa Grace: ltp_2hr_average = 34.356 = 34
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Teresa Grace: ltp_1hr_average = 34.356 = 34
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Fair And Square: ltp_4hr_average = 43.338
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Fair And Square: ltp_3hr_average = 43.338 = 44
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Fair And Square: ltp_2hr_average = 43.338 = 44
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Fair And Square: ltp_1hr_average = 43.338 = 44
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Another Angel: ltp_4hr_average = 49.889
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Another Angel: ltp_3hr_average = 49.889 = 50
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Another Angel: ltp_2hr_average = 49.889 = 50
22/11/2023 16:41:50: [G_Auto 3] : Store (range calc) Value (Shared) for Another Angel: ltp_1hr_average = 49.889 = 50

[MartinJWilliams]

*Bump*

Anyone got any ideas on what the issue may be here? Thanks.

1) Confirmed that the information is being stored in History List 13
2) Confirmed that Guardian has been storing data for over 4hrs
3) Confirmed that Guardian is refreshing at 20m/s

[Dallas]

How many markets do you have in Guardian approx?

[MartinJWilliams]

Never more than 25 at the start of the day. I remove the closed markets as they are played out so this number reduces down throughout the day.

[MartinJWilliams]

I've since tried changing the range from seconds to minutes and BA is now calculating the values correctly. It seems that BA is struggling with the volume of data when set to seconds over these periods.

[Dallas]

That was the reason I asked about the number of markets you had in guardian

To ensure they run effeciently there is only a set number of data points a history list can hold before the earlier ones start being over written.
Typically you get about half an hour at half second intervals, about 5 hours at five second intervals and then a couple of days at 30 second intervals.

That assumes you are refreshing the market that quickly (ie, at 20ms with only 25 markets loaded)
f it's only on a cycle of updating the market once a minute, then you'd get longer.

If you slowed the refresh rate of each market down ie, so each market is refreshes once every second the hi-res one would give you an hour accurate to that second, but you'd still get the 5 hrs of data being stored accurate to the nearest five seconds and still get the 2 days of lower res data.

[MartinJWilliams]

Thanks, that all makes sense now.