14 New Messages
Digest #2911
Messages
Tue Dec 31, 2013 4:45 am (PST) . Posted by:
63b31a65c9c738e4af34541b0710492f
After some more testing it appears as if the decimal separator settings have considerable impact: e. g. when using smfGetOptionQuotes() with Yahoo (US) as the source for US options quotes, I have to adjust my system settings to the US standards for correct numbers parsing.
When using RCHGetTableCell to read German-style numbers (comma as decimal separator) from a German site, system settings need to be German. However, with the standard German settings, RCHGetTableCell is misinterpreting German date fomats (dd.mm.yyyy) by just ignoring the dots and converting to meaningless numbers (e. g. 01.01.2014 which is supposed to be Jan 1 2014 into 1012014). Interestingly enough, when using US system settings, RCHGetTableCell is returning this as a (useful) string "01.01.2014".
Any general guidelines how to deal with this serious (from an international user's point of view) issue? Would it be possible to temporarily adjust the system settings programatically while these functions are running? How could this be done? Unfortunately, just changing the application settings in Excel does not have any impact on this behavior. Ideas, suggestions?
When using RCHGetTableCell to read German-style numbers (comma as decimal separator) from a German site, system settings need to be German. However, with the standard German settings, RCHGetTableCell is misinterpreting German date fomats (dd.mm.yyyy) by just ignoring the dots and converting to meaningless numbers (e. g. 01.01.2014 which is supposed to be Jan 1 2014 into 1012014). Interestingly enough, when using US system settings, RCHGetTableCell is returning this as a (useful) string "01.01.
Any general guidelines how to deal with this serious (from an international user's point of view) issue? Would it be possible to temporarily adjust the system settings programatically while these functions are running? How could this be done? Unfortunately, just changing the application settings in Excel does not have any impact on this behavior. Ideas, suggestions?
Tue Dec 31, 2013 7:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think there area a couple items on the topic in the LINKS area of the
group.
On Tue, Dec 31, 2013 at 5:45 AM, <m.heritsch@gmail.com> wrote:
> After some more testing it appears as if the decimal separator settings
> have considerable impact: e. g. when using smfGetOptionQuotes() with Yahoo
> (US) as the source for US options quotes, I have to adjust my system
> settings to the US standards for correct numbers parsing.
>
>
> When using RCHGetTableCell to read German-style numbers (comma as decimal
> separator) from a German site, system settings need to be German. However,
> with the standard German settings, RCHGetTableCell is misinterpreting
> German date fomats (dd.mm.yyyy) by just ignoring the dots and converting to
> meaningless numbers (e. g. 01.01.2014 which is supposed to be Jan 1 2014
> into 1012014). Interestingly enough, when using US system settings,
> RCHGetTableCell is returning this as a (useful) string "01.01.2014".
>
>
> Any general guidelines how to deal with this serious (from an
> international user's point of view) issue? Would it be possible to
> temporarily adjust the system settings programatically while these
> functions are running? How could this be done? Unfortunately, just changing
> the application settings in Excel does not have any impact on this
> behavior. Ideas, suggestions?
>
group.
On Tue, Dec 31, 2013 at 5:45 AM, <m.heritsch@gmail.
> After some more testing it appears as if the decimal separator settings
> have considerable impact: e. g. when using smfGetOptionQuotes(
> (US) as the source for US options quotes, I have to adjust my system
> settings to the US standards for correct numbers parsing.
>
>
> When using RCHGetTableCell to read German-style numbers (comma as decimal
> separator) from a German site, system settings need to be German. However,
> with the standard German settings, RCHGetTableCell is misinterpreting
> German date fomats (dd.mm.yyyy) by just ignoring the dots and converting to
> meaningless numbers (e. g. 01.01.2014 which is supposed to be Jan 1 2014
> into 1012014). Interestingly enough, when using US system settings,
> RCHGetTableCell is returning this as a (useful) string "01.01.
>
>
> Any general guidelines how to deal with this serious (from an
> international user's point of view) issue? Would it be possible to
> temporarily adjust the system settings programatically while these
> functions are running? How could this be done? Unfortunately, just changing
> the application settings in Excel does not have any impact on this
> behavior. Ideas, suggestions?
>
Tue Dec 31, 2013 7:36 am (PST) . Posted by:
63b31a65c9c738e4af34541b0710492f
Thanks for the hint - indeed user prosuite has proposed a fix by replacing the standard CDec and CDate functions with custom versions (I have not tested them yet, need to figure out how to apply the fix...). If working fine, these should be included in future updates to make your really powerful add-in even more useful for a broader audience. Thanks again.
Tue Dec 31, 2013 7:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I tried the techniques at one point and had issues. It was just too
difficult for me to test all the permutations that might occur. Remember,
this isn't a commercial product -- I'm just sharing something I wrote for
my own use (which has grown far beyond my original usage).
On Tue, Dec 31, 2013 at 8:36 AM, <m.heritsch@gmail.com> wrote:
> Thanks for the hint - indeed user prosuite has proposed a fix by
> replacing the standard CDec and CDate functions with custom versions (I
> have not tested them yet, need to figure out how to apply the fix...). If
> working fine, these should be included in future updates to make your
> really powerful add-in even more useful for a broader audience. Thanks
> again.
>
difficult for me to test all the permutations that might occur. Remember,
this isn't a commercial product -- I'm just sharing something I wrote for
my own use (which has grown far beyond my original usage).
On Tue, Dec 31, 2013 at 8:36 AM, <m.heritsch@gmail.
> Thanks for the hint - indeed user prosuite has proposed a fix by
> replacing the standard CDec and CDate functions with custom versions (I
> have not tested them yet, need to figure out how to apply the fix...). If
> working fine, these should be included in future updates to make your
> really powerful add-in even more useful for a broader audience. Thanks
> again.
>
Tue Dec 31, 2013 6:52 am (PST) . Posted by:
Smart_Dude_99
Hi, I'm new here. I'm having trouble understanding how the GetWebData() function works? The website you reference only seems to have a picture. What is being parsed? Where does the split information come from?
Thanks
Thanks
Tue Dec 31, 2013 7:17 am (PST) . Posted by:
"Randy Harmelink" rharmelink
RCHGetWebData() retrieve the source code of a web page.
The split information is below the graph:
http://finance.yahoo.com/q/bc?t=my&s=MMM
On Tue, Dec 31, 2013 at 2:20 AM, <smart_dude_99@yahoo.com> wrote:
>
> Hi, I'm new here. I'm having trouble understanding how the GetWebData()
> function works? The website you reference only seems to have a picture.
> What is being parsed? Where does the split information come from?
>
The split information is below the graph:
http://finance.
On Tue, Dec 31, 2013 at 2:20 AM, <smart_dude_99@
>
> Hi, I'm new here. I'm having trouble understanding how the GetWebData()
> function works? The website you reference only seems to have a picture.
> What is being parsed? Where does the split information come from?
>
Tue Dec 31, 2013 2:35 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
I use this site for split history.
http://getsplithistory.com/
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of smart_dude_99@yahoo.com
Sent: Tuesday, December 31, 2013 4:21 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: Any way to download historical data of split seperately?
Hi, I'm new here. I'm having trouble understanding how the GetWebData() function works? The website you reference only seems to have a picture. What is being parsed? Where does the split information come from?
Thanks
http://getsplithist
From: smf_addin@yahoogrou
Sent: Tuesday, December 31, 2013 4:21 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] RE: Any way to download historical data of split seperately?
Hi, I'm new here. I'm having trouble understanding how the GetWebData() function works? The website you reference only seems to have a picture. What is being parsed? Where does the split information come from?
Thanks
Tue Dec 31, 2013 5:11 pm (PST) . Posted by:
shannielheadley
Hello!
I'm new to the forum and in need of some help. I wanted to see if the AddFin issue has been resolved. I sent this file to Randy a few months ago and he determined that the AdvFin was the issue.
looking forward to hearing back from you soon.
I'm new to the forum and in need of some help. I wanted to see if the AddFin issue has been resolved. I sent this file to Randy a few months ago and he determined that the AdvFin was the issue.
looking forward to hearing back from you soon.
Attachments with this message:
1 of 1 File(s)
Tue Dec 31, 2013 5:11 pm (PST) . Posted by:
shannielheadley
Hello,
I'm new to the forum and need some help. Has there been any update to address the AdvFN changes?
I'm new to the forum and need some help. Has there been any update to address the AdvFN changes?
Tue Dec 31, 2013 5:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24009
On Tue, Dec 31, 2013 at 5:31 PM, <asfa20_1@yahoo.com> wrote:
>
> I'm new to the forum and need some help. Has there been any update to
> address the AdvFN changes?
>
http://groups.
On Tue, Dec 31, 2013 at 5:31 PM, <asfa20_1@yahoo.
>
> I'm new to the forum and need some help. Has there been any update to
> address the AdvFN changes?
>
Tue Dec 31, 2013 5:23 pm (PST) . Posted by:
"Asfa" shannielheadley
Hi Randy! Thanks for responding.
I'm not tech savvy and am having difficulties interpreting the link. so in layman's terms can you please simplify it a bit?
Thanks,
Shanniel
***Sent from my iPhone
Please excuse any typos***
> On Dec 31, 2013, at 8:15 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
>
> See: http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24009
>
>> On Tue, Dec 31, 2013 at 5:31 PM, <asfa20_1@yahoo.com> wrote:
>>
>> I'm new to the forum and need some help. Has there been any update to address the AdvFN changes?
>
>
I'm not tech savvy and am having difficulties interpreting the link. so in layman's terms can you please simplify it a bit?
Thanks,
Shanniel
***Sent from my iPhone
Please excuse any typos***
> On Dec 31, 2013, at 8:15 PM, Randy Harmelink <rharmelink@gmail.
>
> See: http://groups.
>
>> On Tue, Dec 31, 2013 at 5:31 PM, <asfa20_1@yahoo.
>>
>> I'm new to the forum and need some help. Has there been any update to address the AdvFN changes?
>
>
Tue Dec 31, 2013 5:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Get the beta version of the add-in from the "Works in Progress" folder from
the FILES area of the group.
It's been updated for the AdvFN changes. Your attachment in the other
message appeared to work just fine for me.
On Tue, Dec 31, 2013 at 6:19 PM, Asfa <asfa20_1@yahoo.com> wrote:
>
> Hi Randy! Thanks for responding.
>
> I'm not tech savvy and am having difficulties interpreting the link. so in
> layman's terms can you please simplify it a bit?
>
the FILES area of the group.
It's been updated for the AdvFN changes. Your attachment in the other
message appeared to work just fine for me.
On Tue, Dec 31, 2013 at 6:19 PM, Asfa <asfa20_1@yahoo.
>
> Hi Randy! Thanks for responding.
>
> I'm not tech savvy and am having difficulties interpreting the link. so in
> layman's terms can you please simplify it a bit?
>
Tue Dec 31, 2013 5:31 pm (PST) . Posted by:
"Asfa" shannielheadley
So can you send that original file back to me?
Thanks,
Shanniel
***Sent from my iPhone
Please excuse any typos***
> On Dec 31, 2013, at 8:25 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
>
> Get the beta version of the add-in from the "Works in Progress" folder from the FILES area of the group.
>
> It's been updated for the AdvFN changes. Your attachment in the other message appeared to work just fine for me.
>
>> On Tue, Dec 31, 2013 at 6:19 PM, Asfa <asfa20_1@yahoo.com> wrote:
>>
>> Hi Randy! Thanks for responding.
>>
>> I'm not tech savvy and am having difficulties interpreting the link. so in layman's terms can you please simplify it a bit?
>
>
Thanks,
Shanniel
***Sent from my iPhone
Please excuse any typos***
> On Dec 31, 2013, at 8:25 PM, Randy Harmelink <rharmelink@gmail.
>
> Get the beta version of the add-in from the "Works in Progress" folder from the FILES area of the group.
>
> It's been updated for the AdvFN changes. Your attachment in the other message appeared to work just fine for me.
>
>> On Tue, Dec 31, 2013 at 6:19 PM, Asfa <asfa20_1@yahoo.
>>
>> Hi Randy! Thanks for responding.
>>
>> I'm not tech savvy and am having difficulties interpreting the link. so in layman's terms can you please simplify it a bit?
>
>
Tue Dec 31, 2013 5:32 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You can get it from the message you sent to the group:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24874
On Tue, Dec 31, 2013 at 6:27 PM, Asfa <asfa20_1@yahoo.com> wrote:
>
> So can you send that original file back to me?
>
http://groups.
On Tue, Dec 31, 2013 at 6:27 PM, Asfa <asfa20_1@yahoo.
>
> So can you send that original file back to me?
>
Tidak ada komentar:
Posting Komentar