Selasa, 13 Januari 2015

[smf_addin] Digest Number 3295[1 Attachment]

13 Messages

Digest #3295
2a
extract number by wongkayau
2b
Re: extract number by "Randy Harmelink" rharmelink
2c
3a
3b
Re: Where is SMF_addin? by "Randy Harmelink" rharmelink

Messages

Mon Jan 12, 2015 7:09 am (PST) . Posted by:

c.kung

Thanks Randy.

But it does not seem to work in my setup using TAB as delimiters. It returned all zero's.


May be I was doing something wrong.


Could you please try it on your setup to see if it works or not?


Thanks in Advance.




Mon Jan 12, 2015 7:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Here's what I get:

Series Search Results for JPM
Products for this underlying symbol are traded on:
AMEX
ARCA BATS BOX C2 CBOE GEM ISE MIAX NOBO NSDQ PHLX
Series/contract Strike Open Interest
ProductSymbol year Month Day Integer Dec C/P Call Put Position Limit
JPM 2015 1 9 46 0 C P 0 0 25000000 JPM 2015 1 9 47 0 C P 0 0 25000000
JPM 2015 1 9 48 0 C P 0 0 25000000 JPM 2015 1 9 49 0 C P 0 0
25000000 JPM 2015 1 9 50 0 C P 0 47 25000000 JPM 2015 1 9 52 0 C P
0 472 25000000 JPM 2015 1 9 53 0 C P 0 548 25000000 JPM 2015 1 9
53 500 C P 0 18 25000000 JPM 2015 1 9 54 0 C P 0 10 25000000 JPM
2015 1 9 54 500 C P 0 20 25000000 JPM 2015 1 9 55 0 C P 0 555 25000000
JPM 2015 1 9 55 500 C P 0 10 25000000 JPM 2015 1 9 56 0 C P 0 134
25000000
I've changed the ticker symbol to others, and they work the same.

On Mon, Jan 12, 2015 at 8:09 AM, c.kung@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks Randy.
>
> But it does not seem to work in my setup using TAB as delimiters. It
> returned all zero's.
>
> May be I was doing something wrong.
>
> Could you please try it on your setup to see if it works or not?
>
> Thanks in Advance.
>

Mon Jan 12, 2015 8:02 am (PST) . Posted by:

"Ching Yuan Kung" c.kung

Thanks again Randy.
I did a re-installation of the smf Add-in and this time it works.  It seems that I did not install it correctly the first time.
Now, the key question is how to retrieve multiple Symbols at a time using this method?
I can write some VBA code to do that, but, is there an easy way to do multiple symbol Open Interest retrieval just using the smfGetCSVFile function?  Or is there any other functions that can do the trick?
Thanks a lot.  You are the best !
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, January 12, 2015 10:16 AM
Subject: Re: [smf_addin] Getting Open Interests text download file from www.theocc.com

  Here's what I get:

| Series Search Results for JPM |   |   |   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |   |   |   |
| Products for this underlying symbol are traded on: |   |   |   |   |   |   |   |   |   |   |   |
| AMEX ARCA BATS BOX C2 CBOE GEM ISE MIAX NOBO NSDQ PHLX |   |   |   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |   |   |   |
|   |   | Series/contract |   | Strike |   |   | Open Interest |   |   |   |   |
| ProductSymbol | year | Month | Day | Integer | Dec | C/P | Call | Put | Position Limit |   |   |
| JPM |   | 2015 | 1 | 9 | 46 | 0 | C P | 0 | 0 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 47 | 0 | C P | 0 | 0 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 48 | 0 | C P | 0 | 0 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 49 | 0 | C P | 0 | 0 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 50 | 0 | C P | 0 | 47 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 52 | 0 | C P | 0 | 472 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 53 | 0 | C P | 0 | 548 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 53 | 500 | C P | 0 | 18 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 54 | 0 | C P | 0 | 10 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 54 | 500 | C P | 0 | 20 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 55 | 0 | C P | 0 | 555 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 55 | 500 | C P | 0 | 10 | 25000000 |   |
| JPM |   | 2015 | 1 | 9 | 56 | 0 | C P | 0 | 134 | 25000000 |   |

I've changed the ticker symbol to others, and they work the same.

