Sabtu, 14 April 2018

[smf_addin] Digest Number 4322

15 Messages

Digest #4322
1a
Re: Unsubscribe by "Kermit W. Prather" kermitpra
3a
getting "ERROR" by rod_archer
3b
Re: getting "ERROR" by "Randy Harmelink" rharmelink
3c
Re: getting "ERROR" by rod_archer
3d
Re: getting "ERROR" by "Randy Harmelink" rharmelink
4b
Re: Getting data from gurufocus by "Randy Harmelink" rharmelink

Messages

Wed Apr 11, 2018 1:49 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

If I remember correctly that unsubscribe will remove her from the yahoo group.
They unsubscribe using the email address that makes the request not the one she wants removed.


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, April 11, 2018 12:37 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Unsubscribe


Why not just use the unsubscribe link at the bottom of every group message?

On 4/11/2018 10:43 AM, 'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin] wrote:

Somehow you have subscribed to the yahoo group
Try one of these 3 methods to unsubscribe:
I have not used any of them so I can't be sure they work but worth a try.


Unsubscribe From Emails | Instantly With One Click‎ <https://join.unroll.me/?utm_campaign=google2018>
Adjoin.unroll.me/‎
· Ditch the emails you don't want. Keep the ones you do. Get started today!
Download App · Sign Up Online
* FAQs <https://unroll.me/faq/>
* Software Features <https://unroll.me/features/>
* Support Center <https://support.unroll.me/hc/en-us>
* Get Mobile App <https://unroll.me/app/>
* Log In <https://unroll.me/a/login>
· How Do I Unsubscribe | Search How Do I Unsubscribe.‎ <https://www.informationvine.com/index?qsrc=999&qo=semQuery&ad=semD&o=603851&l=sem&askid=ff423ece-7a81-4baa-b75a-d3b0fda6ce83-0-iv_gsb&q=how%20do%20i%20unsubscribe&dqi=&am=broad&an=google_s>
Adwww.informationvine.com/Answers‎
· How Do I Unsubscribe.
Quick & Easy Answers · Find Relevant Information
· Mass Unsubscribe Email Tool | Get <https://getunsubscriber.com/> Unsubscriber‎
Adwww.getunsubscriber.com/‎
Fast and Free Email Plugin. Remove and Prevent Unwanted Email.
Under 1 Minute to Sign Up · It's Free! · Fast & Easy To Install · Over 6 Million Users

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 10, 2018 9:53 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Unsubscribe


I have no idea why I keep getting these emails and I also don't know how to make them stop.

Please help

Sent from Yahoo Mail for iPhone <https://overview.mail.yahoo.com/?.src=iOS>

Thu Apr 12, 2018 11:53 pm (PDT) . Posted by:

beatnut8827

Had a look thru the forum at people with a similar problem. Removed an earlier version in a different location. Installed current version in C:\SMF Add-in and excel loaded it OK after quite a bit of linking and changing source for xla. Looked for the fixlinks macro but there are no macros listed in the macro window.
Just using the history by example to try to get this working but all to no avail.
any help appreciated!!
Neil

Fri Apr 13, 2018 12:08 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The macro window only shows macros from open workbooks, not those in
add-ins. You need to type in the name of smfFixLinks yourself, then all of
the click boxes should become active..

It's also an available option on the context menu (right-click menu).

On Thu, Apr 12, 2018 at 11:53 PM, neil@
​...
wrote:

> Had a look thru the forum at people with a similar problem. Removed an
> earlier version in a different location. Installed current version in
> C:\SMF Add-in and excel loaded it OK after quite a bit of linking and
> changing source for xla. Looked for the fixlinks macro but there are no
> macros listed in the macro window.
>
> Just using the history by example to try to get this working but all to no
> avail.
>
> any help appreciated!!
>
>
>

Fri Apr 13, 2018 10:30 pm (PDT) . Posted by:

beatnut8827

Thanks Randy. However after running the fix I still have the same problem. Using Excel 2016. Neil

Sat Apr 14, 2018 12:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'll need more details. What does the formula look like that returns #NAME?

On Fri, Apr 13, 2018 at 10:30 PM, neil@
​...
wrote:

>
> Thanks Randy. However after running the fix I still have the same problem.
> Using Excel 2016.
>
>

Sat Apr 14, 2018 12:12 am (PDT) . Posted by:

beatnut8827

Ok. I am just using RCHGetYahooHistory-Example-By-Parameters.xls to get the app working. So the formula is as in the original spreadsheet... =RCHGetYahooHistory(C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13)

Neil


Sat Apr 14, 2018 12:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to give me more context when asking about problem or issues...

