Minggu, 17 September 2017

[smf_addin] Digest Number 4148[1 Attachment]

11 Messages

Digest #4148
1a
Not working: SMF-Template-Google-Balance-Sheet-Tables.xls by dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
2a
smfPricesBetween function by yolande_tulasse
2b
Re: smfPricesBetween function by "Randy Harmelink" rharmelink
2c
3a
Gurufocus by danseiler2000
3b
Re: Gurufocus by "Randy Harmelink" rharmelink
3c
Re: Gurufocus by "Randy Harmelink" rharmelink
4a
SMF Add-in Blog by rharmelink
4b
Re: SMF Add-in Blog by yolande_tulasse

Messages

Sun Sep 17, 2017 4:16 am (PDT) . Posted by:

dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg

Hi Randy,


The template "SMF-Template-Google-Balance-Sheet-Tables.xls http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Balance-Sheet-Tables.xls" isn't working anymore. Is this a known problem?


I only receive NA and Error (see attached).


Could you please give me guidance on how to solve this?


I'm currently running this version on Excel 2007;
Stock Market Functions add-in, Version 2.1.2017.08.13 (C:\SMF ADD-IN; Windows (32-bit) NT 6.02; 12.0; ; Local; 1)


Many thanks!

Best,
Rico

Attachment(s) from
1 of 1 Photo(s)

Sun Sep 17, 2017 7:12 am (PDT) . Posted by:

"Craig Passow" passow

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33150

On 9/17/2017 6:16 AM, ricoteikotte@yahoo.com [smf_addin] wrote:
>  
> [Attachment(s) <#TopText> from ricoteikotte@yahoo.com [smf_addin]
> included below]
>
> Hi Randy,
>
>
> The template "SMF-Template-Google-Balance-Sheet-Tables.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Balance-Sheet-Tables.xls>"
> isn't working anymore. Is this a known problem?
>
>
> I only receive NA and Error (see attached).
>
>
> Could you please give me guidance on how to solve this?
>
>
> I'm currently running this version on Excel 2007; 
>
> Stock Market Functions add-in, Version 2.1.2017.08.13 (C:\SMF ADD-IN;
> Windows (32-bit) NT 6.02; 12.0; ; Local; 1)
>
>
> Many thanks!
>
>
> Best,
>
> Rico
>
>  
>
>

Sun Sep 17, 2017 9:53 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

​See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33150​

On Sun, Sep 17, 2017 at 4:16 AM, ricoteikotte@
​...
wrote:

> The template "SMF-Template-Google-Balance-Sheet-Tables.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Balance-Sheet-Tables.xls>"
> isn't working anymore. Is this a known problem?
>
> I only receive NA and Error (see attached).
>
> Could you please give me guidance on how to solve this?
>
> I'm currently running this version on Excel 2007;
>
> Stock Market Functions add-in, Version 2.1.2017.08.13 (C:\SMF ADD-IN;
> Windows (32-bit) NT 6.02; 12.0; ; Local; 1)
>
> Many thanks!
>
>
>

Sun Sep 17, 2017 5:25 am (PDT) . Posted by:

yolande_tulasse

Hi Randy,


Is the function smfPricesBetween currently working?


I tried a simple array paste using (ctrl shit enter) of
=smfPricesBetween("IBM",TODAY()-365,TODAY())


And it returns no values, nor does it look like the function tried to search for data.

Sun Sep 17, 2017 10:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Working fine here:

Open Date Open Price High Date High Price Low Date Low Price Close Date Close
Price Volume Previous Close Total Return CAGR
2016-09-19 $149.22 2017-02-16 $179.13 2017-08-21 $139.13 2017-09-15 $144.82
981480200 $148.23 -2.3% -2.3%

​Are you using the beta version of the add-in? You need the updates for
Yahoo's historical quotes.​

On Sun, Sep 17, 2017 at 5:25 AM, yolande_tulasse@
​...
wrote:

> Is the function smfPricesBetween currently working?
>
> I tried a simple array paste using (ctrl shit enter) of
>
> =smfPricesBetween("IBM",TODAY()-365,TODAY())
>
> And it returns no values, nor does it look like the function tried to
> search for data.
>

Sun Sep 17, 2017 6:19 pm (PDT) . Posted by:

yolande_tulasse

Thanks a lot Randy. I didn't see the last update indeed. Sorry about that...

The new blog is a GREAT idea!


Thanks for everything man.

Sun Sep 17, 2017 4:54 pm (PDT) . Posted by:

danseiler2000

Has anyone been able to access gurufocus' data? Just want to make sure that I'm doing something wrong.


Thanks,
Daniel

Sun Sep 17, 2017 5:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sigh. Looks like they've changed things again. Not sure when I'll have a
change to look at it.

On Sun, Sep 17, 2017 at 4:54 PM, danseiler2000@
​...
wrote:

> Has anyone been able to access gurufocus' data? Just want to make sure
> that I'm doing something wrong.
>
>
>

Sun Sep 17, 2017 5:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Turned out to be an easy fix. They just changed how they coded a label on
the web page. I just uploaded a new ZIP file:

http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.09.17.zip

That is now the official release of the add-in, and there is no more beta
release.

On Sun, Sep 17, 2017 at 4:54 PM, danseiler2000@... wrote:

> Has anyone been able to access gurufocus' data? Just want to make sure
> that I'm doing something wrong.
>
>
>
>

Sun Sep 17, 2017 6:05 pm (PDT) . Posted by:

rharmelink

I just created a blog for the SMF Add-in:


https://smf-add-in.blogspot.com/ https://smf-add-in.blogspot.com/



It's an experiment I want to try, to provide people a way to keep up-to-date with issues and file updates without having to deal with the noise level on the Yahoo or Google discussion groups.


Sun Sep 17, 2017 6:27 pm (PDT) . Posted by:

yolande_tulasse

Great idea Randy!

Already subscribed to your blog through blogtrottr . com so I'll stop bothering you about issues I could have easily resolved by simply updating for instance ;)

Cheers
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.22

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)