Jumat, 04 Mei 2018

[smf_addin] Digest Number 4328

15 Messages

Digest #4328
1a
Re: Navellier Port ranking not working by "Randy Harmelink" rharmelink
2b
Re: YahooHistory missing data.. by "Randy Harmelink" rharmelink
2d
2e
Re: Retrieving stock name by "Randy Harmelink" rharmelink
3b
Re: rchgetElementNumber "621" not working by "Randy Harmelink" rharmelink
3f
Re: rchgetElementNumber "621" not working by "Randy Harmelink" rharmelink
3g
Re: rchgetElementNumber "621" not working by "Randy Harmelink" rharmelink

Messages

Thu May 3, 2018 6:34 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

No big mystery there. The web page no longer exists. Try something like:

=RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t="&A3,0,"Total
Grade:")

On Thu, May 3, 2018 at 6:10 PM, Fred Wright fredwwright@
​...
wrote:

>
> I have been pulling the free navellier portfolio ranking for a while and
> it stopped working recently.
>
> I don't think the URL has changed, but perhaps they changed the structure
> of the web page?
>
> I am using - =RCHGetTableCell("https://www.navelliergrowth.
> investorplace.com/portfolio-grader/stock-report.html?q="&
> A3&"&submit=submit&type=site",0,"Total Grade:") (where A3 is a symbol)
>
> This now returns Error.
>
> Any thoughts?
>
>

Fri May 4, 2018 1:13 am (PDT) . Posted by:

perseuslim11

Hi everyone, is someone else experiencing missing data for yahoohisotry using smfgetyahoohistory function?
for myself, the stock price data for Feb, March, April 2018 and till 3 May 2018 is missing


my pulled data looks exactly like this:
https://finance.yahoo.com/quote/5199.KL/history/ https://finance.yahoo.com/quote/5199.KL/history/

https://finance.yahoo.com/quote/4324.KL/history/ https://finance.yahoo.com/quote/4324.KL/history/



only up till 30 Jan 2018 and the latest date 4 May 2018 avaialble..


if anyone of you knows how to solve this problem please let me know, much appreciated =)


Fri May 4, 2018 1:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Best option is to use the "Suggestions" link on the right hand side of the
Yahoo page and report the problem that you see on the web page.

On Fri, May 4, 2018 at 1:13 AM, perseuslim11@
​...
wrote:

> Hi everyone, is someone else experiencing missing data for yahoohisotry
> using smfgetyahoohistory function?
>
> for myself, the stock price data for Feb, March, April 2018 and till 3 May
> 2018 is missing
>
> my pulled data looks exactly like this:
>
> https://finance.yahoo.com/quote/5199.KL/history/
>
> https://finance.yahoo.com/quote/4324.KL/history/
>
> only up till 30 Jan 2018 and the latest date 4 May 2018 avaialble..
>
> if anyone of you knows how to solve this problem please let me know, much
> appreciated =)
>
>
>

Fri May 4, 2018 3:15 am (PDT) . Posted by:

"joo zhi" perseuslim11


OK noted with thanks Randy, I've just sent a suggestion there via the link you mentioned =)
发自 Android 版 Yahoo 邮箱

2018 年 5 月 4 日周五下午 4:23,Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> 写道:  

Best option is to use the "Suggestions" link on the right hand side of the Yahoo page and report the problem that you see on the web page.
On Fri, May 4, 2018 at 1:13 AM, perseuslim11@​.... wrote:

Hi everyone, is someone else experiencing missing data for yahoohisotry using smfgetyahoohistory function?

for myself, the stock price data for Feb, March, April 2018 and till 3 May 2018 is missing

my pulled data looks exactly like this:

https://finance.yahoo.com/ quote/5199.KL/history/

https://finance.yahoo.com/ quote/4324.KL/history/

only up till 30 Jan 2018 and the latest date 4 May 2018 avaialble..

if anyone of you knows how to solve this problem please let me know, much appreciated =)

