Thanks for a good walk through, but you have holes in the data set (weekends etc), so it is rather moving average of last 7 and next 7 observations.

Is there...

Hi

It may be a case of not supplying the user credentials.

Depending on your security settings the credentials Will either be blind to the developer or not stored at all....