Senin, 10 Agustus 2015

[smf_addin] Digest Number 3482

15 Messages

Digest #3482
1b
Re: GetWebData can't update data timely by "Randy Harmelink" rharmelink
2a
Re: smfgetyahooquotes not working for me? by "Randy Harmelink" rharmelink
2b
Re: smfgetyahooquotes not working for me? by "Randy Harmelink" rharmelink
2c
Re: smfgetyahooquotes not working for me? by "Randy Harmelink" rharmelink
2k
Re: smfgetyahooquotes not working for me? by "Randy Harmelink" rharmelink
3a
Re: Ebay options by sushiwaitress

Messages

Mon Aug 10, 2015 9:12 am (PDT) . Posted by:

Weissinger

Having same issue... clicking on the link for download data gives a Yahoo! - 400 Bad Request return

Mon Aug 10, 2015 9:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Definitely a Yahoo issue then. Not much the add-in can do about that. That
download data link is the same type of link that RCHGetYahooQuotes() is
using to pull the data.

It's apparently not out everywhere?

On Mon, Aug 10, 2015 at 9:08 AM, esmith636@... wrote:

>
> Having same issue... clicking on the link for download data gives a Yahoo!
> - 400 Bad Request return
>

Mon Aug 10, 2015 9:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It appears to be a Yahoo error, since those that can't use
RCHGetYahooQuotes() also can't use the normal download data link on Yahoo's
summary page. So not much the add-in can do about it. Hopefully, Yahoo will
fix it ASAP. You could use their feedback link at the bottom of their web
page and mention the download data link is not working.

On Mon, Aug 10, 2015 at 9:01 AM, richqw@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> The url is returning code 400 and the code is going to the errorexit. The
> function returns the variable verror, which is set to "N/A"
>

Mon Aug 10, 2015 9:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It appears to be a Yahoo error, since those that can't use
RCHGetYahooQuotes() also can't use the normal download data link on Yahoo's
summary page. So not much the add-in can do about it. Hopefully, Yahoo will
fix it ASAP. You could use their feedback link at the bottom of their web
page and mention the download data link is not working.

On Mon, Aug 10, 2015 at 9:02 AM, jim_w_baker@... wrote:

>
> Also having issues. Tried =rchgetyahooquotes("SPY") & it returns ERROR
>

Mon Aug 10, 2015 9:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It appears to be a Yahoo error, since those that can't use
RCHGetYahooQuotes() also can't use the normal download data link on Yahoo's
summary page. So not much the add-in can do about it. Hopefully, Yahoo will
fix it ASAP. You could use their feedback link at the bottom of their web
page and mention the download data link is not working.

On Mon, Aug 10, 2015 at 9:06 AM, rr76012@... wrote:

> Now, like Jimexstock, using your template for smfgetyahooquotes, I too get
> an "ERROR" message instead of just blank?
>
>

Mon Aug 10, 2015 9:57 am (PDT) . Posted by:

richqw

Seems to be working right now. Yea!

Mon Aug 10, 2015 11:34 am (PDT) . Posted by:

rr76012

Hello Richqw,


It is 1:30 Central time, and it is not yet working for me either.


I am glad to see Randy is looking into this and glad to hear he thinks it is at Yahoo.


After multiple years, not a problem, then this morning BAM! - I have not changed anything so I always expect smfaddin to work, it is very reliable for me.


So I am glad to read the culpable suspect is probably nothing on my end, meaning that it is probably happening at that Yahoo end, not ours.


I will check in later and report whether it is resolved on my end or not.


Richqw, best wishes to all of us that are dealing with this issue.


rr76012

Mon Aug 10, 2015 11:37 am (PDT) . Posted by:

rr76012

Hello Randy,


I will follow your idea, and give Yahoo feedback the download datalink is not working.


I hope this helps Yahoo identify this as a problem and work on fixing it.


Randy, thanks.


rr76012

Mon Aug 10, 2015 11:40 am (PDT) . Posted by:

rr76012

