Rabu, 02 Desember 2015

[smf_addin] Digest Number 3571

11 Messages

Digest #3571
1a
(no subject) by "J W" jrwbob
1b
Re: by "Randy Harmelink" rharmelink
2b
Re: Gurufocus, retrieving non US data by "Randy Harmelink" rharmelink
2c
Re: Gurufocus, retrieving non US data by "Randy Harmelink" rharmelink
3a
Re: SpreadsheetGear - anyone here using it? by "Oscar Banduzzy" obanduzzy
3b
Re: SpreadsheetGear - anyone here using it? by "Kermit W. Prather" kermitpra
4a
4b
Re: morningstar by "Randy Harmelink" rharmelink
5b

Messages

Mon Nov 30, 2015 4:05 pm (PST) . Posted by:

"J W" jrwbob

Hi all, new to the group.I am seeking to add stock data to excel with dividend per shareDoes anyone have such a query?
thank you

Mon Nov 30, 2015 4:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You could get the estimated forward annual dividend amount (from Yahoo's
Key Statistics web page) with something like:

=RCHGetElementNumber("MMM";,4924)

On Mon, Nov 30, 2015 at 3:41 PM, J W jrwbob@... wrote:

>
> I am seeking to add stock data to excel with dividend per share
> Does anyone have such a query?
>
>
>

Tue Dec 1, 2015 8:31 am (PST) . Posted by:

mark.boogaers

Randy,


Thanks for the very useful Excel Add-in.


I installed the version with the smfGetGuruFocusItem() function as well as downloading the template. Works fine apart from the fact the line 'EBIT per share' returns an error as well as all lines below 'PE ratio (ttm)'. I changed the template a bit as I would like to compare results for certain non US companies for a particular year.


I do not know what symbol format to use for the Asian stocks. At the Gurufocus website I could key in XKLS:0001 or HKSE:00011 for example, but using the smfGetGutuFocusItem function that does not work. Any idea what format would work or is the function not ready for use with non US stocks?



Thanks in advance
Mark Boogaers


Gurufocus premium member for Asia region only,
Windows 10,
Excel 2013,
MS Edge/Google Chrome (for the Gurufocus login)

Tue Dec 1, 2015 8:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

They changed the coding on the web page so EBIT was no longer working. I've
got it fixed in my version of the add-in, but haven't released it yet.

The lines below "PE ratio" are only available to subscribers.

GuruFocus uses foreign ticker symbols in the format "XKLS:4715", but non-US
companies are only available to global subscribers. I can't say for sure if
the function would work for those stocks, since I don't have a global
subscription.

On Tue, Dec 1, 2015 at 3:04 AM, mark.boogaers@... wrote:

> I installed the version with the smfGetGuruFocusItem() function as well
> as downloading the template. Works fine apart from the fact the line 'EBIT
> per share' returns an error as well as all lines below 'PE ratio (ttm)'. I
> changed the template a bit as I would like to compare results for certain
> non US companies for a particular year.
>
> I do not know what symbol format to use for the Asian stocks. At the
> Gurufocus website I could key in XKLS:0001 or HKSE:00011 for example, but
> using the smfGetGutuFocusItem function that does not work. Any idea what
> format would work or is the function not ready for use with non US stocks?
>
>

Tue Dec 1, 2015 8:47 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Oops. Didn't get down that far.

A Google Chrome login won't help. Not sure about MS Edge. You may need to
log in with either IE or the EXCEL Web Query dialog...

On Tue, Dec 1, 2015 at 3:04 AM, mark.boogaers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Gurufocus premium member for Asia region only,
>
> Windows 10,
>
> Excel 2013,
>
> MS Edge/Google Chrome (for the Gurufocus login)
>
>

Tue Dec 1, 2015 9:36 am (PST) . Posted by:

"Oscar Banduzzy" obanduzzy

Never heard of it Kermit what makes it appealing to you?
On Nov 23, 2015 2:33 PM, "'Kermit W. Prather' kermitp@tampabay.rr.com
[smf_addin]" <smf_addin@yahoogroups.com> wrote:

>
>
>
>
> I was wondering if anyone in this group was using or has tried the
> SpreadsheetGear
>
>
>
> Kermit
>
>
>
> *Need Lightning-Fast Excel Calculations?
> <http://apps.developermedia.com/click/167923?_z=12201511236522070>*
> Use SpreadsheetGear to evaluate complex Excel-based models with the
> fastest and
>
> most complete Excel-compatible calculation engine available.
>
> Includes 398 Excel-compatible functions, multithreaded recalc, array
> formula support and more.
>
> Try it now!
> <http://apps.developermedia.com/click/167922?_z=12201511236522070>
>
>

Tue Dec 1, 2015 10:54 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

I got an email from codeproject.com that mentioned it.

I'm to the point I don't believe anyone ads.

This one is not cheap

Subscription Type
Price

New Subscription*
$1,399


Renewal†
$699


Upgrade Active Subscription‡
$999


If interested, Click on next line or the try it now below.

