Thanks for the thoughtful and detailed feedback, even though I might prove unworthy of your help. Also, I must mention that I noticed you didn't entirely read my post and it slightly bothered me.
I can understand your advice about the subroutine name, and I've changed the name from "myroutine" to "copy_print", because - as I wrote in my previous post which you didn't fully read - it first copies the previous value and then prints the new one.
Instead, I have a problem understanding (and therefore implementing) the other changes you suggested, because:
1) obviously I am not that good with VBA code, and I wouldn't want to write something I can't quickly and thoroughly understand.
2) obviously I am not an expert but I feel that your complex code will tire the cpu (and my small brain) just as much as my code. Instead of saying "do these 9 things", I'd be saying "do these x things for x equal to...". It would make sense - in my humble and ignorant opinion - if I were to change that number continuously in the future, but such number will be very static, with my 9 symbols traded (probably 13 in the future).
To answer your question, the value on row 500 - as I wrote in my previous post which you didn't entirely read - is simply the last printed price, the last value of the moving average. It gets printed there only after the previous value is copied to the row above (and the same happens to all the earlier values, that shift one row higher per minute, or whatever the update interval).
For some reason, I am not gifted at programming and I have to keep everything as simple as possible, which might be an advantage in some ways, but it gives me many limits. I've always felt pretty stupid among the users of this forum, and that is why I talk about having a "small" brain. Probably it doesn't have anything to do with the size of my brain, but with teachers and parents busting my balls too much as i was growing up, and making me hate Math and homework, to the point that when I see a formula i get some kind of allergic reaction that knocks out my reasoning capabilities.
Sorry about polemically pointing out that you didn't read completely my previous post, but you asked two questions that revealed such truth to me. Obviously you're quite talented at writing code and I am a moron at writing code, but I put effort into writing my posts, so I feel they should be read. I mean... you were actually commenting on a post which you hadn't read in its entirey, and asking me questions that were answered by the post itself. Maybe that's why you're so good with code, because you can't read anything other than programming code, so I guess you won't be reading this post either.
I can understand your advice about the subroutine name, and I've changed the name from "myroutine" to "copy_print", because - as I wrote in my previous post which you didn't fully read - it first copies the previous value and then prints the new one.
Instead, I have a problem understanding (and therefore implementing) the other changes you suggested, because:
1) obviously I am not that good with VBA code, and I wouldn't want to write something I can't quickly and thoroughly understand.
2) obviously I am not an expert but I feel that your complex code will tire the cpu (and my small brain) just as much as my code. Instead of saying "do these 9 things", I'd be saying "do these x things for x equal to...". It would make sense - in my humble and ignorant opinion - if I were to change that number continuously in the future, but such number will be very static, with my 9 symbols traded (probably 13 in the future).
To answer your question, the value on row 500 - as I wrote in my previous post which you didn't entirely read - is simply the last printed price, the last value of the moving average. It gets printed there only after the previous value is copied to the row above (and the same happens to all the earlier values, that shift one row higher per minute, or whatever the update interval).
For some reason, I am not gifted at programming and I have to keep everything as simple as possible, which might be an advantage in some ways, but it gives me many limits. I've always felt pretty stupid among the users of this forum, and that is why I talk about having a "small" brain. Probably it doesn't have anything to do with the size of my brain, but with teachers and parents busting my balls too much as i was growing up, and making me hate Math and homework, to the point that when I see a formula i get some kind of allergic reaction that knocks out my reasoning capabilities.
Sorry about polemically pointing out that you didn't read completely my previous post, but you asked two questions that revealed such truth to me. Obviously you're quite talented at writing code and I am a moron at writing code, but I put effort into writing my posts, so I feel they should be read. I mean... you were actually commenting on a post which you hadn't read in its entirey, and asking me questions that were answered by the post itself. Maybe that's why you're so good with code, because you can't read anything other than programming code, so I guess you won't be reading this post either.