On Mon, Jan 12, 2015 at 8:09 AM, c.kung@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Thanks Randy.
But it does not seem to work in my setup using TAB as delimiters.  It returned all zero's.
May be I was doing something wrong.
Could you please try it on your setup to see if it works or not?
Thanks in Advance.

#yiv9562388626 #yiv9562388626 -- #yiv9562388626ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9562388626 #yiv9562388626ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9562388626 #yiv9562388626ygrp-mkp #yiv9562388626hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9562388626 #yiv9562388626ygrp-mkp #yiv9562388626ads {margin-bottom:10px;}#yiv9562388626 #yiv9562388626ygrp-mkp .yiv9562388626ad {padding:0 0;}#yiv9562388626 #yiv9562388626ygrp-mkp .yiv9562388626ad p {margin:0;}#yiv9562388626 #yiv9562388626ygrp-mkp .yiv9562388626ad a {color:#0000ff;text-decoration:none;}#yiv9562388626 #yiv9562388626ygrp-sponsor #yiv9562388626ygrp-lc {font-family:Arial;}#yiv9562388626 #yiv9562388626ygrp-sponsor #yiv9562388626ygrp-lc #yiv9562388626hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9562388626 #yiv9562388626ygrp-sponsor #yiv9562388626ygrp-lc .yiv9562388626ad {margin-bottom:10px;padding:0 0;}#yiv9562388626 #yiv9562388626actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9562388626 #yiv9562388626activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9562388626 #yiv9562388626activity span {font-weight:700;}#yiv9562388626 #yiv9562388626activity span:first-child {text-transform:uppercase;}#yiv9562388626 #yiv9562388626activity span a {color:#5085b6;text-decoration:none;}#yiv9562388626 #yiv9562388626activity span span {color:#ff7900;}#yiv9562388626 #yiv9562388626activity span .yiv9562388626underline {text-decoration:underline;}#yiv9562388626 .yiv9562388626attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9562388626 .yiv9562388626attach div a {text-decoration:none;}#yiv9562388626 .yiv9562388626attach img {border:none;padding-right:5px;}#yiv9562388626 .yiv9562388626attach label {display:block;margin-bottom:5px;}#yiv9562388626 .yiv9562388626attach label a {text-decoration:none;}#yiv9562388626 blockquote {margin:0 0 0 4px;}#yiv9562388626 .yiv9562388626bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9562388626 .yiv9562388626bold a {text-decoration:none;}#yiv9562388626 dd.yiv9562388626last p a {font-family:Verdana;font-weight:700;}#yiv9562388626 dd.yiv9562388626last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9562388626 dd.yiv9562388626last p span.yiv9562388626yshortcuts {margin-right:0;}#yiv9562388626 div.yiv9562388626attach-table div div a {text-decoration:none;}#yiv9562388626 div.yiv9562388626attach-table {width:400px;}#yiv9562388626 div.yiv9562388626file-title a, #yiv9562388626 div.yiv9562388626file-title a:active, #yiv9562388626 div.yiv9562388626file-title a:hover, #yiv9562388626 div.yiv9562388626file-title a:visited {text-decoration:none;}#yiv9562388626 div.yiv9562388626photo-title a, #yiv9562388626 div.yiv9562388626photo-title a:active, #yiv9562388626 div.yiv9562388626photo-title a:hover, #yiv9562388626 div.yiv9562388626photo-title a:visited {text-decoration:none;}#yiv9562388626 div#yiv9562388626ygrp-mlmsg #yiv9562388626ygrp-msg p a span.yiv9562388626yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9562388626 .yiv9562388626green {color:#628c2a;}#yiv9562388626 .yiv9562388626MsoNormal {margin:0 0 0 0;}#yiv9562388626 o {font-size:0;}#yiv9562388626 #yiv9562388626photos div {float:left;width:72px;}#yiv9562388626 #yiv9562388626photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9562388626 #yiv9562388626photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9562388626 #yiv9562388626reco-category {font-size:77%;}#yiv9562388626 #yiv9562388626reco-desc {font-size:77%;}#yiv9562388626 .yiv9562388626replbq {margin:4px;}#yiv9562388626 #yiv9562388626ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9562388626 #yiv9562388626ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9562388626 #yiv9562388626ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9562388626 #yiv9562388626ygrp-mlmsg select, #yiv9562388626 input, #yiv9562388626 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9562388626 #yiv9562388626ygrp-mlmsg pre, #yiv9562388626 code {font:115% monospace;}#yiv9562388626 #yiv9562388626ygrp-mlmsg * {line-height:1.22em;}#yiv9562388626 #yiv9562388626ygrp-mlmsg #yiv9562388626logo {padding-bottom:10px;}#yiv9562388626 #yiv9562388626ygrp-msg p a {font-family:Verdana;}#yiv9562388626 #yiv9562388626ygrp-msg p#yiv9562388626attach-count span {color:#1E66AE;font-weight:700;}#yiv9562388626 #yiv9562388626ygrp-reco #yiv9562388626reco-head {color:#ff7900;font-weight:700;}#yiv9562388626 #yiv9562388626ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9562388626 #yiv9562388626ygrp-sponsor #yiv9562388626ov li a {font-size:130%;text-decoration:none;}#yiv9562388626 #yiv9562388626ygrp-sponsor #yiv9562388626ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9562388626 #yiv9562388626ygrp-sponsor #yiv9562388626ov ul {margin:0;padding:0 0 0 8px;}#yiv9562388626 #yiv9562388626ygrp-text {font-family:Georgia;}#yiv9562388626 #yiv9562388626ygrp-text p {margin:0 0 1em 0;}#yiv9562388626 #yiv9562388626ygrp-text tt {font-size:120%;}#yiv9562388626 #yiv9562388626ygrp-vital ul li:last-child {border-right:none !important;}#yiv9562388626

