|
PureBytes Links
Trading Reference Links
|
For
those of you who are interested in Point & Figure charting ... I have
created an application that will create charts in Excel 2000 (I am not sure if
it will work in other versions).
<SPAN
class=489404221-13112001>
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.
<SPAN
class=489404221-13112001>
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).
<SPAN
class=489404221-13112001>
To
draw trendlines on the chart, just right click to get a pop-up menu. A
couple of other shortcuts I should mention:
<SPAN
class=489404221-13112001>
<SPAN
class=489404221-13112001>CTRL-SHIFT-S will toggle the data sheets
visible/hidden
<SPAN
class=489404221-13112001>CTRL-SHIFT-T will toggle the minor grid line
visible/hidden
<SPAN
class=489404221-13112001>CTRL-SHIFT-C will toggle
the comments visible/hidden
<SPAN
class=489404221-13112001>
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:
<FONT face=Arial
color=#008000 size=2>
//Create object from VB Project
DLL
xlpnf=<FONT
size=2>CreateStaticObject<FONT
color=#000000>(<FONT
color=#ff00ff>"xlpnf.amibroker"<FONT
face=Arial size=2>);
q=xlpnf.ami2pnf(<FONT
size=2>Name(),<FONT
color=#0000ff>Day(),<FONT
color=#0000ff>Month(),<FONT
color=#0000ff>Year<FONT
color=#000000>(),High,Low,Close,V,<FONT
color=#ff00ff>16);
<FONT face=Arial color=#000000
size=2>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).
<IMG alt="" hspace=0
Attachment:
Description: "border=0>"
Attachment:
|