Selasa, 16 Mei 2017

[smf_addin] Digest Number 4007

15 Messages

Digest #4007
1a
Re: Help with MS Category ratings by "Randy Harmelink" rharmelink
2b
Re: RCHGetYahooHistory Not Working? by "John Yard" johnwyard
2c
Re: RCHGetYahooHistory Not Working? by "Craig Passow" passow
2f
Re: RCHGetYahooHistory Not Working? by "Randy Harmelink" rharmelink
2j
Re: RCHGetYahooHistory Not Working? by "Randy Harmelink" rharmelink
2l
Re: RCHGetYahooHistory Not Working? by "Randy Harmelink" rharmelink

Messages

Mon May 15, 2017 11:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t=
"&$C6,"span",-1,"vkey=""TotalAssets""",,,,1)

=smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t=
"&$C6,"span",-1,"vkey=""FeeLevel""")

=smfConvertData(smfStrExtr(RCHGetWebData("
http://www.morningstar.com/funds/XNAS/
"&$C6&"/quote.html";,"""starRating"":"),":",","))

On Fri, May 12, 2017 at 7:57 AM, joel.andrews@
​...wrote:

> Randy, thanks so much for the information. The code works great and I
> soo appreciate your help!
>
> I've been looking on the M* Quicktake print report and can't find the
> following data fields I would like to use. They are all located in the M*
> "Quote" tab.
>
> Total assets of the fund
>
> Fee level
>
> - and, of course, the M* rating which I know has been hard to obtain
>
> I've looked at your elements-4 text file but don't see any references to
> the "quote" tab or I would be able to fiddle with that.
>
> Any help would be really appreciated!
>
> Thanks again for much. I am indebted to you for your service!
>
>

Tue May 16, 2017 9:32 am (PDT) . Posted by:

jeff_fulkerson

Is anyone else having issues with the =RCHGetYahooHistory command starting yesterday? The command worked up to and including Friday, 5/12/2017, but it seems to have stopped working. I am unable to get history if I plug in yesterday's date (5/15/2017), but if I put in Friday's date (5/12/2017) it works fine.


Here is the actual command I am using:
=RCHGetYahooHistory(A12,2017,5,12,2017,5,12,, "c",0)



The above command works fine and returns the closing price for 5/12, but if I change the date to 15, it is blank.


Any ideas? Thanks!



Tue May 16, 2017 9:38 am (PDT) . Posted by:

"John Yard" johnwyard

using a different retreival program, the latest yahoo data I can download
in friday's

On Tue, May 16, 2017 at 9:32 AM, jeff_fulkerson@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Is anyone else having issues with the =RCHGetYahooHistory command
> starting yesterday? The command worked up to and including Friday,
> 5/12/2017, but it seems to have stopped working. I am unable to get history
> if I plug in yesterday's date (5/15/2017), but if I put in Friday's date
> (5/12/2017) it works fine.
>
>
> Here is the actual command I am using:
>
> =RCHGetYahooHistory(A12,2017,5,12,2017,5,12,, "c",0)
>
>
> The above command works fine and returns the closing price for 5/12, but
> if I change the date to 15, it is blank.
>
>
> Any ideas? Thanks!
>
>
>
>

Tue May 16, 2017 9:49 am (PDT) . Posted by:

"Craig Passow" passow

The add-in can only retrieve what Yahoo provides, so check your data
source. All of the most recent historical data available on Yahoo
appears to be incorrectly labeled May 16, 2017 instead of May 15, 2017.

AAPL Historical Data <https://finance.yahoo.com/quote/AAPL/history?p=AAPL>

On 5/16/2017 11:38 AM, John Yard johnwyard@gmail.com [smf_addin] wrote:
>
> using a different retreival program, the latest yahoo data I can
> download in friday's
>
> On Tue, May 16, 2017 at 9:32 AM, jeff_fulkerson@yahoo.com
> <mailto:jeff_fulkerson@yahoo.com> [smf_addin]
> <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>> wrote:
>
>
>
> Is anyone else having issues with the =RCHGetYahooHistory command
> starting yesterday? The command worked up to and including Friday,
> 5/12/2017, but it seems to have stopped working. I am unable to
> get history if I plug in yesterday's date (5/15/2017), but if I
> put in Friday's date (5/12/2017) it works fine.
>
>
> Here is the actual command I am using:
>
> =RCHGetYahooHistory(A12,2017,5,12,2017,5,12,, "c",0)
>
>
> The above command works fine and returns the closing price for
> 5/12, but if I change the date to 15, it is blank.
>
>
> Any ideas? Thanks!
>
>
>
>

Tue May 16, 2017 10:45 am (PDT) . Posted by:

tonyestep

On this same topic: is there another source of historical prices like Yahoo that we can use as a backup?? The Yahoo database just doesn't have anything for yesterday.

Tue May 16, 2017 11:40 am (PDT) . Posted by:

john_hoel

I gave up on Yahoo and switched to Marketwatch, like this:

=RCHGetTableCell("http://bigcharts.marketwatch.com/historical/default.asp?symb="&F$7&"&closeDate="&TEXT(E8,"mm/dd/yyyy"),1,"Closing Price:")

Tue May 16, 2017 12:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Google Finance work-around:

=smfGetCSVFile("https://www.google.com/finance/historical?q=
"&B6&"&startdate="&TEXT(C6,"mmm+dd,+yyyy&quot;)&"&enddate="&TEXT(D6,"mmm+dd,+yyyy&quot;)&"&output=csv";)

...where:

B6 = Ticker symbol
C6 = Starting date (as EXCEL serial date)
D6 = Ending date (as EXCEL serial date)

Not sure what Yahoo will end up with after all their changes. It appears to
be a work in progress...

On Tue, May 16, 2017 at 10:45 AM, tonyestep@
​...wrote:

>
> On this same topic: is there another source of historical prices like
> Yahoo that we can use as a backup?? The Yahoo database just doesn't have
> anything for yesterday.
>
>

Tue May 16, 2017 1:08 pm (PDT) . Posted by:

jeff_fulkerson

Thanks Randy. I will give that a try tonight.

Tue May 16, 2017 2:01 pm (PDT) . Posted by:

jeff.pietsch

Except no split/dividend adjustments, right? New yahoo query1 doesn't look too tricky other than some unix date codes and a 'crumb&#39; whose purpose I'm not clear on... maybe a server session limiter?

Tue May 16, 2017 2:13 pm (PDT) . Posted by:

rr76012



re: rchgetyahoohistory and google work around


Randy,


for rchgetyahoohistory; can your google suggestion download monthly data? or only daily?


rr76012

Tue May 16, 2017 2:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not aware of a weekly or monthly option with the Google quotes. And
they don't have adjusted prices.

On Tue, May 16, 2017 at 2:13 PM, rr76012@
​...wrote:

>
> re: rchgetyahoohistory and google work around
>
> for rchgetyahoohistory; can your google suggestion download monthly data?
> or only daily?
>
>
>

Tue May 16, 2017 2:26 pm (PDT) . Posted by:

rr76012

thanks Randy,


I think I will take a breather for a day or 2, and hope we get our rchgetyahoohistory back up and running soon.


thanks randy...

Tue May 16, 2017 2:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, the new query doesn't return anything to the add-in. Just an
empty string. It may check the "referrer"; to see if data should be sent.
The new beta version of Morningstar has also moved to a secure API.

On Tue, May 16, 2017 at 1:26 PM, jgpietsch@
​...wrote:

>
> Except no split/dividend adjustments, right? New yahoo query1 doesn't look
> too tricky other than some unix date codes and a 'crumb&#39; whose purpose I'm
> not clear on... maybe a server session limiter?
>

Tue May 16, 2017 3:37 pm (PDT) . Posted by:

tonyestep

So what do you think is going to happen, Randy? Is Yahoo trying to fix it so we can't get historical prices? And if so, what alternatives would there be?? I did get the Google call to work -- thank you! But this is shaping up to be a major problem for me.

Tue May 16, 2017 3:50 pm (PDT) . Posted by:

tonyestep

When I go manually to https://ichart.finance.yahoo.com/ https://ichart.finance.yahoo.com/ I get the message "Yahoo will be right back. Our engineers are working to fix the problem." What do you suppose this means?!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 15.50

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)