LearnN Stock Trading Spreadsheet for LibreOffice
and Excel (c)
Rob Hock 2024-2025
Thank you for supporting me and my
good programming and my bad trading. VERSION 2.x is ready for you
to download; All of my trades are there too. Only the RULES have
been changed to protect the innocent. For
LibreOffice: LearnN
v2.2 (263K) or more pie here... Excel: LearnN v2.33 (485K)
Here is
list of all version releases in .XLSM , .ODS , and .OTS:
| Ver. | Date | MS Office - Excel | LibreOffice | Template |
| 2.33 | 5/12/2025 | LearnN v2.33 (485K) |
|
|
| 2.32 | 5/01/2025 | LearnN v2.32 (485K) |
|
|
| 2.31 | 4/24/2025 | LearnN v2.31 (421K) |
|
|
| 2.3 | 4/19/2025 | LearnN v2.3 (427K) |
|
|
| 2.2 | 3/20/2025 | LearnN v2.2 (263K) | LearnN v2.2 | |
| 2.1 | 2/16/2025 | LearnN v2.1 (216K) | LearnN v2.1 | |
| 2.0 | 3/19/2024 | LearnN v2.0 (239K) | LearnN v2.0 | |
| 1.0 |
3/19/2024 | LearnN v1.0 (202K) | LearnN v1.0 | |
MAILING LIST:
Get on the mailing list. Just reach
out to me and I'll notify you anytime I update LearnN. Then
swing back here to DOWNLOAD... easy! Here is my electronic mail
address:
+ CHART EVERYTHING:
What is important to me is not
necessarily important to you. LearnN tracks the essentials and a
few non-essentials to make for a very robust journal IMHO. I was
born for scaling though, and so is LearnN. Easily add your
variables that are important to you! Go to column ZZ and beyond
if you like:
1. Add your variable to sheet
and see it archive with your trading history: STEP
by STEP
2. Create a new Plus (+) Chart
and see your new variable charted! STEP
by STEP
IMHO - SUGGESTIONS FOR SUCCESS:
While you wouldn't take
investment advice from someone living in a van down by the
river, you may find wisdom and insight in my battered P&L
and bloodshot eyes. Technical analysis versus fundamental
analysis: If you are going to slip, bettor to slip on grass
than doggy stuff. Populate your WL (watchlist) with jewels,
not fools. Start with the fundamentals and try to earn it. It
is trickle-down money whose movements in value we hope to
capture in our NET.
Or fake it: Get up early,
append yesterday's WL of movers with today's pre-market
stand-outs and eye-ball things for opportunity. Traders are
specifically looking for SETUPS.
Volume volume VOLUME: Trade
what is hot, groom your WL daily so your eyes water on only
the right plants (stonks). Micro and small caps have wilder
moves than larger caps. You will typically find me hanging
there, ..literally.
MY EXPERIENCE w/BROKERS:
Having your eggs in separate
baskets is wise. Although my methods for day-trading force
me to do exactly this (since I'm under the $25k), it is of
great benefit. There are walls between my monies that
prevent me from cheating and throwing everything at a trade.
Furthermore, using several brokers and their order-systems
actually gives me power and a singular defense against
"broker failure". (This is really something I've experienced
a few times!) Additionally, my strategy inherits new offense
by entering/exiting the market using various avenues instead
of only one. My own unpredictability can now be leveraged.
(It is a mean world out there.)
Robinhood
is the sole reason I was able to experience the joy of
day-trading, swing-trading, and investing in the stock
market. The domino to commission-free trading, Robinhood
made it possible for me, and perhaps a few others, to jump
in. In fact, putting a trade on has never been easier with
the advent of Steve Jobs' smartphone. Every broker has an
App to get you in and out of the action.The faster a broker
allows me to do this, the more money (POWER) I will have on
deposit with them. Here are my favorites:
Moomoo,
best app for trading... take notes guys: I never do anything
in here except put on a trade, take off a trade. It gives me
NO fuss. The tech behind curtains knew what I wanted and
used the fastest code/transport possible for my order.
Interface is key and I can punch the numbers, position my
size, get the trade in easiest and FASTEST hear!
TD-Ameritrade
(Charlie Schwab): Interfacing and maintenance of my
attack strategy takes no time here. App & Desktop, this
is my "TRADE WORK STATION". Put the charts up all around me
with every indicator I love and some I might program. It
will let me. Liking the alerts too!
Firstrade Securities
Inc.: Easy (KISS)
Fidelity.:
Investment & banking services that keep me LONG
If swinging, I highly
recommend using a broker that provides access to
pre-pre-market trading hours (1am - 4am PST). Only Moomoo and
Webull provide such access, that I know of. The added
liquidity that comes at 4am PST, when everyone else turns
their machines on, can yield opportunities (worth a mention).
PITFALLS TO PITY:
Manage your risk. Before
you get in, pick a STOP stupido! That is Spanish for
stupid-dough. If you don't know when to get out, you
probably won't (on time). This is a very fine line,
albeit knife's edge separating success and failure. Only
experience will teach you proper STOPPING for your
trading approach and capital preservation. The market is
hunting for dumb money and tepid traders who don't know
the value of anything.
1am PST (or 4am
if you live on Wall St): PRE-PRE-MARKET OPEN
trading starts, news is coming or could be coming.
Assume it is bad unless you know otherwise. BETTOR, be
in cash. This isn't the case of course and everyone
should ride this roller-coaster at least once (nah few
times... go ahead!).
6:30am PST:
MARKET OPEN: Are you getN the HANG of this? Timing is
everything and market 'BOUT to open. All the sellers
meet all the buyers. No one knows for sure. Ticket to
ride, black or red, 50/50, gambling's not for me. I buy
stonks before the OPEN only if they are "set-up".
Size your position...
yes... Position your size: Expect the unexpected and
adjust your size/risk going in depending upon your skill
and experience with the SETUP. Go in thirds or buy half
and re-evaluate the trade as it progresses.
In the trade? Watch
out and watch for OUT. Use your STOP order if you plan
on taking your eyes off the action. Plan for failure.
Protect your capital!
1pm PST:
MARKET CLOSED: Did you get out? Does your stock
typically trade in the extended hour session? Did you
want to sell tomorrow? Questions you should have asked
yourself long before now. Between you and me, this is
my favorite time to trade. Did I mention I like to
swing? Day-traders will dump their positions before
the close. I smell opportunity.
DAY-TRADING / SWING-TRADING:
Technical analysis
will help you take off and land your plane.
Fundamental analysis will tell you whether you want to
take that trip. Investing is good for the soul, in my
opinion. Sometimes, your bag is worth alot. Intra-day
swings offer opportunity to realize a bigger move or
fall into a deeper pit. Think or swim.
New day.. what is
moving up? What is moving down? What's the Buzz Jesus
Christ Superstar? Catalysts? Inflection points for
opportunity. The better our entry, the easier the
exit. Unlike flying, where the landing offers more
risk, trading is all about the take-off. If you get it
right, you are in FIRST CLASS!
Goal: be in profit
immediately! Know your SETUPS,
your opportunities for profit as learned through
technical analysis of current market conditions and
your companies of interest. Of course you will need
help here. Experience is your best teacher....
or search for "technical analysis for day trading"
to get started. Want to trade with pro DT's? Greatstockpix
CATALYSTS:
"MACD on the 2m" is
a great indicator when everyone is using it and a
terrible indicator when only you are. Instead, for a
buy opportunity, I would focus intently on price
& volume with level 2 and tape in hand. Your
moving averages are generally your guide rails to
landing and taking off. Some catalysts plus
reminders:
- NEWS
- HOF BUYING
AND/OR RED
TO GREEN (from open) - MOVING AVG
BREAK NOT - EVEN DOLLAR $ BREAK MAYBE
- HOD (HIGH OF DAY)
BREAK THE
KNOT - SELLERS FAIL
SO DOES
KALE - RESISTANCE
BREAK COOL - TECHNICAL SIGNAL
WhateveR - TAKE
PROFITS - PROTECT ENTRY
- STOP ON GREEN
- SELL THE
UNEXPECTED
& INFLECTION POINTS (GSP)
Inflection points are:
- PRE-MARKET HIGH
- OPENING PRICE
- HOD (high of day)
- FLAG BREAKS
- WHOLE NUMBERS $1/$5/$10 (pennystocks .10/.50/.01)
- SUPPORT/RESISTANCE (on longer time frames)
- WHAT PRICE WILL ATTRACT BUYERS?
- WHAT PRICE WILL SHORTS COVER?
- MOVING AVGS
- MACD crossovers
- VWAP or other technical signal
- rANDOM flag
TOOLS & TIME FRAMES:
You have to jump
in and get your feet wet to feel the action. Many
recommend paper-trading but this won't surface any
underlying personal problems. That's correct! You
are your worst enemy here and many people have
unhealthy relationships with money. This will
ultimately affect your trading and IMHO (in my
humble opinion) is a significant variable which
should be addressed early-on.
You'll need at
least one good broker for charts, level 2, and
ticker tape. TD-Ameritrade is a good choice. I'm
personally shy of the $25k to daytrade all day
long so I spread my capital across multiple
commission-free brokerages to increase my
opportunity to CLOSE positions the same-day. This
is key to beginners' success: taking your P&L
before the regular trading session ends.
Typically I am
charting exponential moving averages 8 day, 20
day, 60 day, plus the 200 simple moving. I like
RSI, MACD and enjoy TTM_Trend very much. 1 or 2
min. candles are my go-to but I have heard it said
that scalpers like 3min candles and VWAP.
Finviz has some great
screens and if you're hunting extended hours, I
like Market Chameleon.
MOVING OUR AVERAGES - $25K HERE WE COME:
Get
started, make some trades, Find YOUR edge
to profit and YOUR rules that maintain it. The
secret-sauce, well I spilled it. I linger here
only because I am a bad boy, rule-breaker.
THANK YOU!
LearnN
is both a great start and a great finish to your trade log.
That's not A.I., that is me repeating myself. Some of us like to
tinker while others like out-of-box appliances. LearnN is a
powerful TRADE JOURNAL that satisfies both types; It will save
you time, get you to market ORGANIZED and ready for OPPORTUNITIES
brewing; And for those who enjoy a good spreadsheet and love
programming, don't worry I set it up just right!
Us traders will find many tools
and "trusts" of information on our web but birds of feather
flock together comes to mind when
choosing a chat room. Some people are loners while others
benefit from a good room. GreatStockPix is the best for stock market
day-trading. In fact, Mike taught me everything I know!
My favorite trading
setup is the iPhone SE (2016) by a waterfall in the middle
of nowhere thanks to this wonderful age we live in and LTE one
bar will do it! Don't hesitate to contact me if you have any
questions. I like to SWING and yes I confess, I sold cheat sheets in High School Latin.
I feel bad.. Sorry.
"Price the volume eye the
book watch the tape stop at the market; Investing is good for
the soul." -Rob Hock, famous investor-gator
|
Happy Trading! |
LearnN™ |