|
PureBytes Links
Trading Reference Links
|
Tony,
I think there are two separate issues - 1)how to retrieve data from
the website, and 2)how to load and use the data in AB.
Regarding issue 1, when I tried to download the the data you
specified below from StockConsultant into Excel (using a WebQuery),
the WebQuery failed. So...
Are you saying that you haven't been able to retrieve the data from
the WebSite (issue 1)? Or, are you saying that you've already been
able to get data to Excel from the WebSite, but can't get access to
it in AB (issue 2)?
It's a little unclear what you are asking for. Please clarify.
Regards,
Dan.
--- In amibroker@xxxxxxxxxxxxxxx, Tony Lei <yiupang91@xxxx> wrote:
> 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@xxxx> 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.
> >
> > ------------------------------
> >
> > *From:* amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx] *On
> > Behalf Of *jessie10@xxxx
> > *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@xxxx>
> > > 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 <http://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 <http://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<amibroker-
unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
> > ------------------------------
> >
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/DldnlA/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~->
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|