[smf_addin] Digest Number 4496

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4496

1a

Re: Date of last earnings Release - formula help by "Randy Harmelink" rharmelink

2a

Barchart not working by caleb.mullins25

2b

Re: Barchart not working by "Randy Harmelink" rharmelink

2c

Re: Barchart not working by caleb.mullins25

Messages

1a

Re: Date of last earnings Release - formula help

Tue Mar 5, 2019 9:39 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You pretty much need to examine the HTML source code of the web page to
determine what unique search terms exist around the data item you want to
extract.

On Tue, Mar 5, 2019 at 8:15 AM friedman_steve@... wrote:

>
> I wish I understood how you create that formula.... would love to learn
> the trick so don't have to bother you each time.
>
>
>

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

2a

Barchart not working

Tue Mar 5, 2019 11:39 pm (PST) . Posted by:

caleb.mullins25

Hi Randy,
I have been using this link (provided below) to grab values from barchart technical analysis page but today it is not working. Can you please help how can i pick different figures from that page.


RCHGETTABLECELL("https://www.barchart.com/stocks/quotes/AAPL/technical-analysis",-1,">MACD",,,,2)



In addition, i would like to know how to pick Key Turnings Points from https://www.barchart.com/stocks/quotes/AAPL/overview https://www.barchart.com/stocks/quotes/AAPL/overview and 177.75 -1.25% and from Price Performance chart. Thanks

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

2b

Re: Barchart not working

Wed Mar 6, 2019 1:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Your formula is working fine for me. Maybe Barchart was unavailable
temporarily?

The turning points are pretty simple. For example:

=RCHGETTABLECELL("https://www.barchart.com/stocks/quotes/AAPL/overview",1,">1st
Resistance Point")

Price Performance items:

=smfGetTagContent("https://www.barchart.com/stocks/quotes/AAPL/overview","span",3,">Price
Performance","1-Month",,,1)
=smfGetTagContent("https://www.barchart.com/stocks/quotes/AAPL/overview","span",4,">Price
Performance","1-Month",,,1)

On Wed, Mar 6, 2019 at 12:41 AM naeem_4tk@... wrote:

> I have been using this link (provided below) to grab values from barchart
> technical analysis page but today it is not working. Can you please help
> how can i pick different figures from that page.
>
> RCHGETTABLECELL("
> https://www.barchart.com/stocks/quotes/AAPL/technical-analysis
> ",-1,">MACD",,,,2)
>
> In addition, i would like to know how to pick Key Turnings Points from
> https://www.barchart.com/stocks/quotes/AAPL/overview and 177.75 -1.25% and
> from Price Performance chart. Thanks
>
>

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

2c

Re: Barchart not working

Wed Mar 6, 2019 6:54 am (PST) . Posted by:

caleb.mullins25

Hi Randy, Thanks for the reply. Unfortunately, i don't think that is the case as the problem persists for me. Everything was fine till yesterday what could have gone wrong and what should i do?

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use