Kamis, 08 Agustus 2019

[smf_addin] Digest Number 4595

12 Messages

Digest #4595
2a
2b
Re: GetYahooPortfolioView() by "Randy Harmelink" rharmelink
2c
Re: GetYahooPortfolioView() by "Frank kirk" nautilustech

Messages

Wed Aug 7, 2019 8:03 am (PDT) . Posted by:

rr76012

Hello Randy,


I am getting error messages for yahoo key statistics on rchgetelementnumber.


What should I do?


Thanks,


rr76012

Wed Aug 7, 2019 8:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. I just tried #4924 with MMM and it worked fine
here....

Are you using the new element definitions I uploaded in June?

https://smf-add-in.blogspot.com/2019/06/alert-some-yahoo-element-definitions.html

On Wed, Aug 7, 2019 at 8:19 AM rr76012@... wrote:

> I am getting error messages for yahoo key statistics on
> rchgetelementnumber.
>
> What should I do?
>

Wed Aug 7, 2019 1:35 pm (PDT) . Posted by:

rr76012

Hi Randy,


No, I have not downloaded the June 2019 yahoo element definitions.


Randy,
Do I just download the June 2019 file and replace that 1 file, or do I need to replace all files?


Thanks,


rr76012

Wed Aug 7, 2019 1:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Exit EXCEL and replace just that one file in the add-in's folder.

On Wed, Aug 7, 2019 at 1:35 PM rr76012@... wrote:

>
> No, I have not downloaded the June 2019 yahoo element definitions.
>
> Do I just download the June 2019 file and replace that 1 file, or do I
> need to replace all files?
>
>
>

Wed Aug 7, 2019 1:48 pm (PDT) . Posted by:

rr76012

Randy, Can I just download and replace "smf-elements-2.txt" file, is so where do I get this file to download?


thanks


rr76012




Wed Aug 7, 2019 2:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yes, that's the only file you need. It's in the "Elements" folder on the
website:

http://ogres-crypt.com/SMF/Elements/

On Wed, Aug 7, 2019 at 1:48 PM rr76012@... wrote:

>
> Randy, Can I just download and replace "smf-elements-2.txt" file, is so
> where do I get this file to download?
>
>
>

Wed Aug 7, 2019 8:12 am (PDT) . Posted by:

nautilustech

Recently installed Office 2019 & set up the Add-In. For a couple of days, the formula returned #NAME in all the cells. Now all the cells are populated with the word "Symbol". Pleas let me know what I'm doing wrong. Many thanks.


Frank Kirk

Wed Aug 7, 2019 9:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

#NAME? would typically mean the add-in wasn't installed and activated, so
EXCEL can't find the function.

If you're getting "Symbol" in all cells, it sound like you don't have the
function array-entered over a range.

On Wed, Aug 7, 2019 at 9:36 AM nautilustech@... wrote:

> Recently installed Office 2019 & set up the Add-In. For a couple of days,
> the formula returned #NAME in all the cells. Now all the cells are
> populated with the word "Symbol". Pleas let me know what I'm doing wrong.
> Many thanks.
>
>
>

Wed Aug 7, 2019 4:46 pm (PDT) . Posted by:

"Frank kirk" nautilustech

Thanks. Array entry solved the problem. Could have sworn that I did that... Guesd not.

Sent from Yahoo Mail on Android

