Kamis, 02 November 2017

[smf_addin] Digest Number 4196

15 Messages

Digest #4196
2a
Currencies by peterebali
2b
Re: Currencies by "Randy Harmelink" rharmelink
3c
Re: Additional data sources instead of Yahoo by "Randy Harmelink" rharmelink
4.2
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink
4.5
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink
5a
Re: Yahoo quotes by "Randy Harmelink" rharmelink
6a
Re: Update - by "Mark Danner" paladin306@att.net
6b
Re: Update - by "Randy Harmelink" rharmelink

Messages

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

indinvestor111

Thanks for the help, Randy!

The workaround works great! that said, it's really quite disappointing that they shut down the API.

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

peterebali



I previously used RCHGetYahooQuotes() to retrieve currency exchange rates. Is there any way for smfGetYahooPortfolioView to retrieve these currencies.


GBPUSD=X
AUDGBP=X
AUDUSD=X
USDIDR=X

AUDIDR=X


Thanks for all your assistance, much greatly appreciated.


Thanks....Peter

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

"Randy Harmelink" rharmelink

I'll have to look at it. When I try it, some work, some don't. The pattern
seems to be whether USD is one of the two.

I use the "language"; field to parse lines, but they may not be present on
non-USD conversion quotes? Maybe I can use a different line delimiter.

On Thu, Nov 2, 2017 at 3:05 PM, peterejkt@
​...
wrote:

> I previously used RCHGetYahooQuotes() to retrieve currency exchange rates.
> Is there any way for smfGetYahooPortfolioView to retrieve these currencies.
>
> GBPUSD=X
>
> AUDGBP=X
>
> AUDUSD=X
>
> USDIDR=X
>
> AUDIDR=X
> Thanks for all your assistance, much greatly appreciated.
>
>
>

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

peterebali

Seems like some currency pairs don't work as they did previously. I can work around using combinations of other pairs, but strange that they don't work now.

AUDGBP=X AUDIDR=X


Thanks for all your assistance.


Regards... Peter

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

"Randy Harmelink" rharmelink

The current line parsing appears to require a USD partner. Working on it.

On Thu, Nov 2, 2017 at 3:44 PM, peterejkt@
​...
wrote:

>
> Seems like some currency pairs don't work as they did previously. I can
> work around using combinations of other pairs, but strange that they don't
> work now.
>
> AUDGBP=X
> AUDIDR=X
>
> Thanks for all your assistance.
>
>
>

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

weldenc

I eventually figured out my problem. Now I am trying figure out a problem with some stock symbols, like HASI, If you add it, you can no longer add more symbols below. If you remove it, you can continue to add more stock symbols

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

"Randy Harmelink" rharmelink

Are you using the 2017.11.02 version? That sounds like an issue on the
2017.10.24 version. HASI seems to be working for me, even in first position.

=RCHGetElementNumber("Version")

*Ticker Symbol* *Symbol* *Long Name*
HASI HASI Hannon Armstrong Sustainable Infrastructure Capital, Inc.
SPY SPY SPDR S&P 500 ETF
SPY191220C00260000 SPY191220C00260000 --
MMM MMM 3M Company
IBM IBM International Business Machines Corporation
-- --

On Thu, Nov 2, 2017 at 3:44 PM, weldencd@
​...
wrote:

>
> I eventually figured out my problem. Now I am trying figure out a problem
> with some stock symbols, like HASI, If you add it, you can no longer add
> more symbols below. If you remove it, you can continue to add more stock
> symbols
>

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

raiders8112

Where can I get a copy of the 11.2.17 version? I did not see it listed in the "Files" section.

Thanks

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

"Randy Harmelink" rharmelink

On the main website:

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

On Thu, Nov 2, 2017 at 4:26 PM, mike.russo@
​...
wrote:

>
> Where can I get a copy of the 11.2.17 version? I did not see it listed in
> the "Files" section.
>
>
>

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

mikemcq802

Yahoo has updated their error message. It is no longer a generic 999 when trying to use http://download.finance.yahoo.com/d/quotes.csv, it is:

"It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com."

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

"Randy Harmelink" rharmelink

Which version of the add-in are you using? The smfGetYahooPortfolioView()
function has been around for years.

=RCHGetElementNumber("Version")

On Thu, Nov 2, 2017 at 3:00 PM, smmarder@
​...
wrote:

>
> I just tried that and the return in the cell was : "#NAME?"
>
>
>

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

"Mark Danner" paladin306@att.net

Randy, first and foremost, thanks for all the countless hours that you have spent writing, updating your SMF program.

Secondly, I assume dead means dead? I tried your November 2, update hoping against hope that it would somehow get around the ridiculous red tape of Yahoo. But, such was not the case. Of course, that doesn't mean I have it installed properly but, I believe I have that part correctly.

Mark

> On Jan 8, 2017, at 9:00 PM, Mark Danner <paladin306@att.net> wrote:
>
> Howdy Randy,
>
> You don't know me from a decimal point. But, I've used your SMF add-in for several years now and I'd just like to say I'm sorry to hear about your recent health problems. I've been there and done that and it most certainly is no fun. First and foremost take care of yourself and we'll put you in our prayers.
>
> Mark
>
>> On Jan 8, 2017, at 4:14 PM, rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>> wrote:
>>
>> Had to go to the ER yesterday. I'll be back online when I am able to.
>>
>>
>>
>>
>>
>

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

"Randy Harmelink" rharmelink

It certainly appears dead at this point.

Are you saying the smfGetYahooPortfolioView() template isn't working for
you, with the 2017.11.02 version of the add-in?

On Thu, Nov 2, 2017 at 5:53 PM, Mark Danner paladin306@
​...
wrote:

>
> Randy, first and foremost, thanks for all the countless hours that you
> have spent writing, updating your SMF program.
>
> Secondly, I assume dead means dead? I tried your November 2, update
> hoping against hope that it would somehow get around the ridiculous red
> tape of Yahoo. But, such was not the case. Of course, that doesn't mean I
> have it installed properly but, I believe I have that part correctly.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar