PureBytes Links
Trading Reference Links
|
Using the web link you provided (marketwatch), excel did gather the data.
tony
On 7/15/05, dan_public@xxxxxxxxxxx <dan_public@xxxxxxxxxxx
> wrote:
Tony,
Try this page:
See if you can download data.
Regards,
Dan.
-------------- Original message -------------- Hi, I get the following error message
"web query returned no data"
I think it relates to issue #1
tony
On 7/15/05, danclark_public <dan_public@xxxxxxxxxxx
> wrote:
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@x
...> 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/>. > > > > > > ------------------------------ > >
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
SPONSORED 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
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
---- LSpots keywords ?>
---- HM ADS ?>
YAHOO! GROUPS LINKS
|