#yiv3719309089 #yiv3719309089 -- #yiv3719309089ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3719309089 #yiv3719309089ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3719309089 #yiv3719309089ygrp-mkp #yiv3719309089hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3719309089 #yiv3719309089ygrp-mkp #yiv3719309089ads {margin-bottom:10px;}#yiv3719309089 #yiv3719309089ygrp-mkp .yiv3719309089ad {padding:0 0;}#yiv3719309089 #yiv3719309089ygrp-mkp .yiv3719309089ad p {margin:0;}#yiv3719309089 #yiv3719309089ygrp-mkp .yiv3719309089ad a {color:#0000ff;text-decoration:none;}#yiv3719309089 #yiv3719309089ygrp-sponsor #yiv3719309089ygrp-lc {font-family:Arial;}#yiv3719309089 #yiv3719309089ygrp-sponsor #yiv3719309089ygrp-lc #yiv3719309089hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3719309089 #yiv3719309089ygrp-sponsor #yiv3719309089ygrp-lc .yiv3719309089ad {margin-bottom:10px;padding:0 0;}#yiv3719309089 #yiv3719309089actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3719309089 #yiv3719309089activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3719309089 #yiv3719309089activity span {font-weight:700;}#yiv3719309089 #yiv3719309089activity span:first-child {text-transform:uppercase;}#yiv3719309089 #yiv3719309089activity span a {color:#5085b6;text-decoration:none;}#yiv3719309089 #yiv3719309089activity span span {color:#ff7900;}#yiv3719309089 #yiv3719309089activity span .yiv3719309089underline {text-decoration:underline;}#yiv3719309089 .yiv3719309089attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3719309089 .yiv3719309089attach div a {text-decoration:none;}#yiv3719309089 .yiv3719309089attach img {border:none;padding-right:5px;}#yiv3719309089 .yiv3719309089attach label {display:block;margin-bottom:5px;}#yiv3719309089 .yiv3719309089attach label a {text-decoration:none;}#yiv3719309089 blockquote {margin:0 0 0 4px;}#yiv3719309089 .yiv3719309089bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3719309089 .yiv3719309089bold a {text-decoration:none;}#yiv3719309089 dd.yiv3719309089last p a {font-family:Verdana;font-weight:700;}#yiv3719309089 dd.yiv3719309089last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3719309089 dd.yiv3719309089last p span.yiv3719309089yshortcuts {margin-right:0;}#yiv3719309089 div.yiv3719309089attach-table div div a {text-decoration:none;}#yiv3719309089 div.yiv3719309089attach-table {width:400px;}#yiv3719309089 div.yiv3719309089file-title a, #yiv3719309089 div.yiv3719309089file-title a:active, #yiv3719309089 div.yiv3719309089file-title a:hover, #yiv3719309089 div.yiv3719309089file-title a:visited {text-decoration:none;}#yiv3719309089 div.yiv3719309089photo-title a, #yiv3719309089 div.yiv3719309089photo-title a:active, #yiv3719309089 div.yiv3719309089photo-title a:hover, #yiv3719309089 div.yiv3719309089photo-title a:visited {text-decoration:none;}#yiv3719309089 div#yiv3719309089ygrp-mlmsg #yiv3719309089ygrp-msg p a span.yiv3719309089yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3719309089 .yiv3719309089green {color:#628c2a;}#yiv3719309089 .yiv3719309089MsoNormal {margin:0 0 0 0;}#yiv3719309089 o {font-size:0;}#yiv3719309089 #yiv3719309089photos div {float:left;width:72px;}#yiv3719309089 #yiv3719309089photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3719309089 #yiv3719309089photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3719309089 #yiv3719309089reco-category {font-size:77%;}#yiv3719309089 #yiv3719309089reco-desc {font-size:77%;}#yiv3719309089 .yiv3719309089replbq {margin:4px;}#yiv3719309089 #yiv3719309089ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3719309089 #yiv3719309089ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3719309089 #yiv3719309089ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3719309089 #yiv3719309089ygrp-mlmsg select, #yiv3719309089 input, #yiv3719309089 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3719309089 #yiv3719309089ygrp-mlmsg pre, #yiv3719309089 code {font:115% monospace;}#yiv3719309089 #yiv3719309089ygrp-mlmsg * {line-height:1.22em;}#yiv3719309089 #yiv3719309089ygrp-mlmsg #yiv3719309089logo {padding-bottom:10px;}#yiv3719309089 #yiv3719309089ygrp-msg p a {font-family:Verdana;}#yiv3719309089 #yiv3719309089ygrp-msg p#yiv3719309089attach-count span {color:#1E66AE;font-weight:700;}#yiv3719309089 #yiv3719309089ygrp-reco #yiv3719309089reco-head {color:#ff7900;font-weight:700;}#yiv3719309089 #yiv3719309089ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3719309089 #yiv3719309089ygrp-sponsor #yiv3719309089ov li a {font-size:130%;text-decoration:none;}#yiv3719309089 #yiv3719309089ygrp-sponsor #yiv3719309089ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3719309089 #yiv3719309089ygrp-sponsor #yiv3719309089ov ul {margin:0;padding:0 0 0 8px;}#yiv3719309089 #yiv3719309089ygrp-text {font-family:Georgia;}#yiv3719309089 #yiv3719309089ygrp-text p {margin:0 0 1em 0;}#yiv3719309089 #yiv3719309089ygrp-text tt {font-size:120%;}#yiv3719309089 #yiv3719309089ygrp-vital ul li:last-child {border-right:none !important;}#yiv3719309089

