Quote from frenchfry:
Allright... here is where I am.. after posting my Excel file I noticed that somehow I need to be able to retrieve, among other things, the previous day volume.
Being no programmer and no Excel geek either this led me to a two days journey on the web looking for suitable sample Excel files, VBA codes, Macros, etc. But once I found them I also had to try to understand them. Very complex.
At the end I "waded" through Spydertrader's first Equity journal which I just finished and found some more bits and pieces. I will try to "put the pieces together" and see if now I have what I need to follow your instructions.
You mentioned "cumulative volume" for the DU calculation... what does that mean? The average of a specific period? All values of a period simply added together?
We can redo all of this so it works automatically.
2012 or 2013 will be the year when, finally the "pieces" get understood by platform providers.
cummulative may be hard to understnd and process.
In making money, their are price drivers.
the major direct price driver is volume.
Lets reason for a minute.
anyone can look at the market variables on any fractal.
Lets look.
we discover that the blue chips do not make any money. We see huge volume and a very stagnant price.
this stagnant "no money making" price is NOT where we want to be.
we look at the sweet spot for making money and we see leading and lagging of variables.
By understanding the daily variable activity, we can invent indicators that give us an advantage.
Many people on ET do not get this far.
Reason as to why price can make money for you. It is through price movement.
Long ago this ws explained in terms of price drivers. Dodd and Granville were famous for their original thinking. They articulated in papers and books how price drivers work. This is still true since human nature hasn't changed.
A stock's price doesn't change much if things are dull and routine.
People are the same. 90% of potential traders lose. Trader mining is a joke as proved on ET.
You can find out that when the price movement is dull there IS A CAUSE.
I fouind the CAUSE. I give it away to anyone.
Dry Up is the cause of no price movement.
It takes all day for the volume to accummulater to 0.25 of the 65 day average. This 0.25 comes from my knowledge and skills of the price driver Dodd and Granville wrote about.
Now, reason about how a price driver makes price move.
If 0.25 of the daily volume DOES NOT MAKE PRICE MOVE, WHAT DOES?
Also, if PRICE IS MOVING, WHAT STOPS IT FROM MOVING?
0.65 makes price start to move and less than 1.8 stops price from moving.
both of these factors along with 0.25 can be used on a class of stocks to make money under conditions where the Sharpe Ratio is over 60.
This is a powerful and unique application of a set of systematic price drivers.
As you see on the FRV column the values 0.22 and 0.26 occur within a 30 minute interval.
In coding and TA parlance this interval is called a SIGNAL from an INDICATOR.
I made a one pager o make use of these ideas.
A platform has a column named "unusual volume". to the provider and the programmer of the provider, they are noting "unusual volume" and they do NOT know anything about the value of "unsual volume".
I made "unusual volume" into a useful indicator by giving it three signals that follow an Ordr Of Events (OOE).
you have to be fifth grade or older to understand these concepts.
you double your capital 7 or 8 times a year using them properly.
You need a Universe.
Over the coming week you will find out how to go to a platform and make use of it to do this PVT trading.
I have a million vets and their families who need to be supplied with capital for living and paying for treatment where they live since there is no VA where they live. If they were to go to a VA they wouyld have room and baord costs to be near the VA. they have to have this income to pay these costs.