Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

mister ed

Volume Moving Average

Recommended Posts

A Volume moving average; I like the idea so I know if the volume in the market is higher than average, indicating outside money flowing in/out and good potential for a trend move, or lower than average indicating the locals might spend the day playing with stops and we have a range sort of day. That’s the (simplified) theory, but the practical side of it is that volume varies depending on time of day so using a normal moving average calculation (take the last “x" periods, add them up, divide by “xâ€Â) will not give a reliable indication of what the average volume is for a particular time of day.

 

Better to take the volume for a certain period of time, say the 15 minutes between 8.30 and 8.45 am, and compare the volume during this period to the volume between 8.30 and 8.45 am for previous days. Maybe add up the volume for each of the 8.30 to 8.45 am time slots for the previous 20 days, and divide by 20 (20 is not carved on a stone tablet, use whatever number of periods suits; also this calculation is for a simple MA, could also use an exponential, weighted, or whatever suits). Do this for each 15 minute period during the trading session, and at a glance we can tell if the volume is above or below average for this time of day.

 

I suppose plenty of software packages will do this sort of thing, I know Ensign does it, but I don’t have Ensign. So what I did was get the volume data for each 15 minute period of the ES from 8.30 to 3.15 (Chicago time), put it in Excel (if you don’t have Excel, you could use the Open office spreadsheet software – free download) and did the calculations, this is what I came up with for the average volumes (simple MA) every 15 minutes using the data for the dates between Sep. 19 and Oct. 17, 2007 inclusive:

 

Chicago time: Average volume

(15 mins ending…) (no. of contracts traded)

8.45 86,985

9.00 74,498

9.15 83,731

9.30 64,551

9.45 67,687

10.00 56,384

10.15 57,069

10.30 52,050

10.45 47,209

11.00 36,678

11.15 31,807

11.30 24,842

11.45 25,120

12.00 22,855

12.15 28,098

12.30 35,421

12.45 39,401

1.00 36,565

1.15 49,971

1.30 51,979

1.45 52,430

2.00 47,979

2.15 60,035

2.30 58,578

2.45 58,518

3.00 79,956

3.15 67,798

 

 

 

I don’t know how often I will have to update these figures, if they change dramatically each day then there would not seem to be much point to them, but I doubt they do. I might update them each day for a couple of weeks and see if there are any big swings in values; if, as I expect, there is not, then I will probably update them once a week, or even extend the period out to 30, 40, or more, days – it’s a simple matter of just adding more data.

 

I have attached the spreadsheet I designed (ummm…. designed is too fancy a word for what I cobbled together) to do the calculations, for those who may find it useful.

 

Any thoughts, suggestions, modifications ?

 

es vol data.xls

Share this post


Link to post
Share on other sites

Interesting theory, before I code it I would like to hear something more about the idea.

 

As I understand you assume that the volume between 0830 and 0845 from the previous day should be compared with current day. Should a moving average then be calculated backwards 20 days between 0830 and 0845 and then be applied to current day 0830-0845? Same procedure follows with other times!

Share this post


Link to post
Share on other sites

I'm been thinking about adding something like this to what I watch but just for the opening range to try to watch out for trend days.

I think if you do it for the whole day, a broader view of things might have more utility because I'm not exactly sure what information you are gaining from knowing that the current volume from 10:45-11:00am is higher than some windowed average of prior days at that exact time.

Some good data points to me would be

8:30 - 9:30

8:30 - 10:00

8:30 - 11:00

 

After that to me your getting into a higher/lower overall volume day. If a genie looked into the future and told you monday would have higher/lower volume overall on the day than the average of the last 20 days...well I really don't see how that information would be of much use.

Share this post


Link to post
Share on other sites

hehe.. couldn't agree more, however people are watching those moving averages as an overall for n-bars back in time.

 

I thnink I understand now, but

8:30 - 9:30

8:30 - 10:00 <- shouldn't it be 0930-1000

8:30 - 11:00 <- and 1000-1100

 

I cannot understand why we should accumulate from 0830? Shouldn't each interval be compared with the same interval each day?... Ofcause it can be done your way, could be interesting to analyze.

 

We should also use 13-14, 14-15 and compare with current daytime ?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • NFLX Netflix stock, with a solid top of range breakout, from Stocks to Watch at https://stockconsultant.com/?NFLX  
    • NFLX Netflix stock, with a solid top of range breakout, from Stocks to Watch at https://stockconsultant.com/?NFLX  
    • It depends. If you have lots of money that you can buy a house without a loan and if you don't have any parents to sponsor then it is a good idea. Otherwise it might be a bad idea depending where in Canada you are heading to. I earned a good middle income in my home country and I migrated to Vancouver 5 years ago at the age of 35. I had to start right from the bottom, lowest of the low.. Now i am finally earning a middle income in Canada but I still cannot afford to buy a one bedroom apartment. Having left behind friends, family and home, most of the times I think it is not worth it.   In short, do not migrate if you already have a good life in your home country and you are happy. Only migrate to Canada if you really have to leave your home country say there is a war or something really bad. Discrimination still exists here and its really tough for newcomers unless you are super rich. Good luck. David Chong, Quora  
    • This is bigger than the internet. Bigger than mobile. Bigger than social media.   While everyone was distracted by stock market fluctuations and political theater…   Most people have NO IDEA what just happened last week with ChatGPT.   Their new memory feature allows ChatGPT to remember EVERYTHING about you across all your conversations.   Think about that for a minute...   While most tech companies have been collecting mere breadcrumbs about you - your likes, your clicks, your browsing history - OpenAI is now collecting the most valuable dataset in human history: your complete psychological profile.   This is Zuckerberg x 5,000.   The more you use ChatGPT, the more it understands you, becoming a supercharged reflection of yourself that improves at an exponential rate.   Are you a regular ChatGPT user?   Consider whether it’s time to turn off the “you can train on my information” feature. To prevent your data from being used for training while still using the memory feature:   Disable Model Training: Navigate to Settings > Data Controls. Toggle off "Improve the model for everyone". Manage Memory Settings: Go to Settings > Personalization > Memory. Here, you can: Turn off memory entirely. Delete specific memories. Use Temporary Chat for sessions that won't be saved or used for training. Now the investment implications…   Why This is Bigger Than You Think Consider this: the relationship between humans and ChatGPT is evolving beyond a mere tool.   People are now treating these AI assistants as friends, confidants, and even romantic partners.   I'm not making this up - there are already documented cases of people ending real human relationships to pursue “connections” with their AI companions.   A viral Instagram meme shows a person going through life with a glowing, featureless humanoid figure - representing ChatGPT - as their companion.   The post has over 1.1 million likes and comments like "Bro ChatGPT is like my best friend. Ain't even ashamed to say it" with 25,000 likes.   But here's where things get really interesting for investors and entrepreneurs...   Three Things to Watch For starters, hardware is the next big thing for the big players.   The iPhone form factor is dead.   It hasn't meaningfully changed in nearly a decade. The next evolution in hardware will be designed specifically to interface with these AI companions.   OpenAI is already working on hardware with Johnny Ive, the legendary designer behind the iPhone and iPod. But you can’t ignore Elon Musk’s edge here.   So what does all of this mean for you?   The companies that control the personal AI relationships will be worth trillions. OpenAI and Elon Musk will have the coziest moats. We're witnessing the birth of a new internet - one built on agents that can communicate with each other across platforms. Google's new agent-to-agent protocol allows AI agents to work together without sharing internal memories or tools. The hardware companies that create the perfect interface for these AI companions will dominate the next decade of technology. And almost nobody is talking about what this means.   My prediction? Within five years, most people will have a personal AI that knows them better than anyone else. And they will interact with it in ways that seem foreign today.   (And, yes, it will almost certainly have dystopian elements.)   In the meantime, the biggest gains won’t come from household names. And, right now, James is seeing a prime opportunity to invest in the most under-the-radar plays in AI…   For dirt cheap. By Chris C. Source: https://altucherconfidential.com/posts/use-chatgpt-protect-yourself-now
    • KBH KB Home stock, nice day and rally off the 50.82 support area, from Stocks to Watch at https://stockconsultant.com/?KBH      
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.