On Wed, Aug 7, 2019 at 12:51, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote: <!--#yiv8728455991 #yiv8728455991 .yiv8728455991ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv8728455991 div.yiv8728455991ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv8728455991 div.yiv8728455991photo-title a, #yiv8728455991 div.yiv8728455991photo-title a:active, #yiv8728455991 div.yiv8728455991photo-title a:hover, #yiv8728455991 div.yiv8728455991photo-title a:visited {text-decoration:none;}#yiv8728455991 div.yiv8728455991attach-table div.yiv8728455991attach-row {clear:both;}#yiv8728455991 div.yiv8728455991attach-table div.yiv8728455991attach-row div {float:left;}#yiv8728455991 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv8728455991 div.yiv8728455991ygrp-file {width:30px;}#yiv8728455991 div.yiv8728455991attach-table div.yiv8728455991attach-row div div a {text-decoration:none;}#yiv8728455991 div.yiv8728455991attach-table div.yiv8728455991attach-row div div span {font-weight:normal;}#yiv8728455991 div.yiv8728455991ygrp-file-title {font-weight:bold;}#yiv8728455991 --> <!--#yiv8728455991 #yiv8728455991ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8728455991 #yiv8728455991ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8728455991 #yiv8728455991ygrp-mkp #yiv8728455991hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8728455991 #yiv8728455991ygrp-mkp #yiv8728455991ads {margin-bottom:10px;}#yiv8728455991 #yiv8728455991ygrp-mkp .yiv8728455991ad {padding:0 0;}#yiv8728455991 #yiv8728455991ygrp-mkp .yiv8728455991ad p {margin:0;}#yiv8728455991 #yiv8728455991ygrp-mkp .yiv8728455991ad a {color:#0000ff;text-decoration:none;}-->

#NAME? would typically mean the add-in wasn't installed and activated, so EXCEL can't find the function.
If you're getting "Symbol" in all cells, it sound like you don't have the function array-entered over a range.
On Wed, Aug 7, 2019 at 9:36 AM nautilustech@... wrote:

Recently installed Office 2019 & set up the Add-In.  For a couple of days, the formula returned #NAME in all the cells.  Now all the cells are populated with the word "Symbol".  Pleas let me know what I'm doing wrong.  Many thanks.

Wed Aug 7, 2019 8:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

#4942 is based on a JSON file. Not sure I can be of much help since I can't
repeat the results here.

What do you get with:

=RCHGetElementNumber("Version")
=RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundPerformance
",,200)
=RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundPerformance
","tenYear",200)

On Wed, Aug 7, 2019 at 1:56 AM russelking@... wrote:

> Just built a new computer w/ a fresh win 10 Pro 64 bit Version 1903.
>
> Element #'s 4942, 5061,5064, 5079, & 5093 return "Not Found"
>
> But, elements 4017-4790 work just fine.
>
> On my lap top and old desk top (both running Version 1809) all elements
> work just fine.
>
> Any ideas?
>
>
>

Wed Aug 7, 2019 3:27 pm (PDT) . Posted by:

wyerud




Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\smf_addin; Windows (64-bit) NT 10.00; 16.0; ; ; 1)

{"quoteSummary":{"result":[{"fundPerformance":{"maxAge":1,"performanceOverview":{"asOfDate":{"raw":1549238400,"fmt":"2019-02-04"},"morningStarReturnRating":{"raw":4.0,"fmt":"4"},"ytdReturnPct":{"raw": https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundPerformance




tenYear":{"raw":0.1387,"fmt":"13.87%"}},"trailingReturns":{"asOfDate":{"raw":1564531200,"fmt":"2019-07-31"},"ytd":{"raw":0.2016,"fmt":"20.16%"},"oneMonth":{"raw":0.0143,"fmt":"1.43%"},"threeMonth":{"r https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundPerformance

Thanks,


Russ

Wed Aug 7, 2019 4:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That all looks like what I would expect to see, so I'm not sure where it
could be going wrong. The JSON extract code is not mine, so I'm not
familiar with all of the idiosyncrasies of it. I'm still doing 32-bit, so I
don't know if the 64-bit would cause an issue.

On Wed, Aug 7, 2019 at 3:27 PM russelking@... wrote:

>
> Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\smf_addin;
> Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
>
> {"quoteSummary":{"result":[{"fundPerformance":{"maxAge":1,"performanceOverview":{"asOfDate":{"raw":1549238400,"fmt":"2019-02-04"},"morningStarReturnRating":{"raw":4.0,"fmt":"4"},"ytdReturnPct":{"raw":
> <https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundPerformance>
>
>
>
> tenYear":{"raw":0.1387,"fmt":"13.87%"}},"trailingReturns":{"asOfDate":{"raw":1564531200,"fmt":"2019-07-31"},"ytd":{"raw":0.2016,"fmt":"20.16%"},"oneMonth":{"raw":0.0143,"fmt":"1.43%"},"threeMonth":{"r
> <https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundPerformance>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.41

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)