3 New Messages
Digest #2619
Messages
Tue May 14, 2013 3:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that the strings "Price" and "Symbol" are all over that
page, so you're going to find the first occurrence -- which is NOT a header
of the table you're trying to extract.
This appears to work here:
=RCHGetHTMLTable("http://www.ivolatility.com/view_favourites.j?smid=.2.6.2
",">Symbol</a>",-1,"",1)
Note that I've made the "Symbol" string unique, so that it *is* the one
from the header of the table.
On Tue, May 14, 2013 at 10:53 AM, bagzigingahouse <bagzigingahouse@gmail.com
> wrote:
> Ok, is there another way then to get it into excel? The entire table is
> displayed in the web page, so i guess it should be possible.
>
> I tried with
> =RCHGetHTMLTable("http://www.ivolatility.com/view_favourites.j?smid=.2.6.2
> ","Symbol",-1,"",1)
>
> But it is not starting from a good point in the page (there are more than
> one "symbol" string)
>
> Then i tried with
> =RCHGetHTMLTable("http://www.ivolatility.com/view_favourites.j?smid=.2.6.2
> ","Price",-1,"",1)
>
> but im just getting empty cells. Not sure if this also needs to be worked
> around with extract string like its possible for individual cells, but the
> table is too big to do it one by one symbol...
>
page, so you're going to find the first occurrence -- which is NOT a header
of the table you're trying to extract.
This appears to work here:
=RCHGetHTMLTable(
","
Note that I've made the "Symbol" string unique, so that it *is* the one
from the header of the table.
On Tue, May 14, 2013 at 10:53 AM, bagzigingahouse <bagzigingahouse@
> wrote:
> Ok, is there another way then to get it into excel? The entire table is
> displayed in the web page, so i guess it should be possible.
>
> I tried with
> =RCHGetHTMLTable(
> ","
>
> But it is not starting from a good point in the page (there are more than
> one "symbol" string)
>
> Then i tried with
> =RCHGetHTMLTable(
> ","
>
> but im just getting empty cells. Not sure if this also needs to be worked
> around with extract string like its possible for individual cells, but the
> table is too big to do it one by one symbol...
>
Wed May 15, 2013 1:06 am (PDT) . Posted by:
"bagzigingahouse" bagzigingahouse
That is exactly it! I tried again but i'm not getting anything on the file download. However, GetHTMLTable does the job!!! Im not sure how you made a Symbol unique, but i guess i wont bother you now that its working :)
Thanks a lot
Igor
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Ahhh. When I log in to iVolatility, your CSV file does work for me:
>
> =smfGetCSVFile("http://www.ivolatility.com/favourites.csv?fav_g=52182 ")
>
> Is this what you would expect to see for the first 5 rows and columns:
>
> SYMBOL Price Change 10D HV 30D HV 30D HV Hi/Low indicator AMPL 2.49 -0.06
> 0.434757 2.562499 0.935112 GBCI 19.03 0.200001 0.264004 0.239649 0.677104
> HBHC 28.44 -0.19 0.19139 0.348903 0.800074 ICLR 33.01 0.279999 0.132026
> 0.326215 0.861381 HTLD 13.87 -0.13 0.207675 0.189927 0.574161
>
> On Tue, May 14, 2013 at 5:18 AM, bagzigingahouse
> <bagzigingahouse@...>wrote:
>
> >
> > Here is the page, it requires login tho...
> >
> > http://www.ivolatility.com/view_favourites.j?smid=.2.6.2
> >
> > > On Tue, May 14, 2013 at 1:57 AM, bagzigingahouse
> > > <bagzigingahouse@>wrote:
> > >
> > > >
> > > > i am trying to get the csv file from ivolatility.com and im not sure
> > what
> > > > im doing wrong. Could you maybe check why is this not working?
> > > >
> > > > =smfGetCSVFile("http://www.ivolatility.com/favourites.csv?fav_g=52182
> > ")
> > > >
> > > > I know ivol is kind of special case, so if this cant be done, is there
> > a
> > > > way to get the entire table from them some other way?
> >
>
Thanks a lot
Igor
--- In smf_addin@yahoogrou
>
> Ahhh. When I log in to iVolatility, your CSV file does work for me:
>
> =smfGetCSVFile(
>
> Is this what you would expect to see for the first 5 rows and columns:
>
> SYMBOL Price Change 10D HV 30D HV 30D HV Hi/Low indicator AMPL 2.49 -0.06
> 0.434757 2.562499 0.935112 GBCI 19.03 0.200001 0.264004 0.239649 0.677104
> HBHC 28.44 -0.19 0.19139 0.348903 0.800074 ICLR 33.01 0.279999 0.132026
> 0.326215 0.861381 HTLD 13.87 -0.13 0.207675 0.189927 0.574161
>
> On Tue, May 14, 2013 at 5:18 AM, bagzigingahouse
> <bagzigingahouse
>
> >
> > Here is the page, it requires login tho...
> >
> > http://www.ivolatil
> >
> > > On Tue, May 14, 2013 at 1:57 AM, bagzigingahouse
> > > <bagzigingahouse
> > >
> > > >
> > > > i am trying to get the csv file from ivolatility.
> > what
> > > > im doing wrong. Could you maybe check why is this not working?
> > > >
> > > > =smfGetCSVFile(
> > ")
> > > >
> > > > I know ivol is kind of special case, so if this cant be done, is there
> > a
> > > > way to get the entire table from them some other way?
> >
>
Wed May 15, 2013 1:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I had to look at the source code of the web page to see if I could find
some HTML coding that was unique to the header of the table, or anything
that would identify the table.
I knew it would work, because I cycled through the tables and got it with
this:
=RCHGetHTMLTable("http://www.ivolatility.com/view_favourites.j?smid=.2.6.2
","",37,"",37)
...so it was the 37th table on the web page. Unfortunately, because simple
web page changes can alter how many tables are on the web page, that would
not be a reliable way to retrieve it. But I knew it was there and could be
extracted.
The smfGetCSVFile() function worked for me as soon as I logged in.
PS: I used the smfGetTagContent-Quick-Webpage-Examination.xls template to
explore a lot of things on the web page. For example, just going to the
first tab and having it show all the table on the web page was a big help.
On Wed, May 15, 2013 at 1:06 AM, bagzigingahouse
<bagzigingahouse@gmail.com >wrote:
> That is exactly it! I tried again but i'm not getting anything on the file
> download. However, GetHTMLTable does the job!!! Im not sure how you made a
> Symbol unique, but i guess i wont bother you now that its working :)
>
some HTML coding that was unique to the header of the table, or anything
that would identify the table.
I knew it would work, because I cycled through the tables and got it with
this:
=RCHGetHTMLTable(
","
...so it was the 37th table on the web page. Unfortunately, because simple
web page changes can alter how many tables are on the web page, that would
not be a reliable way to retrieve it. But I knew it was there and could be
extracted.
The smfGetCSVFile(
PS: I used the smfGetTagContent-
explore a lot of things on the web page. For example, just going to the
first tab and having it show all the table on the web page was a big help.
On Wed, May 15, 2013 at 1:06 AM, bagzigingahouse
<bagzigingahouse@
> That is exactly it! I tried again but i'm not getting anything on the file
> download. However, GetHTMLTable does the job!!! Im not sure how you made a
> Symbol unique, but i guess i wont bother you now that its working :)
>
Tidak ada komentar:
Posting Komentar