7 Messages
Digest #4060
Messages
Thu Jun 15, 2017 7:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ctrl+Alt+F9 would not recalculate the smfGetYahooHistory() function. You
need to get the web page again, which requires smfForceRecalculation.
I have had Yahoo take some time to deliver the data. Unfortunately, the web
page is nearly 1.5MB in size.
I've not had it refuse to get anything though...
On Thu, Jun 15, 2017 at 7:01 PM, tonyestep@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> In line with Randy's comments in the previous post, I downloaded the beta
> version and tried it, only to discover that sometimes it refuses to get
> anything. Sometimes it works okay, but sometimes pressing Ctrl-Alt-F9 does
> not make the sheet recalc; it just sits there defiantly. So I went back to
> the previous version.
>
>
>
need to get the web page again, which requires smfForceRecalculation.
I have had Yahoo take some time to deliver the data. Unfortunately, the web
page is nearly 1.5MB in size.
I've not had it refuse to get anything though...
On Thu, Jun 15, 2017 at 7:01 PM, tonyestep@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> In line with Randy's comments in the previous post, I downloaded the beta
> version and tried it, only to discover that sometimes it refuses to get
> anything. Sometimes it works okay, but sometimes pressing Ctrl-Alt-F9 does
> not make the sheet recalc; it just sits there defiantly. So I went back to
> the previous version.
>
>
>
Fri Jun 16, 2017 8:37 am (PDT) . Posted by:
aznshmlsguy
There was one template that I have been using over the years that gets the historical prices from yahoo. Today it suddenly get the following responses of
run time error '1004'.
Unable to open http:/ichart.finance.yahoo.com/table.csv?s=gdx&a=11&b=31&c=189
The internet site reports that the item you requested could not be found (HTTP/1.0 404)
run time error '1004'
Unable to open http:/ichart.
The internet site reports that the item you requested could not be found (HTTP/1.0 404)
Fri Jun 16, 2017 9:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo had a major change and unplugged that option to get data. See:
2017-05-18 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
smfGetYahooHistory() parameters:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
2017-05-21 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
2017-05-25 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
2017-06-09 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
On Fri, Jun 16, 2017 at 8:26 AM, aznshmlsguy@
...
wrote:
> There was one template that I have been using over the years that gets the
> historical prices from yahoo. Today it suddenly get the following
> responses of
>
> run time error '1004'.
>
> Unable to open http:/ichart.finance.yahoo.com/table.csv?s=gdx&a=11&b=31&
> c=189
>
> The internet site reports that the item you requested could not be found
> (HTTP/1.0 404)
>
2017-05-18 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
smfGetYahooHistory() parameters:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
2017-05-21 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
2017-05-25 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
2017-06-09 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
On Fri, Jun 16, 2017 at 8:26 AM, aznshmlsguy@
...
wrote:
> There was one template that I have been using over the years that gets the
> historical prices from yahoo. Today it suddenly get the following
> responses of
>
> run time error '1004'
>
> Unable to open http:/ichart.
> c=189
>
> The internet site reports that the item you requested could not be found
> (HTTP/1.0 404)
>
Fri Jun 16, 2017 9:55 am (PDT) . Posted by:
gareneau
Hi Randy,
I've been tracking progress here but don't have the programming skills others do. For the layperson, could you tell me how close you think you are to effectively a "go live" date for the new plug-in?
Hopefully, that's not an unfair question - and thanks very much for a fantastic offering.
Gary
I've been tracking progress here but don't have the programming skills others do. For the layperson, could you tell me how close you think you are to effectively a "go live" date for the new plug-in?
Hopefully, that's not an unfair question - and thanks very much for a fantastic offering.
Gary
Fri Jun 16, 2017 10:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not an unfair question. I guess I'm just very hesitant. Maybe because I
don't trust Yahoo not to make more changes. They still have issues on the
non-daily data.
On Fri, Jun 16, 2017 at 9:55 AM, gareneau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I've been tracking progress here but don't have the programming skills
> others do. For the layperson, could you tell me how close you think you are
> to effectively a "go live" date for the new plug-in?
>
> Hopefully, that's not an unfair question - and thanks very much for a
> fantastic offering.
>
>
don't trust Yahoo not to make more changes. They still have issues on the
non-daily data.
On Fri, Jun 16, 2017 at 9:55 AM, gareneau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I've been tracking progress here but don't have the programming skills
> others do. For the layperson, could you tell me how close you think you are
> to effectively a "go live" date for the new plug-in?
>
> Hopefully, that's not an unfair question - and thanks very much for a
> fantastic offering.
>
>
Fri Jun 16, 2017 5:44 pm (PDT) . Posted by:
rimanda1
Ok, so I can reverse the order of the day an month in the function call, however, this seems a little "awkward". Anyone using the function in countries that use dd/mm/yy will encounter the same problem and possibly cause support issues....
The function RCHGetYahooHistory calls smfGetYahooHistory with the parameter pStartDate and PEndDate "hard wired" to USA format.
The code to establish dBegin and dEnd includes the DateValue function which is causing the problem, as in Australia and elsewhere this turns "6/30/2016" into "30/6/2016" BUT does NOT convert "7/4/2016"; (since the days are not > 12).
Would it be possible to use an alternative to using the DateValue function when computing dBegin and dEnd?
The function RCHGetYahooHistory calls smfGetYahooHistory with the parameter pStartDate and PEndDate "hard wired" to USA format.
The code to establish dBegin and dEnd includes the DateValue function which is causing the problem, as in Australia and elsewhere this turns "6/30/2016&quo
Would it be possible to use an alternative to using the DateValue function when computing dBegin and dEnd?
Fri Jun 16, 2017 6:22 pm (PDT) . Posted by:
"Allan" aprivoisermoi2005
Where do I find updates/ the latest version of this add-in?
http://ogres-crypt.com/SMF/ shows
RCH_Stock_Market_Functions-2.1.2017.05.03.zip Latest official relase of
the add-in.
Is this where it's available from?
Allan
http://ogres-crypt.com/SMF/ shows
RCH_Stock_Market_
the add-in.
Is this where it's available from?
Allan
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar