Re: [amibroker] Re: Script and Stockconsultant website, AmiBroker Email List Archive

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@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/>. > > > > > > ------------------------------ > >

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

Investment management software Investment property software Investment software

Investment tracking software Return on investment software Stock investment software

YAHOO! GROUPS LINKS

Visit your group "amibroker" on the web.   To unsubscribe from this group, send an email to: amibroker-unsubscribe@xxxxxxxxxxxxxxx   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.