|
PureBytes Links
Trading Reference Links
|
You can get the download at www.xlpnf.com. I did not create a help file
because I was not sure if there would be enough interest. I created the
application for my own use and will be updating it frequently (I hope).
Although the spreadsheet and application DLL are only 200k, the download is
about 2.5 meg because of VB overhead.
The install will create a new startup folder with xlpnf.xls spreadsheet in
it. This spreadsheet will call the DLL file to begin the program. It
should be pretty self explanatory but if there are any questions please
email me directly so not to congest this list (sorry for the cross posting
by the way).
To draw trendlines on the chart, just right click to get a pop-up menu. A
couple of other shortcuts I should mention:
CTRL-SHIFT-S will toggle the data sheets visible/hidden
CTRL-SHIFT-T will toggle the minor grid line visible/hidden
CTRL-SHIFT-C will toggle the comments visible/hidden
You can get data using (currently) three data sources - Quotes Plus,
AmiBroker and Yahoo. Quotes Plus is by far the fastest interface. Yahoo is
dependent on your internet connection. AmiBroker is kind of slow (there has
been mention of a better interface). But a faster call can be made directly
from AFL:
//Create object from VB Project DLL
xlpnf=CreateStaticObject("xlpnf.amibroker");
q=xlpnf.ami2pnf(Name(),Day(),Month(),Year(),High,Low,Close,V,16);
Everything up to Volume ('V') will remain the same. 16 is months of data to
load. There are two optional parameters after months of data - Boxsize
(default to traditional boxsize) and Reversal (default=3).
------=_NextPart_001_005D_01C16C66.C12F6FA0
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001>For=20
those of you who are interested in Point & Figure charting ... I have=20
created an application that will create charts in Excel 2000 (I am not sure=
if=20
it will work in other versions).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D489404221-13112001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001>You=20
can get the download at <A href=3D"http://www.xlpnf.com";>www.xlpnf.com</A>.=
=20
I did not create a help file because I was not sure if there would be enoug=
h=20
interest. I created the application for my own use and will be updati=
ng it=20
frequently (I hope). Although the spreadsheet and application DLL are=
only=20
200k, the download is about 2.5 meg because of VB overhead.</SPAN></FONT></=
DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D489404221-13112001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001>The=20
install will create a new startup folder with xlpnf.xls spreadsheet in it.&=
nbsp;=20
This spreadsheet will call the DLL file to begin the program. It shou=
ld be=20
pretty self explanatory but if there are any questions please email me dire=
ctly=20
so not to congest this list (sorry for the cross posting by the=20
way).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D489404221-13112001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001>To=20
draw trendlines on the chart, just right click to get a pop-up menu. =
A=20
couple of other shortcuts I should mention:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D489404221-13112001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D489404221-13112001>CTRL-SHIFT-S will toggle the data sheets=20
visible/hidden</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001><SPAN=20
class=3D489404221-13112001>CTRL-SHIFT-T will toggle the minor grid line=20
visible/hidden</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001><SPAN=20
class=3D489404221-13112001><SPAN class=3D489404221-13112001>CTRL-SHIFT-C wi=
ll toggle=20
the comments visible/hidden</SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D489404221-13112001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D489404221-13=
112001>You=20
can get data using (currently) three data sources - Quotes Plus, AmiBroker =
and=20
Yahoo. Quotes Plus is by far the fastest interface. Yahoo is=20
dependent on your internet connection. AmiBroker is kind of slow (the=
re=20
has been mention of a better interface). But a faster call can be mad=
e=20
directly from AFL:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff><SPAN class=3D489404221-13112001><FONT face=3DAr=
ial=20
color=3D#008000 size=3D2>
<P>//Creat<SPAN class=3D489404221-13112001>e</SPAN> object from VB Project=
=20
DLL</P></FONT><FONT color=3D#000000>
<P><FONT face=3DArial size=3D2>xlpnf=3D</FONT></FONT><FONT face=3DArial><FO=
NT=20
size=3D2><FONT color=3D#0000ff>CreateStaticObject</FONT><FONT=20
color=3D#000000>(</FONT><FONT=20
color=3D#ff00ff>"xlpnf.amibroker"</FONT></FONT></FONT><FONT color=3D#000000=
><FONT=20
face=3DArial size=3D2>);</FONT></P>
<P><FONT face=3DArial size=3D2>q=3Dxlpnf.ami2pnf(</FONT></FONT><FONT face=
=3DArial><FONT=20
size=3D2><FONT color=3D#0000ff>Name</FONT><FONT color=3D#000000>(),</FONT><=
FONT=20
color=3D#0000ff>Day</FONT><FONT color=3D#000000>(),</FONT><FONT=20
color=3D#0000ff>Month</FONT><FONT color=3D#000000>(),</FONT><FONT=20
color=3D#0000ff>Year</FONT><FONT=20
color=3D#000000>(),<B>High</B>,<B>Low</B>,<B>Close</B>,<B>V</B>,</FONT><FON=
T=20
color=3D#ff00ff>16</FONT><FONT color=3D#000000>);</FONT></FONT></FONT></P>
<P><SPAN class=3D489404221-13112001><FONT face=3DArial color=3D#000000=20
size=3D2>Everything up to Volume ('V') will remain the same. 16 is mo=
nths of=20
data to load. There are two optional parameters after months of data =
-=20
Boxsize (default to traditional boxsize) and Reversal=20
(default=3D3).</FONT></SPAN></P></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><IMG alt=3D"" hspace=3D0=20
src=3D"cid:489404221@xxxx"; align=3Dbaseline border=3D0></FONT></DI=
V>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><IMG alt=3D"" hspace=3D0 src=3D"cid:489404221@xxxx"; align=3Db=
aseline=20
border=3D0></DIV></BODY></HTML>
------=_NextPart_001_005D_01C16C66.C12F6FA0--
Attachment:
Description: ""
|