Fri May 4, 2018 9:53 am (PDT) . Posted by:

"mlazarus"

What function and parameters do I use to retrieve the name of the
stock? TIA.

-mark

Fri May 4, 2018 10:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The best way to get a number of them would be to use
smfGetYahooPortfolioView().

On Fri, May 4, 2018 at 9:03 AM, mlazarus mlazarus@
​...
wrote:

> What function and parameters do I use to retrieve the name of the
> stock? TIA.
>
>

Fri May 4, 2018 10:11 am (PDT) . Posted by:

rr76012

Error 621 S YahooAE Earnings Growth Rates -- Next 5 Years -- Company SMF-Template-Yahoo-Analyst-Estimates.xls 2017-04-26





Hello Randy,


5-4-2017


re: fyi


the eps growth rate of "621" may have an error?


I think this rchGetElementNumber "621" is no longer working.


rr76012



Fri May 4, 2018 10:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's working here. You probably need the updated element definitions?

https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html

*Date* *Routine* *Description*
2018-04-18 RCHGetElement Updated Yahoo Analyst Elements for web page
changes -- #601-624, obsoleted #669-672, added #726-729

On Fri, May 4, 2018 at 10:10 AM, rr76012@
​...
wrote:

>
> Error 621 S YahooAE Earnings Growth Rates -- Next 5 Years -- Company
> SMF-Template-Yahoo-Analyst-Estimates.xls 2017-04-26
>
> 5-4-2017
>
> re: fyi
>
> the eps growth rate of "621" may have an error?
>
> I think this rchGetElementNumber "621" is no longer working.
>
>
>

Fri May 4, 2018 10:35 am (PDT) . Posted by:

rr76012

Hi Randy


re: rchgetelementnumber 624 - the 5 Year Growth Rate


2 questions


I just updated the whole smf-addin;
1st - I deleted the old smf-addin
2cnd - i downloaded the latest smf-addin
and extracted it.
Basically I replace the old smf-addin.


Did I do this the right way?


Second from reading you email, I guess I could have just updated the element definitions?


How do I just update the element definitions? What are the steps Please?


Computers are so very sophisticated and technical.


After downloading the latest smf-addin, I still can not get rchGetElementNumber "624" to work?


I get an "Error" in the cell = rchGetElementNumber("IBM",624)


Thanks


Fri May 4, 2018 10:43 am (PDT) . Posted by:

"Yahoo!" lewglenn

Link doesn't work.


On Friday, May 4, 2018, 10:26:40 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

It's working here. You probably need the updated element definitions?
https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html

| Date | Routine | Description |
| 2018-04-18 | RCHGetElement | Updated Yahoo Analyst Elements for web page changes -- #601-624, obsoleted #669-672, added #726-729 |

On Fri, May 4, 2018 at 10:10 AM, rr76012@​... wrote:

| Error | 621 | S | YahooAE | Earnings Growth Rates -- Next 5 Years -- Company | SMF-Template-Yahoo-Analyst- Estimates.xls | 2017-04-26 |

5-4-2017
re: fyi
the eps growth rate of "621" may have an error?
I think this rchGetElementNumber "621" is no longer working.