Finance GS: Data accuracy (1532 ideas) – Yahoo Feedback https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy?query=Your%20download%20link%20seems%20to%20not


Finance GS: Data accuracy (1532 ideas) – Yahoo Feedback https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy?query=Your%20download%20link%20seems%20to%20not Hi all, We're very sorry for the inconvenience. Financial symbols on exchanges covering Europe, Mexico, Tel-Aviv, and Indonesia may display stale prices.



View on yahoo.uservoice.com https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy?query=Your%20download%20link%20seems%20to%20not
Preview by Yahoo




Randy, here is a copy and paste to the yahoo link, announcing they seem to know there is a problem.


The " Download Data (Delayed)" links on quote pages are not updating https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages The " Download Data (Delayed)" link s on quote pages are not updating. They are providing stale data from yesterday.




rr76012



Mon Aug 10, 2015 11:41 am (PDT) . Posted by:

rr76012

The " Download Data (Delayed)" links on quote pages are not updating https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages The " Download Data (Delayed)" link s on quote pages are not updating. They are providing stale data from yesterday.


Finance GS: Data accuracy (1532 ideas) – Yahoo Feedback https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy?query=Your%20download%20link%20seems%20to%20not


Finance GS: Data accuracy (1532 ideas) – Yahoo Feedback https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy?query=Your%20download%20link%20seems%20to%20not Hi all, We're very sorry for the inconvenience. Financial symbols on exchanges covering Europe, Mexico, Tel-Aviv, and Indonesia may display stale prices.



View on yahoo.uservoice.com https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy?query=Your%20download%20link%20seems%20to%20not
Preview by Yahoo






Randy,


This is from Yahoo.


rr76012



Mon Aug 10, 2015 1:58 pm (PDT) . Posted by:

gdett2

I followed all the info on smfForceRecalculation in the FAQs, I removed and reinstalled the RCH_Stock_Market_Functions-2.1.2014.01.30 files. I rebooted. I tried the sample file you mentioned. I still get a blank return using Excel 2010 on Win 8.1.

It has been working flawlessly since last year. On Friday, I had a hiccup where the quotes for certain issues like NFLX seemed to not update until after the market close, It continued to report the daily high as the current price through the market day.

When I went to assign the short-cut for the Force macro, it was already assigned Ctrl-Shift-R. Pressing that does give me the "update blip" in the lower margin of the Excel window.

Any other ideas to try?

Mon Aug 10, 2015 2:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If it's a problem on Yahoo's side, there's nothing you can do on your side
to make it work.

Try the download link on a Yahoo summary page for a stock to see if it
works. That will verify whether your problem is on Yahoo's side or not.

On Mon, Aug 10, 2015 at 10:27 AM, gdett2@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I followed all the info on smfForceRecalculation in the FAQs, I removed
> and reinstalled the RCH_Stock_Market_Functions-2.1.2014.01.30 files. I
> rebooted. I tried the sample file you mentioned. I still get a blank
> return using Excel 2010 on Win 8.1.
>
> It has been working flawlessly since last year. On Friday, I had a hiccup
> where the quotes for certain issues like NFLX seemed to not update until
> after the market close, It continued to report the daily high as the
> current price through the market day.
>
> When I went to assign the short-cut for the Force macro, it was already
> assigned Ctrl-Shift-R. Pressing that does give me the "update blip" in the
> lower margin of the Excel window.
>
> Any other ideas to try?
>

Mon Aug 10, 2015 5:11 pm (PDT) . Posted by:

rr76012

gdett2,


I too am using windows 8.1 and excel 2010.


I am a little worried it might not be Yahoo because Randy says his template is working.


Why would Yahoo Server be working for Randy and not ours.


I hope it works tomorrow morning if not I am going to ask Lyndal Homewood how she uses google to do the same thing?

Mon Aug 10, 2015 4:45 pm (PDT) . Posted by:

sushiwaitress

Thanks so much -- I'll give that a shot.
- sushi
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar