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.
>
>
>
> _____
>
>
>
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