#yiv5031387164 #yiv5031387164 -- #yiv5031387164ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5031387164 #yiv5031387164ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5031387164 #yiv5031387164ygrp-mkp #yiv5031387164hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5031387164 #yiv5031387164ygrp-mkp #yiv5031387164ads {margin-bottom:10px;}#yiv5031387164 #yiv5031387164ygrp-mkp .yiv5031387164ad {padding:0 0;}#yiv5031387164 #yiv5031387164ygrp-mkp .yiv5031387164ad p {margin:0;}#yiv5031387164 #yiv5031387164ygrp-mkp .yiv5031387164ad a {color:#0000ff;text-decoration:none;}#yiv5031387164 #yiv5031387164ygrp-sponsor #yiv5031387164ygrp-lc {font-family:Arial;}#yiv5031387164 #yiv5031387164ygrp-sponsor #yiv5031387164ygrp-lc #yiv5031387164hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5031387164 #yiv5031387164ygrp-sponsor #yiv5031387164ygrp-lc .yiv5031387164ad {margin-bottom:10px;padding:0 0;}#yiv5031387164 #yiv5031387164actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5031387164 #yiv5031387164activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5031387164 #yiv5031387164activity span {font-weight:700;}#yiv5031387164 #yiv5031387164activity span:first-child {text-transform:uppercase;}#yiv5031387164 #yiv5031387164activity span a {color:#5085b6;text-decoration:none;}#yiv5031387164 #yiv5031387164activity span span {color:#ff7900;}#yiv5031387164 #yiv5031387164activity span .yiv5031387164underline {text-decoration:underline;}#yiv5031387164 .yiv5031387164attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5031387164 .yiv5031387164attach div a {text-decoration:none;}#yiv5031387164 .yiv5031387164attach img {border:none;padding-right:5px;}#yiv5031387164 .yiv5031387164attach label {display:block;margin-bottom:5px;}#yiv5031387164 .yiv5031387164attach label a {text-decoration:none;}#yiv5031387164 blockquote {margin:0 0 0 4px;}#yiv5031387164 .yiv5031387164bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5031387164 .yiv5031387164bold a {text-decoration:none;}#yiv5031387164 dd.yiv5031387164last p a {font-family:Verdana;font-weight:700;}#yiv5031387164 dd.yiv5031387164last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5031387164 dd.yiv5031387164last p span.yiv5031387164yshortcuts {margin-right:0;}#yiv5031387164 div.yiv5031387164attach-table div div a {text-decoration:none;}#yiv5031387164 div.yiv5031387164attach-table {width:400px;}#yiv5031387164 div.yiv5031387164file-title a, #yiv5031387164 div.yiv5031387164file-title a:active, #yiv5031387164 div.yiv5031387164file-title a:hover, #yiv5031387164 div.yiv5031387164file-title a:visited {text-decoration:none;}#yiv5031387164 div.yiv5031387164photo-title a, #yiv5031387164 div.yiv5031387164photo-title a:active, #yiv5031387164 div.yiv5031387164photo-title a:hover, #yiv5031387164 div.yiv5031387164photo-title a:visited {text-decoration:none;}#yiv5031387164 div#yiv5031387164ygrp-mlmsg #yiv5031387164ygrp-msg p a span.yiv5031387164yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5031387164 .yiv5031387164green {color:#628c2a;}#yiv5031387164 .yiv5031387164MsoNormal {margin:0 0 0 0;}#yiv5031387164 o {font-size:0;}#yiv5031387164 #yiv5031387164photos div {float:left;width:72px;}#yiv5031387164 #yiv5031387164photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5031387164 #yiv5031387164photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5031387164 #yiv5031387164reco-category {font-size:77%;}#yiv5031387164 #yiv5031387164reco-desc {font-size:77%;}#yiv5031387164 .yiv5031387164replbq {margin:4px;}#yiv5031387164 #yiv5031387164ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5031387164 #yiv5031387164ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5031387164 #yiv5031387164ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5031387164 #yiv5031387164ygrp-mlmsg select, #yiv5031387164 input, #yiv5031387164 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5031387164 #yiv5031387164ygrp-mlmsg pre, #yiv5031387164 code {font:115% monospace;}#yiv5031387164 #yiv5031387164ygrp-mlmsg * {line-height:1.22em;}#yiv5031387164 #yiv5031387164ygrp-mlmsg #yiv5031387164logo {padding-bottom:10px;}#yiv5031387164 #yiv5031387164ygrp-msg p a {font-family:Verdana;}#yiv5031387164 #yiv5031387164ygrp-msg p#yiv5031387164attach-count span {color:#1E66AE;font-weight:700;}#yiv5031387164 #yiv5031387164ygrp-reco #yiv5031387164reco-head {color:#ff7900;font-weight:700;}#yiv5031387164 #yiv5031387164ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5031387164 #yiv5031387164ygrp-sponsor #yiv5031387164ov li a {font-size:130%;text-decoration:none;}#yiv5031387164 #yiv5031387164ygrp-sponsor #yiv5031387164ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5031387164 #yiv5031387164ygrp-sponsor #yiv5031387164ov ul {margin:0;padding:0 0 0 8px;}#yiv5031387164 #yiv5031387164ygrp-text {font-family:Georgia;}#yiv5031387164 #yiv5031387164ygrp-text p {margin:0 0 1em 0;}#yiv5031387164 #yiv5031387164ygrp-text tt {font-size:120%;}#yiv5031387164 #yiv5031387164ygrp-vital ul li:last-child {border-right:none !important;}#yiv5031387164

