- #19,443
- Jun 14, 2015 5:32am Jun 14, 2015 5:32am
- Joined Nov 2012 | Status: Trader | 12,211 Posts
Globalists have to keep funding Ukraine army to sustain their plan, and thats where IMF comes in.
- #19,454
- Jun 17, 2015 12:16pm Jun 17, 2015 12:16pm
- Joined Dec 2013 | Status: Trader | 2,141 Posts
EU Volume from the swing down to the bottom = blue Volume from up from the bottom = red {image} to get this with Excel is a bit of pain Have generated two Pivot tables One for the data of the swing down The other for the data of the swing up Seems, there is no way to combine this two Pivot tables in order to get a stacked chart. Does anyone know a way to do this, without manually copying the data of the two Pivot-tables in a new table?
Blue-Red=X
If X<0, than it would show '-' -> 'buy' area
If X>0, than it would show '+' -> 'sell' area
f(z)=z2+c
- #19,455
- Jun 17, 2015 2:11pm Jun 17, 2015 2:11pm
- Joined Jun 2010 | Status: zero | 20,603 Posts
{quote} Maybe I don't understand it, but what if: Blue-Red=X If X<0, than it would show '-' -> 'buy' area If X>0, than it would show '+' -> 'sell' area
since we are dealing here with very much data sets (hundredthousands), the task was to avoid calculation by simple formulas, because it would slow down the processing remarkably. So the task was to use some integrated calculation methods within a pivot table. The problem here was, that you can not use stacked charts within a pivot table.
So I wrote some vba code, which copies the data of the two pivot tables in a new table and then creates the stacked chart.
That works well.
Interpretation of such a chart goes in this way: where is old volume, what did it.? What is new volume doing and where? Besides of that you can use it for the normal stuff like "no volume zones" and high volume zones, etc.
- #19,456
- Jun 17, 2015 2:56pm Jun 17, 2015 2:56pm
- Joined Dec 2013 | Status: Trader | 2,141 Posts
{quote} Hi Hathor, since we are dealing here with very much data sets (hundredthousands), the task was to avoid calculation by simple formulas, because it would slow down the processing remarkably. So the task was to use some integrated calculation methods within a pivot table. The problem here was, that you can not use stacked charts within a pivot table. So I wrote some vba code, which copies the data of the two pivot tables in a new table and then creates the stacked chart. That works well. Interpretation of such a chart goes in this way: where...
f(z)=z2+c
- #19,457
- Jun 18, 2015 4:32pm Jun 18, 2015 4:32pm
- Joined Jun 2011 | Status: the risk is the unknown | 2,182 Posts
8H chart... still the same..
- #19,459
- Jun 19, 2015 12:47pm Jun 19, 2015 12:47pm
- Joined Jun 2010 | Status: zero | 20,603 Posts
Ding dong, is Infinitus home? Just checking, thread been a bit quiet lately.
I am between a rock and a hard plate:
climbing
rowing
trading
vs.
working
Girlfriend
At the moment I try to scratch trading and working - so I would have all the fun together