Mon Jan 12, 2015 8:15 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry. You'd need to get each file individually -- unless they provide a
single file with multiple ticker symbols on it?

On Mon, Jan 12, 2015 at 9:02 AM, Ching Yuan Kung c.kung@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> I did a re-installation of the smf Add-in and this time it works. It
> seems that I did not install it correctly the first time.
>
> Now, the key question is how to retrieve multiple Symbols at a time using
> this method?
>
> I can write some VBA code to do that, but, is there an easy way to do
> multiple symbol Open Interest retrieval just using the smfGetCSVFile
> function? Or is there any other functions that can do the trick?
>
>

Mon Jan 12, 2015 8:12 pm (PST) . Posted by:

"Ching Yuan Kung" c.kung

Okay.  Thanks Again.
I just wrote a VBA macro, which retrieves Open Interest files for multiple symbols (of course one at a time), and then open/parse all of the retrieved text files into a single Excel spreadsheet with a neat format. I did not use "smfGetCSVFile" function, because it can only do one symbol at a time.
Still got some clean-up to do, but the basic functionality is working fine.  With this huge amount of data, I just put all of these Open Interests for all of the symbols into a single Pivot Table, and it looks great, and I can play all kind of data analysis.
Thanks.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, January 12, 2015 11:08 AM
Subject: Re: [smf_addin] Getting Open Interests text download file from www.theocc.com

  Sorry. You'd need to get each file individually -- unless they provide a single file with multiple ticker symbols on it?

On Mon, Jan 12, 2015 at 9:02 AM, Ching Yuan Kung c.kung@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I did a re-installation of the smf Add-in and this time it works.  It seems that I did not install it correctly the first time.
Now, the key question is how to retrieve multiple Symbols at a time using this method?
I can write some VBA code to do that, but, is there an easy way to do multiple symbol Open Interest retrieval just using the smfGetCSVFile function?  Or is there any other functions that can do the trick?