Fri May 4, 2018 10:58 am (PDT) . Posted by:

"ThadDz" thadqda

Text for link is correct; hyperlink has a double-period. Try:

https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html

From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Sent: Friday, May 04, 2018 11:39 AM
To: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] rchgetElementNumber "621" not working

Link doesn't work.

On Friday, May 4, 2018, 10:26:40 AM PDT, Randy Harmelink rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

It's working here. You probably need the updated element definitions?

https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html <https://smf-add-in..blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html>

Date

Routine

Description

2018-04-18

RCHGetElement

Updated Yahoo Analyst Elements for web page changes -- #601-624, obsoleted #669-672, added #726-729

On Fri, May 4, 2018 at 10:10 AM, rr76012@

​...

wrote:

Error

621

S

YahooAE

Earnings Growth Rates -- Next 5 Years -- Company

SMF-Template-Yahoo-Analyst- Estimates..xls

2017-04-26

5-4-2017

re: fyi

the eps growth rate of "621" may have an error?

I think this rchGetElementNumber "621" is no longer working.

Fri May 4, 2018 11:04 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Strange. If I go to the posting in the Yahoo group, that link does work. So
your email client or the message mailed to you from Yahoo must have
inserted an extra period into the link?

On Fri, May 4, 2018 at 10:39 AM, Yahoo! lewglenn@
​...
wrote:

>
> Link doesn't work.
>
>

Fri May 4, 2018 11:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Reinstalling the ZIP file won't do it. The ZIP file won't contain element
definitions changed after it was released. I only do a new ZIP file if the
add-in itself changes. One of the reasons I externalized all of the element
definitions is so that they would be easier to update independently of the
add-in.

Steps to update element definitions:

1. Exit EXCEL
2. Download new element definition file from the web site, replacing the
one in your add-in folder.
3. Restart EXCEL.

On Fri, May 4, 2018 at 10:35 AM, rr76012@
​...
wrote:

>
> re: rchgetelementnumber 624 - the 5 Year Growth Rate
>
> 2 questions
>
> I just updated the whole smf-addin;
> 1st - I deleted the old smf-addin
> 2cnd - i downloaded the latest smf-addin
> and extracted it.
> Basically I replace the old smf-addin.
>
> Did I do this the right way?
>
> Second from reading you email, I guess I could have just updated the
> element definitions?
>
> How do I just update the element definitions? What are the steps Please?
>
> Computers are so very sophisticated and technical.
>
> After downloading the latest smf-addin, I still can not get
> rchGetElementNumber "624" to work?
>
> I get an "Error" in the cell = rchGetElementNumber("IBM",624)
>
>
>

Fri May 4, 2018 11:19 am (PDT) . Posted by:

rr76012

Randy,


Thank You, I was sweating it could not get anything to work.


Now it is working.


I have learned to ask you for specific steps otherwise I get lost and do not know what to do.


again thanks


rr76012

Fri May 4, 2018 11:06 am (PDT) . Posted by:

rr76012

Hello Randy,


I changed the smf-addin to the latest Version.
now all my excel files have this in the cells:


cells " ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,624)"


I tried to go to excel -> Data -> Edit Links -> Change Source -> This PC-OS(C): Program Files - SMF Add-in
then clicked "RCH_STock_MarketFunctions.xla


What am I doing wrong?


Thanks,


rr76012


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar