[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[RT] Gen: Excel Files on the web



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>&nbsp;</DIV>
<DIV>&nbsp;<A 
href="http://www.geocities.com/WallStreet/District/2148/Tools.html";>http://www.geocities.com/WallStreet/District/2148/Tools.html</A></DIV>
<DIV>&nbsp;</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 &amp; 
Expiration You Want</FONT></B> 
<P>&nbsp;&nbsp;&nbsp; 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>&nbsp;&nbsp;&nbsp; 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.&nbsp; 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?&nbsp; Me neither), and putting them in a simple, easy to follow 
format.&nbsp; No errors from retyping the data.&nbsp; No cutting and pasting to 
get simple list of prices.&nbsp; It's so simple you'll wonder why no one has 
done it before!&nbsp; 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>&nbsp;&nbsp;&nbsp; These functions help you calculate compounded growth 
rates, Sharpe ratios, etc., without performing inscrutable gyrations on you 
worksheets.&nbsp; <B>It's now an Excel 97/98 Add-In</B>.&nbsp; Very easy to 
install, and you can now use use these functions from any workbook. 
<P>&nbsp;&nbsp;&nbsp; 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&amp;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.&nbsp; You can easily compare the 5-year rolling base rate to 
10-year rolling base rate. 
<P>&nbsp;&nbsp;&nbsp; Other functions in the add-in include: <B>CAGR, 
GrowthFactor, CAGRFromGrowth, Sharpe, Concat, </B>and 
<B>Concata</B>.</P></BODY></HTML>

</x-html>