PureBytes Links
Trading Reference Links
|
<x-html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2722.2800" name=GENERATOR></HEAD>
<BODY bottomMargin=0 leftMargin=3 rightMargin=3 topMargin=0>
<DIV>I have not tried out any of these files, but they looked interesting. (and
are free) ( I have no connection with this site)</DIV>
<DIV> </DIV>
<DIV> <A
href="http://www.geocities.com/WallStreet/District/2148/Tools.html">http://www.geocities.com/WallStreet/District/2148/Tools.html</A></DIV>
<DIV> </DIV>
<DIV>
<P><B><FONT face=Arial,Helvetica size=+2>Reval: Keep Tabs on Your Portfolio
Privately</FONT></B>
<P>
<TABLE>
<TBODY>
<TR>
<TD>Reval lets you update the value of your portfolio as often as you
want, but unlike those "free" quote sites on the web, you don't have to
tell anyone what you own, or how much. Reval gets quotes on your stocks,
but all information about the size of your positions stays on your
computer. You can keep track of as many portfolios as you want, and
indexes too</TD></TR></TBODY></TABLE></P></DIV>
<P><B><FONT face=Arial,Helvetica size=+2>Option Sifter 2: Find the Strike &
Expiration You Want</FONT></B>
<P> Finding the right option can be such a pain. You have to
guess about the expiration month, and maybe the strike you want isn't available,
but you chew up all kinds of time looking. Option Sifter minimizes the pain. It
downloads entire options chains from CBOE, formats the download into neat
columns, and uses Excel's AutoFilter option to let you sift out the hundreds of
options you don't care about so you can find the one you want. The new version
lets you enter as many underlyings as you want, along with your filtering
criteria. You get a new workbook showing just the options you want, with each
underlying on its own worksheet. </P>
<P><B><FONT face=Arial,Helvetica size=+2>Retriever: Historical Quotes the Way
You Want</FONT></B>
<P> If you've got a web connection and Excel 97/98/2000, you
can get just the historical quotes you want for the stocks and dates you are
interested in, directly in a spreadsheet format. Enter up 1,000 stocks and
100 dates, and let Excel do the work of going to Yahoo, getting split- and
dividend-adjusted historical quotes (do you really care about the daily low or
the volume? Me neither), and putting them in a simple, easy to follow
format. No errors from retyping the data. No cutting and pasting to
get simple list of prices. It's so simple you'll wonder why no one has
done it before! Let Retriever do the work, so you can focus on the
analysis. </P>
<P><B><FONT face=Arial,Helvetica size=+2>Backtest Functions: Version 2.02 is
Here!</FONT></B>
<P><B><FONT face=Arial,Helvetica>The Quick, Slick Way to Calculate Returns on
Investment Strategies Using Excel</FONT></B>
<P> These functions help you calculate compounded growth
rates, Sharpe ratios, etc., without performing inscrutable gyrations on you
worksheets. <B>It's now an Excel 97/98 Add-In</B>. Very easy to
install, and you can now use use these functions from any workbook.
<P> I also added functions for measuring base rates.
<B>BaseRate </B>computes the percentage of the time an investment strategy beats
a benchmark, such as the S&P 500. <B>RollBaseRate</B> computes the base rate
with a multi-year holding period. <B>RollBaseRate</B> lets you choose almost any
period you want. You can easily compare the 5-year rolling base rate to
10-year rolling base rate.
<P> Other functions in the add-in include: <B>CAGR,
GrowthFactor, CAGRFromGrowth, Sharpe, Concat, </B>and
<B>Concata</B>.</P></BODY></HTML>
</x-html>
|