|
PureBytes Links
Trading Reference Links
|
Jessie,
My scanner retrieves about 5-10 stocks per day as potential swing
trades both long and short. From those 5-10 stocks, I would like
to retrieve those important support and resistance values to further
analyze the stocks that we'll be in play for the next day or so.
Basically I want to output those numbers in the "exploration" scan and
compared them with the closing price. For example, closing price
($40) is approaching Support at ($39 with a rating of 10) I can
tell AB when that difference is <= to $1 (getting close to support)
and color the box in "purple"
In respond to question 1, stockconsultant is the only signal to be
downloaded. Q2, I don't have a problem creating the .csv file but
just that web query function does not work. I might be due to
security reasons. Q3, I want to use the numbers in my exploration
scan.
As an example, I have attached a screenshot of the scan results.
If you look at the column labed 20, 50, 200ema, you will see that some
are colored in purple and others are not. When they are colored,
it means that the setup is approaching major support or resistance
areas. This is what I would like to do with the stockconsultant
site. I would like to retrieve those numbers and compare them in
my exploration scan.
thanks,
tony
qitrader
ps: you will only be able to see the image if you set the membership to allow "emails"
On 7/17/05, jessie10@xxxxxxxxxxxxx <jessie10@xxxxxxxxxxxxx> wrote:
Hi everyone,
The excel program has a little problem accessing <http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample&symbol=ME
> E&62695#ttop> &symbol=MEE&62695#ttop. It must be due to their security.
Question one, is this the only signal that is
to be downloaded. Question two, is the major problem making a
.CSV file. Question three, does the .csv file need to have
numbers put into columns or is it filed with a string variable to be
used as a commentary. The file that was shown on one of the posts
contained strings and did not separate the values out for
calculations. If there are only a few symbols they can be
manually copied and pasted to excel and then the rest can be automated
to save time and money!
Unless there is a need to download
large amounts of data from the internet using the IOPUS Internet Macros
program is a waste of several hundred dollars and many hours of
learning how to use it.
Tom from Charlotte, North Carolina
>
> From: "Dan Clark" <dan_public@xxxxxxxxxxx>
> Date: 2005/07/17 Sun AM 09:46:48 EDT
> To: <amibroker@xxxxxxxxxxxxxxx>
> Subject: RE: RE: [amibroker] Re: Script and Stockconsultant website
>
> Tom,
>
>
>
> Here's the website link:
> http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample
> <http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample&symbol=ME
> E&62695#ttop> &symbol=MEE&62695#ttop. MEE is the symbol. From Excel both
> Tony and I got an error trying Webquery. Webquery worked fine when I tried
> it against IBD.
>
>
>
> My Internet Macros macro worked fine, but it's expensive and may be more
> than Tony wants to spend.
>
>
>
> My future plans include implementing something like you suggest, but I
> planned to use Internet Macros. I'd be to work with you on the project if
> only to see how to create a better, cheaper tool.
>
>
>
> Also, I have built a prototype personal web page that runs in my workstation
> IIS web server (Win XP Pro). The idea is that you can use AB's Profile
> functionality and call a personal webpage rather than a external web page.
> The personal web page has multiple, dynamic links with the currently
> selected symbol imbedded. Each link would be for a different web source of
> data – IBD, MarketWatch, StockConsultant, etc. Not useful for scans, but
> very useful speeding up final analysis of stocks.
>
>
>
> Regards,
>
>
>
> Dan.
>
>
>
>
>
> _____
>
> From: amibroker@xxxxxxxxxxxxxxx [mailto:
amibroker@xxxxxxxxxxxxxxx] On Behalf
> Of jessie10@xxxxxxxxxxxxx
> Sent: Sunday, July 17, 2005 5:23 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: Re: RE: [amibroker] Re: Script and Stockconsultant website
>
>
>
> Hi Dan and Tony,
>
> I though I responded to your previous email but I am sorry but I did
> not see it in the thread. If you would allow me to have the email address
> of the site you are downloading from maybe I could help with the download
> and conversion in excel and building a csv file.
>
> I have been working with excel for years and automate most of my
> functions using VBA through the macro builder. I also have the ability to
> help build data files automatically. I would be happy to combine/share
> these talents with anyone who would assist in a team effort in build some
> AFL files that would forcast the movement of stock prices and options.
>
> Tom Charlotte, North Carolina
>
> >
> > From: "Dan Clark" <dan_public@xxxxxxxxxxx>
> > Date: 2005/07/17 Sun AM 12:02:11 EDT
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Subject: RE: [amibroker] Re: Script and Stockconsultant website
> >
> > Tony,
> >
> >
> >
> > I did a quick IM macro accessing StockConsultant. First the good news…
> I
> > was able to access the site and download the data. No errors or access
> > violations. Here a string containing the extract results from the
> > "Resistance Above" section that was saved to a file (the last line in the
> > code below):
> >
> >
> >
> > "","+3.2% at 41.25 ± 0.7, type triple+, strength 8","+6.4% at 42.55 ±
> 0.72,
> > type triple, strength 10","+9.1% at 43.61 ± 0.74, type single, strength
> > 2","+13.7% at 45.46 ± 0.77, type single, strength 5",""
> >
> >
> >
> > Here's the code I created:
> >
> > VERSION BUILD=4250510
> >
> > TAB T=1
> >
> > TAB CLOSEALLOTHERS
> >
> > URL
> > GOTO=http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample
> <http://www.stockconsultant.com/consultnow/basicplus.cgi?ID=sample&symbo
>
> &symbo
> > l=MEE&62695#ttop
> >
> > SIZE X=1122 Y=871
> >
> > EXTRACT POS=3 TYPE=TITLE ATTR=<FONT<SP>color=#b40000>*
> >
> > EXTRACT POS=3 TYPE=TXT ATTR=<FONT<SP>color=#b40000>*
> >
> > EXTRACT POS=4 TYPE=TXT ATTR=<FONT<SP>color=#b40000>*
> >
> > EXTRACT POS=5 TYPE=TXT ATTR=<FONT<SP>color=#b40000>*
> >
> > EXTRACT POS=6 TYPE=TXT ATTR=<FONT<SP>color=#b40000>*
> >
> > EXTRACT POS=3 TYPE=TITLE ATTR=<FONT<SP>color=#0000b4>*
> >
> > 'Save the File
> >
> > SAVEAS TYPE=EXTRACT FOLDER=* FILE=StockConsultant_{{!NOW:yymmdd}}.csv
> >
> >
> >
> > Now the bad news… This StockConsultant web page is pretty dynamic. The
> > contents of the Resistance Above and Support Below sections change
> radically
> > from symbol to symbol. Sometimes there is data, sometimes not. For MEE,
> > there were 4 lines in the "Resistance Above" section and 5 lines in the
> > Support Below section. For AEP, the Resistance Above had NO lines and the
> > Support Below had seven lines. While I believe that IM can handle this,
> > I'm not quite sure how I'd do it. It would take some research and
> > experimentation to handle this issue.
> >
> >
> >
> > If you are still interested, you can purchase a copy of the Pro or
> Scripting
> > version to check it out. They have a 30 day, no cost return policy, so
> you
> > could test out the product further. Finally, if you Google the web, you
> > may be able to find a discount coupon for these folks. After a bit of
> > searching, I found and used a 30% discount coupon when I purchased mine.
> >
> >
> >
> > Best of luck,
> >
> >
> >
> > Dan.
> >
> >
> >
> >
> >
> >
> >
> > _____
> >
> > From: amibroker@xxxxxxxxxxxxxxx [mailto:
amibroker@xxxxxxxxxxxxxxx] On
> Behalf
> > Of Tony Lei
> > Sent: Friday, July 15, 2005 3:00 PM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: Re: [amibroker] Re: Script and Stockconsultant website
> >
> >
> >
> > Dan,
> > Do you think you can evaluate the Scripting software for me by performing
> > the following before I make my purchase?
> >
> > Basically I just need to get the Support and Resistance data from
> > stockconsultant with a rating of 8 to 10. It will not be worthwhile if i
> > purchased the software to later find out that it doesn't work for that
> > specific website.
> >
> > Thanks
> >
> > tony
> >
> > On 7/15/05, dan_public@xxxxxxxxxxx <
dan_public@xxxxxxxxxxx
> > <mailto:dan_public@xxxxxxxxxxx> > wrote:
> >
> > Tom,
> >
> >
> >
> > I'm sorry if I wasn't clear. That's the tool that I'm using and
> referring
> > to. I have the Scripting edition. Like any development tool, it takes a
> > bit of getting used to. In general though, it works great.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Dan.
> >
> > -------------- Original message --------------
> > Hi Tony and Dan,
> >
> > Without knowing what web page you are trying to retrieve data
> from
> > and what data you wish to capture, then I can not address any issue of a
> > work around. But if retrieving data from the internet is important and
> then
> > it needs to be saved to a file then excel can do it.
> >
> > I have also used a program called IOPUS Internet Marcos to
> retrieve
> > huge volumes of data to .csv files
> >
> > Tom Charlotte North Carolina
> >
> >
> > >
> > > From: "danclark_public" < dan_public@xxxxxxxxxxx
> > <mailto:dan_public@xxxxxxxxxxx> >
> > > Date: 2005/07/15 Fri PM 02:27:05 EDT
> > > To: amibroker@xxxxxxxxxxxxxxx <mailto:
amibroker@xxxxxxxxxxxxxxx>
> > > Subject: [amibroker] Re: Script and Stockconsultant website
> > >
> > >
> >
> >
> >
> > 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
> >
> >
> >
> > * 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
> > <mailto: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
> >
> >
> >
> >
> >
> >
> > _____
> >
> > 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
> > <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo!
> > <http://docs.yahoo.com/info/terms/> Terms of Service.
> >
> >
> >
> > _____
> >
> >
> >
>
>
>
> 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
>
>
>
> * 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
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> _____
>
>
>
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
Attachment:
scan.jpg
Description: JPEG image
|