Yahoo also unplugged their historical quotes CSV process and replaced it at
the same time they removed the current quotes CSV file.
RCHGetYahooHistory() should still work, but not for all parameter
combinations. They've put the CSV file behind a cookie and an API code
value now, so it's more difficult to get.

Instead, you should use smfGetYahooHistory(), which gets the data from a
JSON file they produce. Documentation and template are on the web site.

On Sat, Apr 14, 2018 at 12:12 AM, neil@
​...
wrote:

>
> Ok. I am just using RCHGetYahooHistory-Example-By-Parameters..xls to get
> the app working. So the formula is as in the original spreadsheet...
> =RCHGetYahooHistory(C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13)
>
>

Sat Apr 14, 2018 1:45 am (PDT) . Posted by:

beatnut8827

oh, OK. Can't find the template - only the one I already have. Also, a previous spreadsheet I created that used RCHGetYahooQuotes fails to fetch any data Neil

Sat Apr 14, 2018 2:08 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo unplugged the data sources for RCHGetYahooQuotes() and
RCHGetYahooHistory() last year..

Their replacements:

http://ogres-crypt.com/SMF/Templates/smfGetYahooPortfolioView-Example.xls

http://ogres-crypt.com/SMF/Templates/smfGetYahooHistory-Example-By-Parameter.xls

On Sat, Apr 14, 2018 at 1:45 AM, neil@
​...
wrote:

>
> oh, OK. Can't find the template - only the one I already have. Also, a
> previous spreadsheet I created that used RCHGetYahooQuotes fails to fetch
> any data
>
>

Fri Apr 13, 2018 12:08 pm (PDT) . Posted by:

rod_archer

Today, after several months not using this add-in, I can't get it to work for me.


The command =RCHGetYahooQuotes(B3,"l1",NOW()) returns ERROR in every cell.


The Command =RCHGetElementNumber("Version&quot;) works correctly showing version 2.1.2018.01.24 and the correct location of the macro files.


The command =smfConvertData("1B") returns 1,000,000


so the add in is working, but not getting data from Yahoo.


I have Internet Explorer open and logged in to my Yahoo account. This has been the trick for me in the past.


Please send some ideas for me to try today.
I run windows 10 and have a Office 365 subscription.


Thanks very much,

Rod

Fri Apr 13, 2018 12:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() has been dead since last November, when Yahoo unplugged
the API that feeds it.

You should use an array-entered smfGetYahooPortfolioView() function. See
the web site for documentation and a template on the function.

On Fri, Apr 13, 2018 at 11:20 AM, rod_archer@
​....
wrote:

> Today, after several months not using this add-in, I can't get it to work
> for me.
>
> The command =RCHGetYahooQuotes(B3,"l1",NOW()) returns ERROR in every cell.
>
> The Command =RCHGetElementNumber("Version&quot;) works correctly showing
> version 2.1.2018.01.24 and the correct location of the macro files.
>
> The command =smfConvertData("1B") returns 1,000,000
>
> so the add in is working, but not getting data from Yahoo.
>
> I have Internet Explorer open and logged in to my Yahoo account. This has
> been the trick for me in the past.
>
> Please send some ideas for me to try today.
>
> I run windows 10 and have a Office 365 subscription.
>
>
>

Fri Apr 13, 2018 1:44 pm (PDT) . Posted by:

rod_archer

Thank you Randy, that did work. Sorry for being so far out of date with your tools.


Is it still necessary to have a Yahoo acct open in Internet Explorer for this to work? IE is not my usual browser...

Fri Apr 13, 2018 2:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not aware of the need for a Yahoo account to access their Portfolio
View items.

On Fri, Apr 13, 2018 at 1:44 PM, rod_archer@
​...
wrote:

> Thank you Randy, that did work. Sorry for being so far out of date with
> your tools.
>
> Is it still necessary to have a Yahoo acct open in Internet Explorer for
> this to work? IE is not my usual browser...
>
>

Fri Apr 13, 2018 9:10 pm (PDT) . Posted by:

lawrence.leesh

Hi Randy

Somehow this formula doesn't work on this stock.


=smfStrExtr(smfGetTagContent("https://www.gurufocus.com/stock/shse:600285","div",-1,"Location:"),"</table>","<div",1)



thanks




Sat Apr 14, 2018 12:06 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I can't help -- I don't have a global membership so I can't see
that web page.

On Fri, Apr 13, 2018 at 9:10 PM, lawrence.leesh@
​...
wrote:

>
> Somehow this formula doesn't work on this stock.
>
> =smfStrExtr(smfGetTagContent("https://www.gurufocus.com/stock/shse:600285
> ","div",-1,"Location:"),"</table>","<div",1)
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)