Tom,
This is an interesting feature of Excel
that I wasn’t aware of. Also, I thought that
StockConsultant had some interesting features.
When I created a web query to download the
section to which Tony is referring, I got an error saying that there was an
error in the query. I tried requerying the data several times with the
same result. However…
When I tried the WebQuery against the IBD
Stock Checkup page, it worked fine. Also, I haven’t tried my
solution (Internet Macros) against the StockConsultant page. So, it may
have issues with StockConsultant also.
Is there a workaround? Special technique?
Regards,
Dan.
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of jessie10@xxxxxxxxxxxxx
Sent: Friday, July 15, 2005 3:07
AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Script
and Stockconsultant website
Hi Tony,
If you already have
excel, the New web query function in excel will download the data into a sheet
and you can automatically extract the data using lookup functions in the
program. This can be automated by using the macro function in
excel. This way you can build a large macro in excel to download data for
as many stocks as you wish. There is a limit on the number of lines of
code in one excel macro but this can be by passed by have a statement at the
end of the macro that tells it to go and run the next macro.
Tom, Charlotte North Carolina
>
> From: Tony Lei <yiupang91@xxxxxxxxx>
> Date: 2005/07/14 Thu PM 10:53:41 EDT
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Script and
Stockconsultant website
>
> Hi all,
>
> Is there a way to retrieve information from
the following website using a
> script? Any ideas you would like to suggest
as a start? Basically I would
> like to add the support and resistance areas
that have a rating of 8 - 10
> and apply it to my scanner.
>
> http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample&symbol=MEE&62695#ttop
>
> Scroll down to detailed chart.
>
> Thanks in advance and it is awesome that I
have met a group willing to help
> each other out
>
> Tony
> qitrader
>
>
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