<http://apps.developermedia.com/click/167923?_z=12201511236522070> Need Lightning-Fast Excel Calculations?
Use SpreadsheetGear to evaluate complex Excel-based models with the fastest
and most complete Excel-compatible calculation engine available.
Includes 398 Excel-compatible functions, multithreaded recalc, array formula support and more. <http://apps.developermedia.com/click/167922?_z=12201511236522070> Try it now!


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, December 01, 2015 12:36 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SpreadsheetGear - anyone here using it?


Never heard of it Kermit what makes it appealing to you?
On Nov 23, 2015 2:33 PM, "'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


I was wondering if anyone in this group was using or has tried the SpreadsheetGear

Kermit

<http://apps.developermedia.com/click/167923?_z=12201511236522070> Need Lightning-Fast Excel Calculations?
Use SpreadsheetGear to evaluate complex Excel-based models with the fastest and
most complete Excel-compatible calculation engine available.
Includes 398 Excel-compatible functions, multithreaded recalc, array formula support and more.
<http://apps.developermedia.com/click/167922?_z=12201511236522070> Try it now!

Tue Dec 1, 2015 10:54 am (PST) . Posted by:

iravink

HI Randy I am trying to get historical Total Assets figures from this morningstar page without success. is it possible ? thank you


Balance Sheet for Alphabet Inc Class A (GOOGL) from Morningstar.com http://financials.morningstar.com/balance-sheet/bs.html?t=GOOGL®ion=usa&culture=en-US

Balance Sheet for Alphabet Inc Class A (GOOGL) from Morningstar.com http://financials.morningstar.com/balance-sheet/bs.html?t=GOOGL®ion=usa&culture=en-US Get Alphabet Inc Class A (GOOGL) Balance Sheet or Statement of Financial Position including assets, cash, current assets, long-term assets, liabilities, current debt, long-term debt, and stockholders' equity, including preferred stock, common stock and treasury stock.



View on financials.morningstar.com http://financials.morningstar.com/balance-sheet/bs.html?t=GOOGL®ion=usa&culture=en-US
Preview by Yahoo









Tue Dec 1, 2015 12:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You can't grab anything from that web page because it's dynamically
generated. There's nothing in the source code of the web page that can be
extracted. I would recommend this solution from the "FAQs and Tips" web
page:

Link
<https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/19776>MStar.001
- Grabbing the financial statements CSV file from Morningstar
So, for example:

=smfGetCSVFile("
http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=GOOG&reportType=bs&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw
")

Otherwise, to extract individual items, you'd need to go to the AJAX output
file they use to build the page:

http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=bs&period=12&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=GOOGL

...which is NOT a trivial extraction.

On Tue, Dec 1, 2015 at 11:26 AM, iravink@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> HI Randy
> I am trying to get historical Total Assets figures from this morningstar
> page without success. is it possible ? thank you
>
> Balance Sheet for Alphabet Inc Class A (GOOGL) from Morningstar.com
> <http://financials.morningstar.com/balance-sheet/bs.html?t=GOOGL®ion=usa&culture=en-US>
> Balance Sheet for Alphabet Inc Class A (GOOGL) from Morningstar.com
> <http://financials.morningstar.com/balance-sheet/bs.html?t=GOOGL®ion=usa&culture=en-US>
> Get Alphabet Inc Class A (GOOGL) Balance Sheet or Statement of Financial
> Position including assets, cash, current assets, long-term assets,
> liabilities, current debt, long-term debt, and stockholders' equity,
> including preferred stock, common stock and treasury stock.
> View on financials.morningstar.com
> <http://financials.morningstar.com/balance-sheet/bs.html?t=GOOGL®ion=usa&culture=en-US>
> Preview by Yahoo
>
>
>

Tue Dec 1, 2015 7:35 pm (PST) . Posted by:

malli.boggala

Hello Randy,


I'm trying to get prior 3 days Low and Highs from barchart. able to pull only Y'day Low and highs only. need you your help to get other 2 days data. would you pls. help me.


http://www.barchart.com/detailedquote/stocks/$SPX http://www.barchart.com/detailedquote/stocks/$SPX


Yesterday Low =RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX",2,">Low",4)
Y'day high =RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX",1,">Low",4)

Regard's,
Arjun

Tue Dec 1, 2015 8:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Your six formulas would be:

=RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX
",4,">Low",,,,2)
=RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX
",3,">Low",,,,2)

=RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX
",4,">Low",,,,3)
=RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX
",3,">Low",,,,3)

=RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX
",4,">Low",,,,4)
=RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/$SPX
",3,">Low",,,,4)

Note that the 4 in your formulas below is the second search string...

On Tue, Dec 1, 2015 at 8:35 PM, malli.boggala@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm trying to get prior 3 days Low and Highs from barchart. able to pull
> only Y'day Low and highs only. need you your help to get other 2 days data.
> would you pls. help me.
>
> http://www.barchart.com/detailedquote/stocks/$SPX
>
> Yesterday Low =RCHGetTableCell("
> http://www.barchart.com/detailedquote/stocks/$SPX",2,">Low",4)
>
> Y'day high =RCHGetTableCell("
> http://www.barchart.com/detailedquote/stocks/$SPX",1,">Low",4)
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)