Selasa, 22 Agustus 2017

[smf_addin] Digest Number 4127

10 Messages

Digest #4127

Messages

Mon Aug 21, 2017 8:53 pm (PDT) . Posted by:

buckleca

Hi Randy,

https://web.tmxmoney.com/research.php?qm_symbol=bce:CA

This fails every time:

smfGetTagContent("https://web.tmxmoney.com/research.php?qm_symbol=bce:CA","tr",0,">consensus rating for")

This works sometimes (very slow):

smfGetTagContent("https://web.tmxmoney.com/research.php?qm_symbol=bce:CA","tr",0,">consensus rating for",,,,,,1)

This usually works (slow):

smfGetTagContent("https://web.tmxmoney.com/research.php?qm_symbol=bce:CA","tr",0,">consensus rating for",,,,,,2)

Any idea what's happening with the default always returning "ERROR"?



Thanks

Mon Aug 21, 2017 11:06 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The first would fail every time, because the data isn't within the source
code of the web page. They use an API to retrieve the data and build the
web page dynamically. Unfortunately, that API requires referral
authorization to get the data.

The other two are using the IE object to process the source code and build
the web page, which is why it is so slow. But after the web page is built,
the data is available within the source code of the built web page.

I don't use the IE object for any normal add-in processing, because those
options work differently for different versions of EXCEL and different
versions of IE. And, as you note, are much slower.

On Mon, Aug 21, 2017 at 8:53 PM, buckleca@
​...
wrote:

>
> https://web.tmxmoney.com/research.php?qm_symbol=bce:CA
>
> This fails every time:
>
> smfGetTagContent("https://web.tmxmoney.com/research.php?qm_symbol=bce:CA
> ","tr",0,">consensus rating for")
>
> This works sometimes (very slow):
>
> smfGetTagContent("https://web.tmxmoney.com/research.php?qm_symbol=bce:CA
> ","tr",0,">consensus rating for",,,,,,1)
>
> This usually works (slow):
>
> smfGetTagContent("https://web.tmxmoney.com/research.php?qm_symbol=bce:CA
> ","tr",0,">consensus rating for",,,,,,2)
>
> Any idea what's happening with the default always returning "ERROR"?
>
>
>

Tue Aug 22, 2017 11:27 am (PDT) . Posted by:

buckleca

Thanks for the explanation.

I could live with using the i/e option and it being very slow, however it only works now and then. Too bad.

It looks like many sites are making our lives more difficult!

I believe this is the source site and I'm assuming it's the same issue because none of the quote info is available via SMF function:

http://www.quotemedia.com/portal/quote?qm_symbol=MSFT http://www.quotemedia.com/portal/quote?qm_symbol=MSFT

Tue Aug 22, 2017 2:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. It was a quotemedia API that was being used. Probably the same one,
with the same authorization issues.

On Tue, Aug 22, 2017 at 11:27 AM, buckleca@
​...
wrote:

>
> Thanks for the explanation.
>
> I could live with using the i/e option and it being very slow, however it
> only works now and then. Too bad.
>
> It looks like many sites are making our lives more difficult!
>
> I believe this is the source site and I'm assuming it's the same issue
> because none of the quote info is available via SMF function:
>
> http://www.quotemedia.com/portal/quote?qm_symbol=MSFT
>
>
>

Tue Aug 22, 2017 8:06 am (PDT) . Posted by:

paulo_million

Is there any turnaroud in the formula so that, whith the current add-on, is able to work?

Tue Aug 22, 2017 10:17 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not easily, no. Sorry.

On Tue, Aug 22, 2017 at 8:06 AM, milliongoal@
​...
wrote:

>
> Is there any turnaroud in the formula so that, whith the current add-on,
> is able to work?
>

Tue Aug 22, 2017 2:04 pm (PDT) . Posted by:

lapub1

Hi Randy,






I am trying to download a table for daily and monthly closes since last earnings release using
=(RCHgetelementnumber(" ",1290) to retrieve the earnings release date,
and yhoohistoricalquote
1901;YhooHistoricalQuote; 5 days close since earnings


smfpricesbetween("~~~~~",DATE(=RCHGetElementNumber("~~~~~",1290)),DATE(=RCHGetElementNumber("~~~~~",1290))+5,"08")



Is there a formula that smf prices between will recognize a variable date from a different cell?


Thanks!




Tue Aug 22, 2017 3:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but if I remember correctly, a defined element cannot use an
RCHGetElementNumber() function that uses the "~~~~~" replacement.

Wouldn't it be easier to create the table using smfPricesByDates(), getting
them all at once instead of individually?

On Tue, Aug 22, 2017 at 2:04 PM, lapub1@
​...
wrote:

> I am trying to download a table for daily and monthly closes since last
> earnings release using
>
> =(RCHgetelementnumber(" ",1290) to retrieve the earnings release date,
>
> and yhoohistoricalquote
>
> 1901;YhooHistoricalQuote; 5 days close since earnings
>
> smfpricesbetween("~~~~~",DATE(=RCHGetElementNumber("~~~~~",1290)),DATE(=
> RCHGetElementNumber("~~~~~",1290))+5,"08")
>
> Is there a formula that smf prices between will recognize a variable date
> from a different cell?
>
>
>

Tue Aug 22, 2017 3:56 pm (PDT) . Posted by:

lapub1

I would like to pull all the dates at once instead of individually. and pair the date with close after 5 days, or close after 10 days etc.

However because each earnings date is different for each ticker I cant standardize a date, I have a list of 10 tickers each with 10 different dates. I can pull the previous earnings dates and then load that to a table, I was only curious if I can automate that process using a formula to call the prev. earnings date result.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.21

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)