#yiv4164194224 #yiv4164194224 -- #yiv4164194224ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4164194224 #yiv4164194224ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4164194224 #yiv4164194224ygrp-mkp #yiv4164194224hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4164194224 #yiv4164194224ygrp-mkp #yiv4164194224ads {margin-bottom:10px;}#yiv4164194224 #yiv4164194224ygrp-mkp .yiv4164194224ad {padding:0 0;}#yiv4164194224 #yiv4164194224ygrp-mkp .yiv4164194224ad p {margin:0;}#yiv4164194224 #yiv4164194224ygrp-mkp .yiv4164194224ad a {color:#0000ff;text-decoration:none;}#yiv4164194224 #yiv4164194224ygrp-sponsor #yiv4164194224ygrp-lc {font-family:Arial;}#yiv4164194224 #yiv4164194224ygrp-sponsor #yiv4164194224ygrp-lc #yiv4164194224hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4164194224 #yiv4164194224ygrp-sponsor #yiv4164194224ygrp-lc .yiv4164194224ad {margin-bottom:10px;padding:0 0;}#yiv4164194224 #yiv4164194224actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4164194224 #yiv4164194224activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4164194224 #yiv4164194224activity span {font-weight:700;}#yiv4164194224 #yiv4164194224activity span:first-child {text-transform:uppercase;}#yiv4164194224 #yiv4164194224activity span a {color:#5085b6;text-decoration:none;}#yiv4164194224 #yiv4164194224activity span span {color:#ff7900;}#yiv4164194224 #yiv4164194224activity span .yiv4164194224underline {text-decoration:underline;}#yiv4164194224 .yiv4164194224attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4164194224 .yiv4164194224attach div a {text-decoration:none;}#yiv4164194224 .yiv4164194224attach img {border:none;padding-right:5px;}#yiv4164194224 .yiv4164194224attach label {display:block;margin-bottom:5px;}#yiv4164194224 .yiv4164194224attach label a {text-decoration:none;}#yiv4164194224 blockquote {margin:0 0 0 4px;}#yiv4164194224 .yiv4164194224bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4164194224 .yiv4164194224bold a {text-decoration:none;}#yiv4164194224 dd.yiv4164194224last p a {font-family:Verdana;font-weight:700;}#yiv4164194224 dd.yiv4164194224last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4164194224 dd.yiv4164194224last p span.yiv4164194224yshortcuts {margin-right:0;}#yiv4164194224 div.yiv4164194224attach-table div div a {text-decoration:none;}#yiv4164194224 div.yiv4164194224attach-table {width:400px;}#yiv4164194224 div.yiv4164194224file-title a, #yiv4164194224 div.yiv4164194224file-title a:active, #yiv4164194224 div.yiv4164194224file-title a:hover, #yiv4164194224 div.yiv4164194224file-title a:visited {text-decoration:none;}#yiv4164194224 div.yiv4164194224photo-title a, #yiv4164194224 div.yiv4164194224photo-title a:active, #yiv4164194224 div.yiv4164194224photo-title a:hover, #yiv4164194224 div.yiv4164194224photo-title a:visited {text-decoration:none;}#yiv4164194224 div#yiv4164194224ygrp-mlmsg #yiv4164194224ygrp-msg p a span.yiv4164194224yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4164194224 .yiv4164194224green {color:#628c2a;}#yiv4164194224 .yiv4164194224MsoNormal {margin:0 0 0 0;}#yiv4164194224 o {font-size:0;}#yiv4164194224 #yiv4164194224photos div {float:left;width:72px;}#yiv4164194224 #yiv4164194224photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4164194224 #yiv4164194224photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4164194224 #yiv4164194224reco-category {font-size:77%;}#yiv4164194224 #yiv4164194224reco-desc {font-size:77%;}#yiv4164194224 .yiv4164194224replbq {margin:4px;}#yiv4164194224 #yiv4164194224ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4164194224 #yiv4164194224ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4164194224 #yiv4164194224ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4164194224 #yiv4164194224ygrp-mlmsg select, #yiv4164194224 input, #yiv4164194224 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4164194224 #yiv4164194224ygrp-mlmsg pre, #yiv4164194224 code {font:115% monospace;}#yiv4164194224 #yiv4164194224ygrp-mlmsg * {line-height:1.22em;}#yiv4164194224 #yiv4164194224ygrp-mlmsg #yiv4164194224logo {padding-bottom:10px;}#yiv4164194224 #yiv4164194224ygrp-msg p a {font-family:Verdana;}#yiv4164194224 #yiv4164194224ygrp-msg p#yiv4164194224attach-count span {color:#1E66AE;font-weight:700;}#yiv4164194224 #yiv4164194224ygrp-reco #yiv4164194224reco-head {color:#ff7900;font-weight:700;}#yiv4164194224 #yiv4164194224ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4164194224 #yiv4164194224ygrp-sponsor #yiv4164194224ov li a {font-size:130%;text-decoration:none;}#yiv4164194224 #yiv4164194224ygrp-sponsor #yiv4164194224ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4164194224 #yiv4164194224ygrp-sponsor #yiv4164194224ov ul {margin:0;padding:0 0 0 8px;}#yiv4164194224 #yiv4164194224ygrp-text {font-family:Georgia;}#yiv4164194224 #yiv4164194224ygrp-text p {margin:0 0 1em 0;}#yiv4164194224 #yiv4164194224ygrp-text tt {font-size:120%;}#yiv4164194224 #yiv4164194224ygrp-vital ul li:last-child {border-right:none !important;}#yiv4164194224

