[smf_addin] Digest Number 4434

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #4434

1a

SMF Down? by raiders8112

1b

Re: SMF Down? by "Randy Harmelink" rharmelink

1c

Re: SMF Down? by raiders8112

2a

Re: Getting Stock Quote from Investing.com by alankc_mok

2b

Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink

Messages

1a

SMF Down?

Tue Dec 4, 2018 8:01 am (PST) . Posted by:

raiders8112

Is anyone else having trouble retrieving quotes from Yahoo today through the SMF-Add In?

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

1b

Re: SMF Down?

Tue Dec 4, 2018 8:22 am (PST) . Posted by:

"Randy Harmelink" rharmelink

My smfGetYahooPortfolioView() workbook is working fine. What isn't working
for you?

On Tue, Dec 4, 2018 at 9:01 AM mike.russo@... wrote:

> Is anyone else having trouble retrieving quotes from Yahoo today through
> the SMF-Add In?
>
>
>

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

1c

Re: SMF Down?

Tue Dec 4, 2018 8:54 am (PST) . Posted by:

raiders8112

Seems to be ok now. I tried numerous times to update my quotes this morning and the cursor would just spin.

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

2a

Re: Getting Stock Quote from Investing.com

Tue Dec 4, 2018 8:19 pm (PST) . Posted by:

alankc_mok

Randy,

Thanks for your reply.

I also have other URL that I want to extract data. In case I want to apply the add-in, what should be the first step ?

Can you point me to any write up about downloading HTML table from scratch ?

Thanks

Alan

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

2b

Re: Getting Stock Quote from Investing.com

Wed Dec 5, 2018 12:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The only write-ups are the documentation for the functions.

In general:

-- RCHGetTableCell() for extraction of individual HTML table cells
-- RCHGetHTMLTable() for extraction of entire HTML tables (as long as they
are simply coded)
-- smfGetTagContent() for extraction from individual HTML paired tagged
-- RCHGetWebData() for specialized extractions

The details of each may require viewing the source code of the web page to
find unique search strings for the desired extraction.

On Tue, Dec 4, 2018 at 9:20 PM alankc_mok@... wrote:

>
> I also have other URL that I want to extract data. In case I want to apply
> the add-in, what should be the first step ?
>
> Can you point me to any write up about downloading HTML table from scratch
> ?
>
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use