9 Messages
Digest #4067
Messages
Thu Jun 22, 2017 4:13 am (PDT) . Posted by:
philip_r_small
Hi Randy
I was using the application to track interest rate levels on a number of products. A recent web redesign is causing issues with this site: https://www.nsandi.com/direct-isa https://www.nsandi.com/direct-isa . I previously used the RCHGetTableCell function to get the interest rate of 0.75% but this no longer seems to work after they re-designed the site. Is there a better way to access it? I have had similar issues with other sites which have also gone through recent updates to their design. many thanks in advance.
Thu Jun 22, 2017 8:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.nsandi.com/direct-isa","em",-1,"tax-free/AER","tax-free/AER"),"~","
"))
On Thu, Jun 22, 2017 at 4:13 AM, Philip_R_Small@
...
wrote:
> I was using the application to track interest rate levels on a number of
> products. A recent web redesign is causing issues with this site:
> https://www.nsandi.com/direct-isa . I previously used the RCHGetTableCell
> function to get the interest rate of 0.75% but this no longer seems to work
> after they re-designed the site. Is there a better way to access it? I have
> had similar issues with other sites which have also gone through recent
> updates to their design. many thanks in advance.
>
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.nsandi.com/direct-isa","em",-1,"tax-free/AER","tax-free/AER"),"~","
"))
On Thu, Jun 22, 2017 at 4:13 AM, Philip_R_Small@
...
wrote:
> I was using the application to track interest rate levels on a number of
> products. A recent web redesign is causing issues with this site:
> https://www.nsandi.com/direct-isa . I previously used the RCHGetTableCell
> function to get the interest rate of 0.75% but this no longer seems to work
> after they re-designed the site. Is there a better way to access it? I have
> had similar issues with other sites which have also gone through recent
> updates to their design. many thanks in advance.
>
Thu Jun 22, 2017 8:36 am (PDT) . Posted by:
a.bereziuk
Hello,
Is there a function to see if a stock is listed in some Index? For example, I input a ticker and get the name of the index, e.g. S&P, etc. If no, is there a web site to see this info?
Is there a function to see if a stock is listed in some Index? For example, I input a ticker and get the name of the index, e.g. S&P, etc. If no, is there a web site to see this info?
Thu Jun 22, 2017 9:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Before the redesign, Yahoo used to have that data. I don't know of a source
now. The closest is probably FinViz, but I think they only list the major
indexes:
=smfGetTagContent("http://finviz.com/quote.ashx?t="&F7,"td",1,">Index",,,,1)
On Thu, Jun 22, 2017 at 6:29 AM, a.bereziuk@
...
wrote:
>
> Is there a function to see if a stock is listed in some Index? For
> example, I input a ticker and get the name of the index, e.g. S&P, etc. If
> no, is there a web site to see this info?
>
>
>
now. The closest is probably FinViz, but I think they only list the major
indexes:
=smfGetTagContent("http://finviz.com/quote.ashx?t="&F7,"
On Thu, Jun 22, 2017 at 6:29 AM, a.bereziuk@
...
wrote:
>
> Is there a function to see if a stock is listed in some Index? For
> example, I input a ticker and get the name of the index, e.g. S&P, etc. If
> no, is there a web site to see this info?
>
>
>
Thu Jun 22, 2017 11:46 am (PDT) . Posted by:
john_hoel
=RCHGetYahooQuotes(A104,"l1",,NOW())
Returns ERROR. This suddenly started happening about 10 minutes ago. Is there a problem with Yahoo?
I can use RCHGetTableCell to get historical quotes from Marketwatch so I know that the add-in is likely not the cause.
Returns ERROR. This suddenly started happening about 10 minutes ago. Is there a problem with Yahoo?
I can use RCHGetTableCell to get historical quotes from Marketwatch so I know that the add-in is likely not the cause.
Thu Jun 22, 2017 3:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Working here right now, so I'll assume it was a temporary glitch of Yahoo?
On Thu, Jun 22, 2017 at 11:46 AM, john@
...
wrote:
> =RCHGetYahooQuotes(A104,"l1",,NOW())
>
> Returns ERROR. This suddenly started happening about 10 minutes ago. Is
> there a problem with Yahoo?
>
> I can use RCHGetTableCell to get historical quotes from Marketwatch so I
> know that the add-in is likely not the cause.
>
On Thu, Jun 22, 2017 at 11:46 AM, john@
...
wrote:
> =RCHGetYahooQuotes(
>
> Returns ERROR. This suddenly started happening about 10 minutes ago. Is
> there a problem with Yahoo?
>
> I can use RCHGetTableCell to get historical quotes from Marketwatch so I
> know that the add-in is likely not the cause.
>
Thu Jun 22, 2017 5:02 pm (PDT) . Posted by:
john_hoel
Working now for me. Apparently temporary. This has happened before, sometime for extended times i.e. hours.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar