[smf_addin] Digest Number 4630

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #4630

1a

Help with nasdaq.com codes by friedman_steve

1b

Re: Help with nasdaq.com codes by "Randy Harmelink" rharmelink

1c

Re: Help with nasdaq.com codes by friedman_steve

2.1

Re: Microsoft Excel security message by waterboy5555

3a

Re: When Yahoo Groups disappears....? by "Subu S" mail_to_subu

3b

Re: When Yahoo Groups disappears....? by "Randy Harmelink" rharmelink

Messages

1a

Help with nasdaq.com codes

Thu Oct 17, 2019 7:28 am (PDT) . Posted by:

friedman_steve

Randy,
it looks like nasdaq.com changed some of their website. Could you help me with excel formula to grab the following data items (i couldn't get it to work).


https://www.nasdaq.com/market-activity/stocks/hon/earnings https://www.nasdaq.com/market-activity/stocks/hon/earnings

1) Want to grab the first row of date reported column (so would be "07/18/19")
2) Want to grab the second row of date reported column (so would be "04/18/19")




Thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: Help with nasdaq.com codes

Thu Oct 17, 2019 10:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The data is no longer delivered in the source code of the web page. They
retrieve the data from an API and then dynamically build the web page. So
you'd need to extract the data from the JSON data that the API returns. Try:

=smfStrExtr(smfWord(RCHGetWebData("
https://api.nasdaq.com/api/company/HON/earnings-surprise
"),3,"dateReported"),":""","""")
=smfStrExtr(smfWord(RCHGetWebData("
https://api.nasdaq.com/api/company/HON/earnings-surprise
"),4,"dateReported"),":""","""")

On Thu, Oct 17, 2019 at 7:34 AM friedman_steve@... wrote:

> it looks like nasdaq.com changed some of their website. Could you help
> me with excel formula to grab the following data items (i couldn't get it
> to work).
>
> https://www.nasdaq.com/market-activity/stocks/hon/earnings
>
> 1) Want to grab the first row of date reported column (so would be
> "07/18/19")
>
> 2) Want to grab the second row of date reported column (so would be
> "04/18/19")
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1c

Re: Help with nasdaq.com codes

Thu Oct 17, 2019 11:26 am (PDT) . Posted by:

friedman_steve

Awesome, Thanks. It works.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2.1

Re: Microsoft Excel security message

Thu Oct 17, 2019 11:08 am (PDT) . Posted by:

waterboy5555

You can unblock access for individual files you know are safe. To do this:
Right-click the file, and choose Properties.
On the General tab, click Unblock.
Click OK.


Did the above to the XLA file and it worked. However, I think to make it clear for newbies like me, you need to go to the Add in File to find the unblock check box. I was going to the specific excel file that I was working on and could not find the unblock check box.

Reply to sender . Reply to group . Reply via Web Post . All Messages (50) . Top ^

3a

Re: When Yahoo Groups disappears....?

Fri Oct 18, 2019 12:45 am (PDT) . Posted by:

"Subu S" mail_to_subu

Dear Randy and all the seniors there
Good day !Could some one please give me the links to the Google group so that I subscribe to that
thanks in advanceregardsSubu    

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

3b

Re: When Yahoo Groups disappears....?

Fri Oct 18, 2019 2:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

https://groups.google.com/forum/#!forum/smf-addin

https://groups.io/g/smf-add-in

On Fri, Oct 18, 2019 at 12:47 AM Subu S mail_to_subu@
<mail_to_subu@yahoo.com>... wrote:

>
> Could some one please give me the links to the Google group so that I
> subscribe to that
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use