4 Messages
Digest #4061
Messages
Fri Jun 16, 2017 7:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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
It's in *beta* release, so things might change...
Note that non-daily data requests from Yahoo are not adjusting correctly.
On Fri, Jun 16, 2017 at 6:22 PM, Allan allanhasmail@
...
wrote:
> 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?
>
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
It's in *beta* release, so things might change...
Note that non-daily data requests from Yahoo are not adjusting correctly.
On Fri, Jun 16, 2017 at 6:22 PM, Allan allanhasmail@
...
wrote:
> Where do I find updates/ the latest version of this add-in?
>
> http://ogres-crypt.com/SMF/ shows
> RCH_Stock_Market_
> the add-in.
>
> Is this where it's available from?
>
Fri Jun 16, 2017 7:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, not from me. I'm not a corporation that can support and test a
product over numerous permutations of software and regions. I'm just
sharing something I originally wrote for my own use.
It just makes maintenance too difficult when there are processes in place
that I don't use, and would require extra effort for me to have to test
when I make changes.
Can you pass the dates as EXCEL serial values instead of as strings?
On Fri, Jun 16, 2017 at 5:44 PM, rimanda1@
...
wrote:
>
> 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?
>
>
product over numerous permutations of software and regions. I'm just
sharing something I originally wrote for my own use.
It just makes maintenance too difficult when there are processes in place
that I don't use, and would require extra effort for me to have to test
when I make changes.
Can you pass the dates as EXCEL serial values instead of as strings?
On Fri, Jun 16, 2017 at 5:44 PM, rimanda1@
...
wrote:
>
> 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&quo
> days are not > 12).
>
> Would it be possible to use an alternative to using the DateValue function
> when computing dBegin and dEnd?
>
>
Sat Jun 17, 2017 1:24 pm (PDT) . Posted by:
"David" who1012000
Thanks Randy. It may take some time, but I expect I will figure something out. Maybe I will have to find another web site that has price histories, but I have been using using Yahoo for many years.Thanks for your time and efforts.David
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, June 16, 2017 7:57 PM
Subject: Re: [smf_addin] Re: RCHGetYahooHistory in Version 2.1.2017.06.09
<!--#yiv5443117592 #yiv5443117592 .yiv5443117592ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5443117592 div.yiv5443117592ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5443117592 div.yiv5443117592photo-title a, #yiv5443117592 div.yiv5443117592photo-title a:active, #yiv5443117592 div.yiv5443117592photo-title a:hover, #yiv5443117592 div.yiv5443117592photo-title a:visited {text-decoration:none;}#yiv5443117592 div.yiv5443117592attach-table div.yiv5443117592attach-row {clear:both;}#yiv5443117592 div.yiv5443117592attach-table div.yiv5443117592attach-row div {float:left;}#yiv5443117592 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5443117592 div.yiv5443117592ygrp-file {width:30px;}#yiv5443117592 div.yiv5443117592attach-table div.yiv5443117592attach-row div div a {text-decoration:none;}#yiv5443117592 div.yiv5443117592attach-table div.yiv5443117592attach-row div div span {font-weight:normal;}#yiv5443117592 div.yiv5443117592ygrp-file-title {font-weight:bold;}#yiv5443117592 --> <!--#yiv5443117592 #yiv5443117592ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5443117592 #yiv5443117592ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5443117592 #yiv5443117592ygrp-mkp #yiv5443117592hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5443117592 #yiv5443117592ygrp-mkp #yiv5443117592ads {margin-bottom:10px;}#yiv5443117592 #yiv5443117592ygrp-mkp .yiv5443117592ad {padding:0 0;}#yiv5443117592 #yiv5443117592ygrp-mkp .yiv5443117592ad p {margin:0;}#yiv5443117592 #yiv5443117592ygrp-mkp .yiv5443117592ad a {color:#0000ff;text-decoration:none;}-->
Sorry, not from me. I'm not a corporation that can support and test a product over numerous permutations of software and regions. I'm just sharing something I originally wrote for my own use.
It just makes maintenance too difficult when there are processes in place that I don't use, and would require extra effort for me to have to test when I make changes.
Can you pass the dates as EXCEL serial values instead of as strings?
On Fri, Jun 16, 2017 at 5:44 PM, rimanda1@... wrote:
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?
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, June 16, 2017 7:57 PM
Subject: Re: [smf_addin] Re: RCHGetYahooHistory in Version 2.1.2017.06.
<!--#yiv54431175
Sorry, not from me. I'm not a corporation that can support and test a product over numerous permutations of software and regions. I'm just sharing something I originally wrote for my own use.
It just makes maintenance too difficult when there are processes in place that I don't use, and would require extra effort for me to have to test when I make changes.
Can you pass the dates as EXCEL serial values instead of as strings?
On Fri, Jun 16, 2017 at 5:44 PM, rimanda1@... wrote:
Ok, so I can reverse the order of the day an month in the function call, however, this seems a little "awkward"
The function RCHGetYahoo
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?
Sat Jun 17, 2017 6:51 pm (PDT) . Posted by:
lutherkinchen
Randy, I have been using the Alt+d+d+w to login to Stockcharts.com, and the process sometimes will pulls in the charts correctly. However, more often it does not. Really about a 20% success rate, at best.
I keep going through the process of using the steps Alt+d+d+w hoping excel would somehow remember that I want it to remember to pull in the charts, I have set up correctly, but its seems to be hit and miss.
More miss than correct.
Any ideas on what I could be doing wrong, for it to work once in a while and not every time.
Just hoping you or someone else would have run across these type issues before when using the comment formula like this one:
=RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&B1&"&p=M&yr=10&mn=0&dy=0&i=p83276748253&a=529543242&r=1497528728185",99,,,)
This site has been a true blessing. I realize you cannot fix everyone's issues, but I have seen you fix a ton of them. Hope all is well.
Happy Father's Day,
Luther
I keep going through the process of using the steps Alt+d+d+w hoping excel would somehow remember that I want it to remember to pull in the charts, I have set up correctly, but its seems to be hit and miss.
More miss than correct.
Any ideas on what I could be doing wrong, for it to work once in a while and not every time.
Just hoping you or someone else would have run across these type issues before when using the comment formula like this one:
=RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&B1&"
This site has been a true blessing. I realize you cannot fix everyone'
Happy Father's Day,
Luther
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar