6 New Messages
Digest #2884
3a
Re: I installed the SMF add in yesterday,,,,not working [2 Attachmen by d0c59d6d82cd1e8632aab23a655b26f4
Messages
Wed Dec 4, 2013 11:03 am (PST) . Posted by:
ronnyrode21
Hi everyone...I've been trying to figure out how to pull insider information off of finviz but I am stumped. For example:
On this page: http://finviz.com/quote.ashx?t=patr&ty=c&ta=1&p=d
Down at the bottom I am trying pull all of that insider information into my spreadsheet. Ive been trying multiple ways but cant seem to get it to work. Would anyone know how potentially I could accomplish this.
Thank you.
On this page: http://finviz.
Down at the bottom I am trying pull all of that insider information into my spreadsheet. Ive been trying multiple ways but cant seem to get it to work. Would anyone know how potentially I could accomplish this.
Thank you.
Wed Dec 4, 2013 3:42 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("http://finviz.com/quote.ashx?t=patr&ty=c&ta=1&p=d",">Insider
Trading",-1,"",1)
On Wed, Dec 4, 2013 at 12:03 PM, <ronnyrode21@yahoo.com> wrote:
>
> Hi everyone...I've been trying to figure out how to pull insider
> information off of finviz but I am stumped. For example:
>
> On this page: http://finviz.com/quote.ashx?t=patr&ty=c&ta=1&p=d
>
> Down at the bottom I am trying pull all of that insider information into
> my spreadsheet. Ive been trying multiple ways but cant seem to get it to
> work. Would anyone know how potentially I could accomplish this.
>
=RCHGetHTMLTable(
Trading"
On Wed, Dec 4, 2013 at 12:03 PM, <ronnyrode21@
>
> Hi everyone...I&#
> information off of finviz but I am stumped. For example:
>
> On this page: http://finviz.
>
> Down at the bottom I am trying pull all of that insider information into
> my spreadsheet. Ive been trying multiple ways but cant seem to get it to
> work. Would anyone know how potentially I could accomplish this.
>
Wed Dec 4, 2013 12:12 pm (PST) . Posted by:
gshell422
Randy,
The formula you previously provided for retrieving the current DOW quote has quit working,
=RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview http://finance.yahoo.com/marketupdate/overview",1,">Dow")
It now returns "Maturity";.
Do you have any suggestions?
Thanks
The formula you previously provided for retrieving the current DOW quote has quit working,
=RCHGetTableCell(
It now returns "Maturity"
Do you have any suggestions?
Thanks
Wed Dec 4, 2013 3:41 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sigh. More updates with Yahoo Finance web pages...try:
=smfConvertData(smfGetTagContent("
http://finance.yahoo.com/marketupdate/overview","span",-1,"_^dji"))
On Wed, Dec 4, 2013 at 1:12 PM, <gshell422@yahoo.com> wrote:
> The formula you previously provided for retrieving the current DOW quote
> has quit working,
>
> =RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview
> ",1,">Dow")
>
> It now returns "Maturity";.
>
> Do you have any suggestions?
>
=smfConvertData(
http://finance.
On Wed, Dec 4, 2013 at 1:12 PM, <gshell422@yahoo.
> The formula you previously provided for retrieving the current DOW quote
> has quit working,
>
> =RCHGetTableCell(
> ",1,"
>
> It now returns "Maturity"
>
> Do you have any suggestions?
>
Wed Dec 4, 2013 3:48 pm (PST) . Posted by:
gshell422
Randy,
Thanks, that works fine.
Thank you
Thanks, that works fine.
Thank you
Wed Dec 4, 2013 7:09 pm (PST) . Posted by:
d0c59d6d82cd1e8632aab23a655b26f4
Thank you very much， it is working now! I think it was MSN's problem, not the code.
Tidak ada komentar:
Posting Komentar