Kamis, 02 November 2017

[smf_addin] Digest Number 4194

15 Messages

Digest #4194
1a
Re: smfPricesByDates by "Randy Harmelink" rharmelink
4b
Re: Using smfGetYahooPortfolioView by "Randy Harmelink" rharmelink
5.2
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink
5.5
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink
5.6
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink

Messages

Thu Nov 2, 2017 11:19 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's on the web site:

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

On Thu, Nov 2, 2017 at 11:13 AM, midhenry1@
​...
wrote:

>
> Is there a version of Stock Market Functions add-in, beyond Version
> 2.1.2017.10.24?
>
> If so, how can I find it?
>
>
>

Thu Nov 2, 2017 11:34 am (PDT) . Posted by:

john_hoel

Much better. Now it works and is lightning fast. Thank you Randy.

Thu Nov 2, 2017 11:46 am (PDT) . Posted by:

rr76012

Hello Randy,


Just updated your smf addin.


I know have this in the cells: ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("MMM";,"l1")


Do you know a quick fix to fix all the cells with ='C:\Program\Files\SMF Add-in\RCH_StockMarket_Functions.xla! now in the cells?




Randy, Thanks
rr76012


Thu Nov 2, 2017 11:49 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try running the smfFixLinks macro to fix the links. I have it attached to a
button on my Quick Access Toolbar.

Looks like you moved the location of the add-in when you updated?

On Thu, Nov 2, 2017 at 11:46 AM, rr76012@
​....
wrote:

> Just updated your smf addin.
>
> I know have this in the cells: ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("MMM";,"l1")
>
> Do you know a quick fix to fix all the cells with ='C:\Program\Files\SMF
> Add-in\RCH_StockMarket_Functions.xla! now in the cells?
>
>
>

Thu Nov 2, 2017 12:32 pm (PDT) . Posted by:

"Bob Greene" greenerd2001

Thanks for your Hard work!!!

Noticed the Stock Quote App also yields no data, must be related to the "quotes" problem

Bob

Sent from Mail for Windows 10

From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Thursday, November 2, 2017 1:49 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("MMM";,"l1")

 
Try running the smfFixLinks macro to fix the links. I have it attached to a button on my Quick Access Toolbar.

Looks like you moved the location of the add-in when you updated?

On Thu, Nov 2, 2017 at 11:46 AM, rr76012@
​....
 wrote:
Just updated your smf addin.
I know have this in the cells: ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("MMM";,"l1")
Do you know a quick fix to fix all the  cells with ='C:\Program\Files\SMF Add-in\RCH_StockMarket_Functions.xla! now in the cells?

Thu Nov 2, 2017 12:43 pm (PDT) . Posted by:

bob_15861586

I tired your example in a spread sheet and I got the word symbol and I did not get any values. What am I doing wrong?

Bob

Thu Nov 2, 2017 12:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to array-enter it over a range. See:

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

On Thu, Nov 2, 2017 at 12:43 PM, bob_15861586@
​...
wrote:

>
> I tired your example in a spread sheet and I got the word symbol and I did
> not get any values. What am I doing wrong?
>
>
>

Thu Nov 2, 2017 12:51 pm (PDT) . Posted by:

tonyestep

Well, it still doesn't work for me. I downloaded the 11/2 10 a.m. version of the .XLA, uninstalled the old Add-In, reloaded the new Add-In into Excel, rebooted, and generally tried everything I could think of to make sure that I'm running the corrected new version. However, the following simple formula


=RCHGetYahooQuotes("SPY","L1")


returns a blank cell.

Thu Nov 2, 2017 12:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() will not work until Yahoo starts providing the CSV file
again...

The update was for the smfGetYahooPortfolioView() function, a workaround or
alternative until Yahoo fixes the CSV file.

On Thu, Nov 2, 2017 at 12:51 PM, tonyestep@
​...
wrote:

>
> Well, it still doesn't work for me. I downloaded the 11/2 10 a.m. version
> of the .XLA, uninstalled the old Add-In, reloaded the new Add-In into
> Excel, rebooted, and generally tried everything I could think of to make
> sure that I'm running the corrected new version. However, the following
> simple formula
>
> =RCHGetYahooQuotes("SPY","L1")
>
> returns a blank cell.
>

Thu Nov 2, 2017 1:13 pm (PDT) . Posted by:

dleeper47

Hi, Randy - -

I'm only getting "Error" when I ask for quotes. I think the new add-in is working, because I do get
Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\Program Files\SMF Add-In2; Windows (32-bit) NT 6.02; 14.0; ; ; 1)


From this thread of questions & answers, I infer that the problem is at Yahoo -- is that correct?


If so, I'll quit messing around and just try again later.


Your SMF add-in has worked for me trouble-free for over a year -- looking forward to getting it going again -- I'm really dependent on it!


Thanks,


David Leeper
Scottsdale, AZ
dleeper@mail.com


Thu Nov 2, 2017 1:30 pm (PDT) . Posted by:

rotsevni_eulav

Randy,

I entered the following in an array from b1:b68


=smfGetYahooPortfolioView(a2:a68,"15",,1) where a2:a68 contain ticker symbols. Prices were downloaded for the first 36 ticker symbols, but then blanks for the remainder. Is there a size limit on the number of rows?

Thu Nov 2, 2017 1:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What formula and parameters are you using?

Yahoo has indicated their current quotes API has been discontinued (i.e.
RCHGetYahooQuotes()).

On Thu, Nov 2, 2017 at 1:13 PM, dleeper@mail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm only getting "Error" when I ask for quotes. I think the new add-in is
> working, because I do get
> Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\Program
> Files\SMF Add-In2; Windows (32-bit) NT 6.02; 14.0; ; ; 1)
>
> From this thread of questions & answers, I infer that the problem is at
> Yahoo -- is that correct?
>
> If so, I'll quit messing around and just try again later.
>
> Your SMF add-in has worked for me trouble-free for over a year -- looking
> forward to getting it going again -- I'm really dependent on it!
>
>
>

Thu Nov 2, 2017 1:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Are you using the 2017.11.02 version of the add-in? I rewrote the
smfGetYahooPortfolioView() function. The old version did have a low limit
on the number of tickers that could be returned (based on file length)...

On Thu, Nov 2, 2017 at 1:30 PM, mikebissell@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I entered the following in an array from b1:b68
>
> =smfGetYahooPortfolioView(a2:a68,
> <https://maps.google.com/?q=a68,%2215&entry=gmail&source=g>"15
> <https://maps.google.com/?q=a68,%2215&entry=gmail&source=g>",,1) where
> a2:a68 contain ticker symbols. Prices were downloaded for the first 36
> ticker symbols, but then blanks for the remainder. Is there a size limit on
> the number of rows?
>

Thu Nov 2, 2017 1:57 pm (PDT) . Posted by:

rotsevni_eulav

Installed latest version and now all OK. Thanks for your help and effort!

Thu Nov 2, 2017 2:02 pm (PDT) . Posted by:

rho49m

I have a strange problem, I used SMF to update a Excel spreadsheet of stock holdings. This worked with an array for years. Today the spreadsheets don't download data, Nothing happens at all. If I enter =RCHGetYahooQuotes("IBM") in a data cell nothing happens. I have tried the obvious, downloaded the latest ,zip file 02-11-17, tried to re enable the add-in in excel, which seemed to indicate the plugin was installed.
Any idea what I should do next?

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)