|
PureBytes Links
Trading Reference Links
|
I am using the excel to gather data but how do I retrieve information
to AB. For example, this is the information I would like to
obtain:
| ![]() RESISTANCE ABOVE |
| +3.5% at 84.94 ± 1.7, type single, strength 1 |
|
|
|
| ![]() SUPPORT BELOW |
| -2.8% at 79.76 ± 1.6, type double, strength 10 |
| -9.5% at 74.28 ± 1.49, type triple, strength 10 |
| -14.7% at 69.98 ± 1.4, type triple+, strength 10 |
| -19.2% at 66.32 ± 1.33, type triple, strength 10 |
| -24.5% at 61.97 ± 1.24, type double, strength 9 |
Thanks
tony
On 7/15/05, Dan Clark <dan_public@xxxxxxxxxxx> wrote:
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.
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
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
|