|
PureBytes Links
Trading Reference Links
|
Actually, I agree that Internet Macros is
expensive and requires a learning curve. The problem is that it DOES work,
whereas Excel’s Web Query does NOT appear to work. When I evaluated several web-scraping
tools, IM was the only one that worked most often. The others worked fine on simple,
static web pages, but failed badly on complex, dynamic web pages.
The reason that I don’t use it more is
that there are higher priorities for me – getting better data, better
sector/industry scans, etc. Actually, I’m trying NOT to use it because the downloaded
IM data has to be stored somewhere and then retrieved. That could be a bit of
a hassle. I’d rather use a data feed that provides the data natively. That
said…
If you decide you want to IM, I’ll try to
provide help.
Regards,
Dan.
From:
amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Tony Lei
Sent: Sunday, July 17, 2005 7:29
PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: RE: [amibroker] Re:
Script and Stockconsultant website
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
|
|