Mon Jan 12, 2015 7:27 am (PST) . Posted by:

wongkayau

Hi Randy,


Morning. A quick one.


I have smfGetTagContent to get a text mixed with number. For example, xwydfakjhljkhserlkhaer190.82. I want to get the last number "190.82". The number of digit of this number varies. Are there any way to do it?


Thank you so much.


Best regards,
L

Mon Jan 12, 2015 8:03 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Unless there's a pattern in the string you can use, you'll have to search
for the first numeric. Try something like:

=smfConvertData(MID(B3,MIN(FIND({1,2,3,4,5,6,7,8,9,0},B3&1234567890)),99))

On Mon, Jan 12, 2015 at 8:27 AM, wongkayau@... wrote:

> I have smfGetTagContent to get a text mixed with number. For example,
> xwydfakjhljkhserlkhaer190.82. I want to get the last number "190.82". The
> number of digit of this number varies. Are there any way to do it?
>

Mon Jan 12, 2015 8:08 am (PST) . Posted by:

wongkayau

HI Randy,


It works! You are always nice and helpful. Really appreciated.
Have a great day!


Cheers,
L

Mon Jan 12, 2015 12:22 pm (PST) . Posted by:

cparver

I have never had a problem finding SMF_addin .xla file before but now I cannot find it. It doesn't seem to be located in the "Files" group.

Help!

Chet


Mon Jan 12, 2015 12:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

As the "Read Me" file there, and the banner on the front of the group, and
the footer of each message from the group indicate, it's been moved to a
website:

http://ogres-crypt.com/SMF

On Mon, Jan 12, 2015 at 1:22 PM, cparver@... wrote:

>
> I have never had a problem finding SMF_addin .xla file before but now I
> cannot find it. It doesn't seem to be located in the "Files" group.
>

Mon Jan 12, 2015 2:41 pm (PST) . Posted by:

cparver

Thank you for the info.

Chet

Tue Jan 13, 2015 2:20 am (PST) . Posted by:

yvrflyguy

Wondering if anyone can tell me why I can extract all the individual table cell data from the following web page, but using the GetHTMLTable function only returns the first line of the table?


http://vixcentral.com/historical/?days=2 http://vixcentral.com/historical/?days=2



http://vixcentral.com/historical/?days=2 http://vixcentral.com/historical/?days=2 Date First Month F1 F2 F3 F4 F5 F6 F7 F8 F9 Contango 2/1 Contango 7/4 Con 7/4 div 3 2015-01-12 1 19.575 19.375 19.275 19.475 19.625 19.75 20.0 20.075 20.325 -1.02% 2.70% 0.90% 2015-01-09 1 18.625



View on vixcentral.com http://vixcentral.com/historical/?days=2
Preview by Yahoo




See SMF Quick Webpage Examination attached.


Thanks for any advice received, and thank-you to Randy for his efforts in supporting the SMF add-in. It is a great help.


Peter


Attachment(s) from
1 of 1 File(s)

Tue Jan 13, 2015 2:25 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's because they aren't coding the HTML tag to end each row of the table.
RCHGetHTMLTable() is just a simple HTML parser, and expects all HTML table
tags to be coded.

On Tue, Jan 13, 2015 at 2:11 AM, a330pete@... wrote:

> Wondering if anyone can tell me why I can extract all the individual
> table cell data from the following web page, but using the GetHTMLTable
> function only returns the first line of the table?
>
> http://vixcentral.com/historical/?days=2
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 03.09

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)