Rav's Office

Originally posted by Ravgnome ↑

Hi Jako,

Haha...yeah, did get a chuckle out of the Ravioli XJO opener...thank you.

Thanks for the update. Sounds like Gary is getting backed into a corner now, but good on him for trying.
I'm sure it would be hard to concentrate...remember though, that it's hard to help others if your in poor shape yourself, so
Trish's (and family) well-being is important as well.

Regarding the excel project, there's an old saying that 'sometimes your too close to the fire to feel the heat', and it's true,
so maybe stepping back can broaden our view point at times.
It's like when you forget where you left something... mainly due to spreading yourself to thin and trying to achieve too much.
Rome wasn't built in a day.

I do have some VSA/Wyckoff coding if it's of any use...??

Cheers.

Expand

Thanks for that Rav,

I think Gary is feeling guilty, I think he feels that he is being forced to 'give up' so to speak,
He hasn't looked me in the eye for a week.
Not good.......
.
.
It isn't the VSA/Wyckoff coding for individual bars, or muli bar combinations, that is causing me difficulties.
I want to illustrate via the indicator, the individual bars relationship with the most important support and resistance levels on the chart.
And coding for the important levels I want, and their interaction with price, and then coming up with a good way to illustrate it, is the main difficulty.
.
When I look at a chart, I first look for the breakout/breakdown levels that are nearest to the current price, and then where the widespread/high volume bars lie, as both will form the important levels I want to watch, especially when they are challenged by price.
My coding for these levels has been a bit messy and inconsistent so far, and then adding their relationship with the current price action has been even more problematic. I mean, I can sort of get it to work for one single level on its own, but when that level is penetrated or is overcome, it need it to then 'know' what the next level is, and then the one after that etc. etc. I think I will have to use a more advanced function than I am using right now, perhaps numbering the levels in the past, so I can call them forward again (numerically) if price is looking like challenging them again.

Perhaps what I want to do is a bridge too far (at least for my current knowledge of excel), and I should just do the analysis manually.

The overall idea was to scan the market, using the VSA/Wyckoff indicator.
And then examine the scan results manually, similar in a way to what we were doing last year with the breakout bars.

No huge hurry just yet, but hopefully I can get back to it again at some time.

cheers