Trade Zone Using Spreadsheet Data

free & uncensored discussion arena for TheRumpledOne

Moderator: moderators

AceKingTrader
rank: <50 posts
rank: <50 posts
Posts: 4
Joined: Wed Dec 26, 2007 10:56 pm
Reputation: 0
Gender: None specified
Contact:

Trade Zone Using Spreadsheet Data

Postby AceKingTrader » Thu Dec 27, 2007 12:21 am

I was very excited to find this website!! I use trade zones as well, but my method of calculating is a little bit different. Nonetheless, I am excited to find that other traders use "zones" as well.

I do not have access to the high powered trading platforms, so I have to get by with more manual calculations. I download from Yahoo the historical data for a year into a spreadsheet. I then create two additional columns: High minus the Open, and Open minus the Low. I then can get a pretty good idea of resistance areas before a stock turns and goes in the other direction. If it breaks through that resistance "zone", then it usually continues in that direction. I find that if AAPL breaks above or below the Open plus or minus .41, then it will usually continue in that direction.

Again, I do just use a platform like Tradestation, I just use my broker supplied intraday chart data. Therefore, I have to manually calculate my "zones".

I would appreciate any feedback on the pros and cons of manually "eyeballing" a trade zone via a spreadsheet method.

Also, I enjoyed the interview on TraderInterviews.com. That is how I found this website.

Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.

User avatar
TheRumpledOne
rank: 10000+ posts
rank: 10000+ posts
Posts: 11415
Joined: Sun May 14, 2006 9:31 pm
Reputation: 45
Location: Oregon
Real name: Avery T. Horton, Jr.
Gender: None specified
Contact:

Postby TheRumpledOne » Thu Dec 27, 2007 5:14 am

Symbol , Last , %Chg , Vol , gt0.41 , (wk) , (-1wk) , (-2wk) , (-3wk) , (-4wk) , (-5wk) , (-6wk) , (-7wk) , (-8wk)
AAPL , 198.95 , 0.08 , 25124400 , 82 , 5 , 5 , 5 , 4 , 4 , 5 , 4 , 4 , 3




I ran a stockfetcher scan. These are the number of times AAPL runs over $.41 from open to high.

AAPL ran more than $.41 82 days out of the last 100.

AAPL ran more than $1.00 74 days out of the last 100.
IT'S NOT WHAT YOU TRADE, IT'S HOW YOU TRADE IT!

Please do NOT PM me with trading or coding questions, post them in a thread.

AceKingTrader
rank: <50 posts
rank: <50 posts
Posts: 4
Joined: Wed Dec 26, 2007 10:56 pm
Reputation: 0
Gender: None specified
Contact:

Postby AceKingTrader » Thu Dec 27, 2007 3:37 pm

82 out of 100 is not bad odds for Open plus or minus .41 on just "eyeballing" off of a spreadsheet. However, I may look into using Stockfetcher to do some of the work for me. :) :)

I live in the country where I am stuck with dial-up internet service.......very S L O W. Therefore, I cannot have a lot of applications running at one time because of my limited bandwidth. However, if DSL ever makes it out this way, I may look into using a platform like Tradestation.

User avatar
TheRumpledOne
rank: 10000+ posts
rank: 10000+ posts
Posts: 11415
Joined: Sun May 14, 2006 9:31 pm
Reputation: 45
Location: Oregon
Real name: Avery T. Horton, Jr.
Gender: None specified
Contact:

Postby TheRumpledOne » Thu Dec 27, 2007 7:54 pm

Just to www.stockfetcher.com and look for my filters. The TRO STAT SCANS in particular.

You can run them but the data will be a week old but for this type of analysis that's good enough.
IT'S NOT WHAT YOU TRADE, IT'S HOW YOU TRADE IT!



Please do NOT PM me with trading or coding questions, post them in a thread.

AceKingTrader
rank: <50 posts
rank: <50 posts
Posts: 4
Joined: Wed Dec 26, 2007 10:56 pm
Reputation: 0
Gender: None specified
Contact:

Postby AceKingTrader » Tue Jan 29, 2008 3:30 am

I wanted to add another thought concerning downloading historical data into a spreadsheet. I mentioned before that I add two more columns to the spreadsheet........Daily High minus Open, and Open minus Daily Low.

I sometimes will then sort the new columns I added from lowest to highest. If you know the total rows you downloaded, you can then figure what percent of the time the price goes through a range. For instance, if I download 300 rows and then sort lowest to highest, I can take 300 times any percent. For instance, 300 rows times .33 gives me row 99. I now know the stock doesn't go above or below the range found at row 99, 33 percent of the time. I hope this is helpful to those who don't use Stockfetcher.


AceKingTrader

http://acekingtrader.blogspot.com

Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.


Return to “TheRumpledOne”