Spydertrader's Jack Hershey Futures Trading Journal

Status
Not open for further replies.
Quote from EdgeHunter:

good to know...

also i am sure it is a pain to re create by hand the Volume / Volitility Potentials Sheet...

but i think we can do that with a cross tab query in MS Access which will take the last 20 days data that has been input into a table and display it as a summed and averaged matrix just as you have it now...

then i can give you the accessDB and query and you just export the days 5 minute bars into excel each day with a formula to get the high low difference and each volume reading and then copy paste that into the Vol/Vol table and run the cross tab query and you could have the sheet updated everyday or every week or whenever without a lot of work.. just take a few minutes...

cross tab queries are tricky so i use the words 'I Think'...

something to consider down the road...

cj...
More...

The work is minimal as I have template spreadsheets buried on various harddrives that I need to blow the dust off of. I'm pretty savvy with most things conding. The work required is minimal. My real problem is time which is usually negative for me. My weekends are busier then the work week and my days tend to begin (5 am) and end (1 am) on borrowed time. I throw up alot of posts kind of as an archive of crap I fully intend to complete. I am also extremely savvy with MSAccess and all sorts of db SQL/PLSQL programming. I like to be able to simplify things to minimal effort. For example, there is yet another program I use called xlq by qmatix. I have ZERO affiliation with the guy but he's got excel app that interfaces with IQFEED/IB/Yahoo and other resources to stream realtime stuff. It can do alot for me because it leverages off the flexibility of excel. What I am trying to do is simply boil down the vol analysis to several inputs.

-an arbitrary number of days of data (ie. 60 days)
-an arbitrary fractal (ie. 5M)
-a practical time window (ie. 9:45 am to 3:30 pm)

Providing this template would allow any user to profile whatever it is that they trade. Tools like this cut out unnecesary technologies which others may or may not have and allow for users to adjust things to their hearts delight. It'll be up soon. There will be nothing magical about the template. It will just be versatile. There is a similar one for equities that calibrates to each instrument...
 
Quote from makosgu:

For example, there is yet another program I use called xlq by qmatix. I have ZERO affiliation with the guy but he's got excel app that interfaces with IQFEED/IB/Yahoo and other resources to stream realtime stuff.
More...

MAK,

FYI I have been using xlq since 2002 (when Leo offered lifetime licenses). It's a great app and I've built numerous Excel models based on the xlq formulas. Let me know if I can help out.
 
Attached, please see today's ES Chart. I have annotated a few extra FBO's combined with their respect FTT's on this chart, but tried to maintain the Forest Level View as I did yesterday.

Hope everyone had a great day.

- Spydertrader
 

Attachments

Quote from WGTrader:

MAK,

FYI I have been using xlq since 2002 (when Leo offered lifetime licenses). It's a great app and I've built numerous Excel models based on the xlq formulas. Let me know if I can help out.
More...

I love the app. I've had it for just as long also. Same type of license. :cool:
 
Quote from Bearbelly:

I did it!!! I made another trade when I was sitting on a nice profit from earlier. I have a terrible time pulling the trigger when Im sitting on a nice gain. I told myself that I am going to take the next point three or bounce off that RTL come hell or high water so I puckered up my ahole and pulled the trigger fully expecting it to reverse immediately on me but it did just what it was supposed to do. My best day in quite awhile. I hope this is the beginning of the end of this problem I have. Im just glad it worked because if it had failed I probably would have went right back in my shell again. I feel sorry for the 401k's but Im loving this volatility.
More...

Congrats, Bearbelly - way to go! I think it is very apparent by now to all who have been following along from the onset of the journal, that the real 'secret' for attaining the final plateau will be found in the mastery of self. We are being handed the tools for the mechanics of the trade (not to mention still only honing our forest skills primarily) - but each among us must find their own way on the psychic frontier of self-control and discipline. From where I sit, there will ALWAYS be something new to learn. But then, it can be hard to focus sometimes when feeling giddy - heheh.
 
Status
Not open for further replies.
Back
Top