Minggu, 26 Februari 2017

[smf_addin] Digest Number 3930

6 Messages

Digest #3930

Messages

Sun Feb 26, 2017 10:18 am (PST) . Posted by:

eclipsme

Hi. I am a bit new and trying to use RCHGetHTMLTable. Here is the command I am using:

=RCHGetHTMLTable( "https://finance.yahoo.com/portfolio/p_0/view/e", "MORE INFO",-1, "", 1



The table is my 'Real Time' tab of my portfolio page. Internet Explorer is logged in to my account biut I am not getting any data.


Any ideas?


Thanks!



Sun Feb 26, 2017 10:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("https://finance.yahoo.com/portfolio/p_0/view/e", "MORE
INFO",-2, "",1 )

The -2 doesn't make sense to me at this point, but it works for me.

On Sun, Feb 26, 2017 at 11:18 AM, harvey@
​...wrote:

>
> Hi. I am a bit new and trying to use RCHGetHTMLTable. Here is the command
> I am using:
>
> =RCHGetHTMLTable( "https://finance.yahoo.com/portfolio/p_0/view/e", "MORE
> INFO",-1, "", 1
>
> The table is my 'Real Time' tab of my portfolio page. Internet Explorer is
> logged in to my account biut I am not getting any data.
>
> Any ideas?
>
>

Sun Feb 26, 2017 11:23 am (PST) . Posted by:

eclipsme

I don't know where that '2' came from. This is my formula:
=RCHGetHTMLTable( "https://finance.yahoo.com/portfolio/p_0/view/e", "MORE INFO",-1, "", 1 )

It is working for you???

I am selecting a big swath of cells, just to make sure the range is big enough.
Insert the formula into the formula bar.
Press Ctrl-Enter
nothing, except if you highlight any of the cells you can see the formula in the formula bar.

Suggestions?

Thanks again!

Sun Feb 26, 2017 11:30 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Like I said, try it with -2 instead of -1.

On Sun, Feb 26, 2017 at 12:23 PM, harvey@
​...wrote:

>
> I don't know where that '2' came from. This is my formula:
> =RCHGetHTMLTable( "https://finance.yahoo.com/portfolio/p_0/view/e", "MORE
> INFO",-1, "", 1 )
>
> It is working for you???
>
> I am selecting a big swath of cells, just to make sure the range is big
> enough.
> Insert the formula into the formula bar.
> Press Ctrl-Enter
> nothing, except if you highlight any of the cells you can see the formula
> in the formula bar.
>
> Suggestions?
>
> Thanks again!
>

Sun Feb 26, 2017 11:37 am (PST) . Posted by:

eclipsme

Oh... I misunderstood. I see it now. I will look at the source code again. It almost looks like the column headers are in a different table.

Thanks for the help!

Sun Feb 26, 2017 11:49 am (PST) . Posted by:

eclipsme

seems to have something to do with the table header???

<table class="..." id="...">
<thead>
<th class='col-symbol col-datatype:string sortable' scope='col&#39; colspan='1'>SYMBOL</th><th class='col-name col-datatype:string sortable' scope='col&#39; colspan='1'>NAME</th><th class='col-price col-datatype:rational sortable' scope='col&#39; colspan='1'>PRICE</th><th class='col-fiftytwo_week_range col-datatype:rational|rational sortable' scope='col&#39; colspan='2'>52-WK RANGE</th><th class='col-market_cap col-datatype:rational sortable' scope='col&#39; colspan='1'>MKT CAP</th><th class='col-avg_daily_volume col-datatype:integer sortable' scope='col&#39; colspan='1'>AVG VOL</th><th class='col-eps col-datatype:rational sortable' scope='col&#39; colspan='1'>EPS</th><th class='col-pe_ratio col-datatype:rational sortable' scope='col&#39; colspan='1'>P/E</th><th class='col-dividend_yield col-datatype:rational sortable' scope='col&#39; colspan='1'>YIELD</th><th class='col-price_per_sales col-datatype:rational sortable' scope='col&#39; colspan='1'>PRICE/SALES</th><th class='col-ebitda col-datatype:rational sortable' scope='col&#39; colspan='1'>EBITDA</th>

<th class="col-delete col-datatype: col-last" scope="col" colspan="1"></th>

</thead>
<tbody>
<tr...><td...> ...
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.13

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)