Tom,
Here’s the website link: http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample&symbol=MEE&62695#ttop.
MEE is the symbol. From Excel both Tony and I got an error trying
Webquery. Webquery worked fine when I tried it against
IBD.
My Internet Macros macro worked fine, but it’s
expensive and may be more than Tony wants to
spend.
My future plans include implementing something like
you suggest, but I planned to use Internet Macros. I’d be to work with
you on the project if only to see how to create a better, cheaper tool.
Also, I have built a prototype personal web page that
runs in my workstation IIS web server (Win XP Pro). The idea is
that you can use AB’s Profile functionality and call a personal webpage rather
than a external web page. The personal web page has multiple, dynamic
links with the currently selected symbol imbedded. Each link would be
for a different web source of data – IBD, MarketWatch, StockConsultant,
etc. Not useful for scans, but very useful speeding up final analysis of
stocks.
Regards,
Dan.
From:
amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of
jessie10@xxxxxxxxxxxxx
Sent: Sunday, July 17, 2005 5:23
AM
To:
amibroker@xxxxxxxxxxxxxxx
Subject: Re: RE: [amibroker] Re: Script
and Stockconsultant website
Hi Dan and Tony,
I though I responded to your
previous email but I am sorry but I did not see it in the thread. If you
would allow me to have the email address of the site you are downloading from
maybe I could help with the download and conversion in excel and building a
csv file.
I have been working with excel for
years and automate most of my functions using VBA through the macro
builder. I also have the ability to help build data files
automatically. I would be happy to combine/share these talents with
anyone who would assist in a team effort in build some AFL files that would
forcast the movement of stock prices and options.
Tom Charlotte, North
Carolina
>
>
From: "Dan Clark" <dan_public@xxxxxxxxxxx>
> Date: 2005/07/17 Sun AM 12:02:11
EDT
> To:
<amibroker@xxxxxxxxxxxxxxx>
> Subject: RE: [amibroker] Re: Script and
Stockconsultant website
>
>
Tony,
>
>
>
> I did a quick IM macro accessing
StockConsultant. First the good news…
I
> was able to access the site
and download the data. No errors or access
> violations. Here a string containing the
extract results from the
>
“Resistance Above” section that was saved to a file (the last line in
the
> code
below):
>
>
>
> "","+3.2% at 41.25 ± 0.7, type triple+, strength
8","+6.4% at 42.55 ± 0.72,
>
type triple, strength 10","+9.1% at 43.61 ± 0.74, type single,
strength
> 2","+13.7% at 45.46
± 0.77, type single, strength 5",""
>
>
>
>
Here’s the code I created:
>
> VERSION
BUILD=4250510
>
> TAB
T=1
>
> TAB
CLOSEALLOTHERS
>
>
URL
> GOTO=http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample&symbo
> l=MEE&62695#ttop
>
> SIZE X=1122 Y=871
>
> EXTRACT POS=3 TYPE=TITLE
ATTR=<FONT<SP>color=#b40000>*
>
> EXTRACT POS=3 TYPE=TXT
ATTR=<FONT<SP>color=#b40000>*
>
> EXTRACT POS=4 TYPE=TXT
ATTR=<FONT<SP>color=#b40000>*
>
> EXTRACT POS=5 TYPE=TXT
ATTR=<FONT<SP>color=#b40000>*
>
> EXTRACT POS=6 TYPE=TXT
ATTR=<FONT<SP>color=#b40000>*
>
> EXTRACT POS=3 TYPE=TITLE
ATTR=<FONT<SP>color=#0000b4>*
>
> 'Save the File
>
>
SAVEAS TYPE=EXTRACT FOLDER=*
FILE=StockConsultant_{{!NOW:yymmdd}}.csv
>
>
>
> Now
the bad news… This StockConsultant web page is pretty
dynamic. The
> contents
of the Resistance Above and Support Below sections change
radically
> from symbol to
symbol. Sometimes there is data, sometimes not. For
MEE,
> there were 4 lines in
the “Resistance Above” section and 5 lines in the
> Support Below section. For AEP, the Resistance
Above had NO lines and the
>
Support Below had seven lines. While I believe that IM can handle
this,
> I’m not quite sure how
I’d do it. It would take some research
and
> experimentation to handle
this issue.
>
>
>
> If you are still interested, you can purchase a copy
of the Pro or Scripting
>
version to check it out. They have a 30 day, no cost return policy, so
you
> could test out the
product further. Finally, if you Google the web,
you
> may be able to find a
discount coupon for these folks. After a bit of
> searching, I found and used a 30% discount coupon when
I purchased mine.
>
>
>
> Best of luck,
>
>
>
>
Dan.
>
>
>
>
>
>
>
> _____
>
>
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On
Behalf
> Of Tony
Lei
> Sent: Friday, July 15,
2005 3:00 PM
> To:
amibroker@xxxxxxxxxxxxxxx
>
Subject: Re: [amibroker] Re: Script and Stockconsultant
website
>
>
>
> Dan,
>
Do you think you can evaluate the Scripting software for me by
performing
> the following
before I make my purchase?
>
> Basically I just need to get
the Support and Resistance data from
> stockconsultant with a rating of 8 to 10. It
will not be worthwhile if i
>
purchased the software to later find out that it doesn't work for
that
> specific website.
>
> Thanks
>
>
tony
>
> On 7/15/05,
dan_public@xxxxxxxxxxx <dan_public@xxxxxxxxxxx
> <mailto:dan_public@xxxxxxxxxxx> >
wrote:
>
>
Tom,
>
>
>
> I'm sorry if I wasn't clear. That's the
tool that I'm using and referring
> to. I have the Scripting edition. Like any
development tool, it takes a
>
bit of getting used to. In general though, it works
great.
>
>
>
> Regards,
>
>
>
>
Dan.
>
> -------------- Original
message --------------
> Hi
Tony and Dan,
>
>
Without knowing what web page you are trying to retrieve data
from
> and what data you wish
to capture, then I can not address any issue of a
> work around. But if retrieving data from the
internet is important and then
> it needs to be saved to a file then excel can do
it.
>
>
I have also used a program called IOPUS Internet Marcos to
retrieve
> huge volumes of data
to .csv files
>
> Tom Charlotte North
Carolina
>
>
> >
> > From: "danclark_public"
< dan_public@xxxxxxxxxxx
>
<mailto:dan_public@xxxxxxxxxxx> >
> > Date: 2005/07/15 Fri PM 02:27:05
EDT
> > To:
amibroker@xxxxxxxxxxxxxxx <mailto:amibroker@xxxxxxxxxxxxxxx>
> > Subject: [amibroker]
Re: Script and Stockconsultant website
> >
>
>
>
>
>
>
Please note that this group is for discussion between users
only.
>
> To get support from
AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For
other support material please check also:
> http://www.amibroker.com/support.html
>
>
>
>
>
>
> Please note that this group is for discussion between
users only.
>
> To get support from
AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For
other support material please check also:
> http://www.amibroker.com/support.html
>
>
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
>
* Visit your group
"amibroker
> <http://groups.yahoo.com/group/amibroker>
" on the web.
>
>
* To unsubscribe from this group, send an email
to:
>
amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
<mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
>
* Your use of Yahoo! Groups is subject to the
Yahoo! Terms of Service
>
<http://docs.yahoo.com/info/terms/>
.
>
>
>
> _____
>
>
>
>
>
Please note that this group is for discussion between users
only.
>
> To get support from
AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For
other support material please check also:
> http://www.amibroker.com/support.html
>
>
>
>
>
>
> _____
>
>
YAHOO! GROUPS LINKS
>
>
>
> * Visit your group
"amibroker
> <http://groups.yahoo.com/group/amibroker>
" on the web.
>
>
* To unsubscribe from this group, send an email
to:
>
amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
<mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
>
* Your use of Yahoo! Groups is subject to the
Yahoo!
> <http://docs.yahoo.com/info/terms/>
Terms of Service.
>
>
>
> _____
>
>
>