Sabtu, 02 September 2017

[smf_addin] Digest Number 4137

13 Messages

Digest #4137
1a
Googleitem returns error? by blm3@sbcglobal.net
1b
Re: Googleitem returns error? by "Randy Harmelink" rharmelink
1c
Re: Googleitem returns error? by blm3@sbcglobal.net
1d
Off topic - Learning VBA by "rn str" mushin2003
1e
Re: Off topic - Learning VBA by "Randy Harmelink" rharmelink
2a
=RCHGetElementNumber(Ticker, 5439) by "Thomas J Strouse" thomas.strouse@nielsen.com
2b
Re: =RCHGetElementNumber(Ticker, 5439) by "Randy Harmelink" rharmelink
2c
Re: =RCHGetElementNumber(Ticker, 5439) by thomas.strouse@nielsen.com
2d
Re: =RCHGetElementNumber(Ticker, 5439) by "Randy Harmelink" rharmelink

Messages

Fri Sep 1, 2017 7:52 pm (PDT) . Posted by:

blm3@sbcglobal.net

3302 SE Google Annual Income Statement -- Date -- FY1


=RCHGetElementNumber("SLVO",3302) returns Error


Is this expected? Do I need to be logged into the site in IE before using the function?

Fri Sep 1, 2017 8:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Expected. Google doesn't carry financial statements for SLVO.

On Fri, Sep 1, 2017 at 7:52 PM, blm3@
​...
wrote:

>
> 3302 SE Google Annual Income Statement -- Date -- FY1
>
> =RCHGetElementNumber("SLVO",3302) returns Error
>
> Is this expected? Do I need to be logged into the site in IE before using
> the function?
>

Sat Sep 2, 2017 1:41 am (PDT) . Posted by:

"rn str" mushin2003

This is off topic from Randy's financial addins. I have been a recluse member to this group for more than 10 years now. I use to hack my way thru VBA and the financial markets. I recently got a job which would benefit from using some VBA coding. I was wondering if anyone could recommend a good book or two for programming in Excel VBA?

I am using Excel 2016 for an intranet environment with SharePoint and Office 365. I believe macros are not supported in Office 365 Excel which is ok, if they can download my version and run it locally on the user machine.

One concern I had was that read somewhere Microsoft has stopped developing Excel VBA and the future is to move in a different direction. To my knowledge that is not any time soon though so I was pursuing automation of a lot of manual tasks.

Thanks,
Rob

________________________________

.

Sat Sep 2, 2017 1:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm currently using the add-in with Office 365 on two Windows 10 machines.

On Sat, Sep 2, 2017 at 1:29 AM, rn str mushin2003@ wrote:

> I am using Excel 2016 for an intranet environment with SharePoint and
> Office 365. I believe macros are not supported in Office 365 Excel which is
> ok, if they can download my version and run it locally on the user machine.
>
>
>

Fri Sep 1, 2017 9:06 pm (PDT) . Posted by:

"Thomas J Strouse" thomas.strouse@nielsen.com

Randy,

Any reason why "RCHGetElementNumber(Ticker, 5439)" would return "0" for
the Annual Income Statement -- Amortization of Intangibles -- FY4 for
CSCO. The correct result is 395. The remaining years are correct.

Thanks

Tom

Sat Sep 2, 2017 2:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

0 is what AdvFN has posted...

http://www.advfn.com/stock-market/NASDAQ/CSCO/financials?btn=annual_reports&mode=company_data

On Fri, Sep 1, 2017 at 7:17 PM, Thomas J Strouse thomas.strouse@
​...
wrote:

>
> Any reason why "RCHGetElementNumber(Ticker, 5439)" would return "0" for
> the Annual Income Statement -- Amortization of Intangibles -- FY4 for
> CSCO. The correct result is 395. The remaining years are correct.
>
>
>

Sat Sep 2, 2017 9:08 am (PDT) . Posted by:

thomas.strouse@nielsen.com

Thanks Randy! I truly appreciate the time you spend helping the group. I did see that AdvFN has other incorrect or missing data besides the one I posted. Is there a better way to get reliable data short of manually gathering it from the 10-Ks on EDGAR?

Thanks Again


Tom

Sat Sep 2, 2017 10:08 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I think no matter what the route, some errors will show up...

On Sat, Sep 2, 2017 at 9:08 AM, thomas.strouse@
​...
wrote:

>
> Thanks Randy! I truly appreciate the time you spend helping the group. I
> did see that AdvFN has other incorrect or missing data besides the one I
> posted. Is there a better way to get reliable data short of manually
> gathering it from the 10-Ks on EDGAR?
>
> Thanks Again
>
>

Fri Sep 1, 2017 10:53 pm (PDT) . Posted by:

zbgb952

Hello Randy..
As of 9/1/17 at 10:52 PM PST, this still isn't working.

Could you post an update here when it is? Thanks.

Morey

Fri Sep 1, 2017 10:56 pm (PDT) . Posted by:

zbgb952

Hello Randy,

I just checked the Reuters website ... the link the you proveded in your last response:

http://www.reuters.com/finance/stocks/financial-highlights/MMM http://www.reuters.com/finance/stocks/financial-highlights/MMM

And there appears to be data there...including dividend growth. But it is still coming up as 0 in my spreadsheet.

Please advise.

Thanks.

Morey

Sat Sep 2, 2017 3:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Still looks empty to me...the element is defined on the "Dividends"
section, not the "Growth" highlights for the Income Statement.

You can grab the other one with this work-around:

=smfGetTagContent("
http://www.reuters.com/finance/stocks/financial-highlights/MMM","td",3,"Dividend
%",,,,1)

On Fri, Sep 1, 2017 at 10:56 PM, mb0329@
​...
wrote:

>
> I just checked the Reuters website ... the link the you proveded in your
> last response:
>
> http://www.reuters.com/finance/stocks/financial-highlights/MMM
>
> And there appears to be data there...including dividend growth. But it is
> still coming up as 0 in my spreadsheet.
>
> Please advise.
>
>

Sat Sep 2, 2017 2:12 pm (PDT) . Posted by:

zbgb952

Thanks Randy. I will wait awhile and hopefully, it will all straighten out.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.32

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)