Minggu, 20 November 2016

[smf_addin] Digest Number 3847

8 Messages

Digest #3847

Messages

Sat Nov 19, 2016 6:51 am (PST) . Posted by:

"Jose Jacob" pepecan47

Randy, these are the Morningstar pages I see bond info:

http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=ALA&Country=CAN

http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=EMA&Country=CAN

Regards,
Jose L. Jacob

--------------------------------------------
On Sat, 11/19/16, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Debt and Coverage ratios from Morningstar
To: smf_addin@yahoogroups.com
Received: Saturday, November 19, 2016, 4:09 AM


 









There is no normal bond page
available for either of those ticker symbols:

http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=xtse:ala
http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=​xtse:ema

They bring up a search page for a
ticker symbol.

PS: Can you trim what you're
replying to when you send a reply? All of your messages have
a whole bunch of extraneous code at the end of them. Must
make the digests huge. :(

On Fri, Nov 18, 2016 at
10:04 PM, Jose Jacob pepecan47@yahoo.ca
[smf_addin] <smf_addin@yahoogroups.com>
wrote:
I have in a
spread sheet about 20 US stocks and 20 CDN stocks. The
formula works as expected in all of them except the
following CDN stocks:



xtse:ala

​​xtse:ema



I get "Error" for both of them, but I can see the
Debt and Coverage ratios from bonds in Morningstar.



The formula I use is:



=RCHGetTableCell("http://bond.
morningstar.com/internal/
company.aspx?cID="&smfStrExtr(
RCHGetWebData("​​​​http://
quicktake.morningstar.com/
StockNet/bonds.aspx?Symbol="&
A24,"?cID="),"?cID=","&"),1,"
Cashflow Ops/Total Debt")












Sat Nov 19, 2016 1:04 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yes, but those aren't the web pages the formula uses. For some reason, they
treat the two Canadian companies differently.

You can certainly change the formula for those two companies...

On Sat, Nov 19, 2016 at 7:51 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Randy, these are the Morningstar pages I see bond info:
>
> http://quicktake.morningstar.com/StockNet/bonds.aspx?
> Symbol=ALA&Country=CAN
>
> http://quicktake.morningstar.com/StockNet/bonds.aspx?
> Symbol=EMA&Country=CAN
>
>

Sat Nov 19, 2016 12:56 pm (PST) . Posted by:

e_bartsch

Randy:

Regarding bar chart, I had been using this formula to get the 14 Day RSI at 30% Support:


=RCHGetTableCell("http://www.barchart.com/cheatsheet.php?sym="&C7,1,"14 Day RSI at 30%")



Where Cell "C7" is the ticker symbol.


Of course, with the revamp of the bar chart website, this formula is now broken?


Any idea how to fix it? Looks like the data can now be found at:


MMM | Stocks Trader's Cheat Sheet for 3M Company https://www.barchart.com/stocks/quotes/MMM/cheat-sheet



MMM | Stocks Trader's Cheat Sheet for 3M Company https://www.barchart.com/stocks/quotes/MMM/cheat-sheet Trader's Cheat Sheet for MMM with Support Resistance, Pivot Point, Key Turning Points.



View on www.barchart.com https://www.barchart.com/stocks/quotes/MMM/cheat-sheet
Preview by Yahoo



Thanks.


Eric


Sat Nov 19, 2016 1:06 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You should just need to use the new URL in your formula...

On Sat, Nov 19, 2016 at 1:56 PM, eabartsch@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Regarding bar chart, I had been using this formula to get the 14 Day RSI
> at 30% Support:
>
> =RCHGetTableCell("http://www.barchart.com/cheatsheet.php?sym="&C7,1,"14
> Day RSI at 30%")
>
> Where Cell "C7" is the ticker symbol.
>
> Of course, with the revamp of the bar chart website, this formula is now
> broken?
>
> Any idea how to fix it? Looks like the data can now be found at:
>
> MMM | Stocks Trader's Cheat Sheet for 3M Company
> <https://www.barchart.com/stocks/quotes/MMM/cheat-sheet>
>

Sat Nov 19, 2016 1:58 pm (PST) . Posted by:

e_bartsch

Yeah, that's the rub.

Now they have the ticker symbol embedded in the url, rather than at the end of the link. Does that mean I have to use something like Concatenate to string it all together?'


The old formula looked like this:


=RCHGetTableCell("http://www. barchart.com/cheatsheet.php? sym= http://www.barchart.com/cheatsheet.php?sym="&C7,1,"14 Day RSI at 30%")



Now, the url has the stock symbol, in this case "MMM" embedded in the link:


https://www.barchart.com/stocks/quotes/MMM/cheat-sheet https://www.barchart.com/stocks/quotes/MMM/cheat-sheet



So, I'm not sure how to embed that into the RCHGetTableCell argument.


Any ideas?


Thanks.


Eric

Sat Nov 19, 2016 2:45 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Problem. The data is no longer delivered in a table. It's delivered as JSON
data and then used to create the web page dynamically. So you need to
extract the data from the JSON data. It ends up as:

=smfConvertData(smfStrExtr(RCHGetWebData("
https://www.barchart.com/stocks/quotes/" & C7 & "/cheat-sheet","14 Day RSI
at 30%",200),"""rawValue"":","}"))

But the URL is just a concatenation of THREE strings, where one is string
is brought in with a cell reference.

On Sat, Nov 19, 2016 at 2:58 PM, eabartsch@
​...wrote:

>
> Yeah, that's the rub.
>
> Now they have the ticker symbol embedded in the url, rather than at the
> end of the link. Does that mean I have to use something like Concatenate
> to string it all together?'
>
> The old formula looked like this:
>
> =RCHGetTableCell("http://www. barchart.com/cheatsheet.php? sym=
> <http://www.barchart.com/cheatsheet.php?sym=>"&C7,1,"14 Day RSI at 30%")
>
> Now, the url has the stock symbol, in this case "MMM" embedded in the link:
>
> https://www.barchart.com/stocks/quotes/MMM/cheat-sheet
>
> So, I'm not sure how to embed that into the RCHGetTableCell argument.
>
> Any ideas?
>
>

Sat Nov 19, 2016 7:41 pm (PST) . Posted by:

sjagers

Randy,
Yesterday, I used RCHGetElementNumber 850 to retrieve Zacks Industry information for several stock symbols. Today, the same formula/function returns numbers instead of text.


The function worked yesterday, but not today.


Any suggestions?


Thanks.


Steve



Sat Nov 19, 2016 8:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Numbers are what Zacks is displaying on their web page. The question is
whether it's an error or a permanent change....

For example:

https://www.zacks.com/stock/quote/MMM

...shows an "Industry"; of 30.

On Sat, Nov 19, 2016 at 8:41 PM, sjagers@
​...wrote:

>
> Yesterday, I used RCHGetElementNumber 850 to retrieve Zacks Industry
> information for several stock symbols. Today, the same formula/function
> returns numbers instead of text.
>
> The function worked yesterday, but not today.
>
> Any suggestions?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)