Sabtu, 29 Agustus 2015

[smf_addin] Digest Number 3499

12 Messages

Digest #3499
1a
GetYahooQuotes by "Alexander Lang"
1b
Re: GetYahooQuotes by "Randy Harmelink" rharmelink
1c
Re: GetYahooQuotes by "Alexander Lang"
1d
Re: GetYahooQuotes [1 Attachment] by "Randy Harmelink" rharmelink
1e
Re: GetYahooQuotes by "Alexander Lang"
1f
Re: GetYahooQuotes by "Alexander Lang"
1g
Re: GetYahooQuotes [3 Attachments] by "Randy Harmelink" rharmelink
1h
Re: GetYahooQuotes by "Alexander Lang"
1i
Re: GetYahooQuotes by "Randy Harmelink" rharmelink
1j
Re: GetYahooQuotes by "Alexander Lang"
1k
Re: GetYahooQuotes [3 Attachments] by "Randy Harmelink" rharmelink
1l
Re: GetYahooQuotes by "Alexander Lang"

Messages

Fri Aug 28, 2015 11:52 am (PDT) . Posted by:

"Alexander Lang"

Hello there,

first of all great addin but I have a problem regarding the format of a
cell:

That's what I want, but when I push F9 again to refresh I am getting the
following from time to time for each stock:

How can I avoid that?

cheers

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

Fri Aug 28, 2015 12:03 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

My initial reaction was that it must have been a glitch from Yahoo.

However, I see some items your email that indicate you're a German user. Is
it possible that it is a result of some type of misinterpretation of the
CSV file, because of German denotation of dollars and cents? The program is
designed to run under US regional settings of the operating system, as that
affects how numbers are processed in VBA.

Are you doing an array-entered formula, or individual formulas? If
array-entered, are those the only four data items you are retrieving for
each stock?

Overall, I'm confused.

On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang lang.alex@... wrote:

>
> Hello there,
>
> first of all great addin but I have a problem regarding the format of a
> cell:
>
>
> That's what I want, but when I push F9 again to refresh I am getting the
> following from time to time for each stock:
>
>
>
> How can I avoid that?
>
> cheers
>

Fri Aug 28, 2015 12:14 pm (PDT) . Posted by:

"Alexander Lang"

Yes I am from Germany.
Excel 2003/Windows 7 User

Output of the letter l

Changed Excel to US but that was not the problem I guess....dunno what I
am doing wrong :/

Am 28.08.2015 um 21:03 schrieb Randy Harmelink rharmelink@gmail.com
[smf_addin]:
> My initial reaction was that it must have been a glitch from Yahoo.
>
> However, I see some items your email that indicate you're a German
> user. Is it possible that it is a result of some type of
> misinterpretation of the CSV file, because of German denotation of
> dollars and cents? The program is designed to run under US regional
> settings of the operating system, as that affects how numbers are
> processed in VBA.
>
> Are you doing an array-entered formula, or individual formulas? If
> array-entered, are those the only four data items you are retrieving
> for each stock?
>
> Overall, I'm confused.
>
> On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang lang.alex@... wrote:
>
>
> Hello there,
>
> first of all great addin but I have a problem regarding the format
> of a cell:
>
>
> That's what I want, but when I push F9 again to refresh I am
> getting the following from time to time for each stock:
>
>
>
> How can I avoid that?
>
> cheers
>
>
>

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

Fri Aug 28, 2015 12:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The VBA environment wouldn't care what your EXCEL setting was. VBA uses the
regional setting of the operating system, not EXCEL.

I'm still confused. I can't imagine what would have caused such a number,
other than a glitch from Yahoo, based on your formula invocation (I'm
assuming you had "l1" before instead of "l").

I just can't think what format of number from Yahoo would be translated to
783.25.

If the number had been 78.325, German conversion wouldn't result in 783.25,
correct?

On Fri, Aug 28, 2015 at 12:14 PM, Alexander Lang lang.alex@yahoo.de
[smf_addin] <smf_addin@yahoogroups.com> wrote:

> [Attachment(s) <#14f75bbe5c7014e0_TopText> from Alexander Lang included
> below]
>
> Yes I am from Germany.
> Excel 2003/Windows 7 User
>
>
>
> Output of the letter l
>
> Changed Excel to US but that was not the problem I guess....dunno what I
> am doing wrong :/
>
> Am 28.08.2015 um 21:03 schrieb Randy Harmelink rharmelink@gmail.com
> [smf_addin]:
>
>
> My initial reaction was that it must have been a glitch from Yahoo.
>
> However, I see some items your email that indicate you're a German user.
> Is it possible that it is a result of some type of misinterpretation of the
> CSV file, because of German denotation of dollars and cents? The program is
> designed to run under US regional settings of the operating system, as that
> affects how numbers are processed in VBA.
>
> Are you doing an array-entered formula, or individual formulas? If
> array-entered, are those the only four data items you are retrieving for
> each stock?
>
> Overall, I'm confused.
>
> On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang lang.alex@... wrote:
>
>>
>> Hello there,
>>
>> first of all great addin but I have a problem regarding the format of a
>> cell:
>>
>>
>> That's what I want, but when I push F9 again to refresh I am getting the
>> following from time to time for each stock:
>>
>>
>>
>> How can I avoid that?
>>
>> cheers
>>
>
>
>

Fri Aug 28, 2015 12:51 pm (PDT) . Posted by:

"Alexander Lang"

Yep I had l1 before.

Well in Germany we use , (comma) instead of . (dot)

Do you think that is the problem?

The cells are formated in "Standard"

That is the output of custom:

As soon as I push the f9 button and the output is e.g. 1432221, the cell
interprets that as 14322,21

As long as the yahoo output is xx.xx everthing is fine

Am 28.08.2015 um 21:30 schrieb Randy Harmelink rharmelink@gmail.com
[smf_addin]:
> The VBA environment wouldn't care what your EXCEL setting was. VBA
> uses the regional setting of the operating system, not EXCEL.
>
> I'm still confused. I can't imagine what would have caused such a
> number, other than a glitch from Yahoo, based on your formula
> invocation (I'm assuming you had "l1" before instead of "l").
>
> I just can't think what format of number from Yahoo would be
> translated to 783.25.
>
> If the number had been 78.325, German conversion wouldn't result in
> 783.25, correct?
>
>
> On Fri, Aug 28, 2015 at 12:14 PM, Alexander Lang lang.alex@yahoo.de
> <mailto:lang.alex@yahoo.de> [smf_addin] <smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>> wrote:
>
> [Attachment(s) <#14f75bbe5c7014e0_TopText> from Alexander Lang
> included below]
>
> Yes I am from Germany.
> Excel 2003/Windows 7 User
>
>
>
> Output of the letter l
>
> Changed Excel to US but that was not the problem I guess....dunno
> what I am doing wrong :/
>
> Am 28.08.2015 um 21:03 schrieb Randy Harmelink
> rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin]:
>> My initial reaction was that it must have been a glitch from Yahoo.
>>
>> However, I see some items your email that indicate you're a
>> German user. Is it possible that it is a result of some type of
>> misinterpretation of the CSV file, because of German denotation
>> of dollars and cents? The program is designed to run under US
>> regional settings of the operating system, as that affects how
>> numbers are processed in VBA.
>>
>> Are you doing an array-entered formula, or individual formulas?
>> If array-entered, are those the only four data items you are
>> retrieving for each stock?
>>
>> Overall, I'm confused.
>>
>> On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang lang.alex@... wrote:
>>
>>
>> Hello there,
>>
>> first of all great addin but I have a problem regarding the
>> format of a cell:
>>
>>
>> That's what I want, but when I push F9 again to refresh I am
>> getting the following from time to time for each stock:
>>
>>
>>
>> How can I avoid that?
>>
>> cheers
>>
>>
>
>
>

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

Fri Aug 28, 2015 12:51 pm (PDT) . Posted by:

"Alexander Lang"

Yep I had l1 before.

Well in Germany we use , (comma) instead of . (dot)

Do you think that is the problem?

The cells are formated in "Standard"

That is the output of custom:

As soon as I push the f9 button and the output is e.g. 1432221, the cell
interprets that as 14322,21

As long as the yahoo output is xx.xx everything is fine

Am 28.08.2015 um 21:30 schrieb Randy Harmelink rharmelink@gmail.com
[smf_addin]:
> The VBA environment wouldn't care what your EXCEL setting was. VBA
> uses the regional setting of the operating system, not EXCEL.
>
> I'm still confused. I can't imagine what would have caused such a
> number, other than a glitch from Yahoo, based on your formula
> invocation (I'm assuming you had "l1" before instead of "l").
>
> I just can't think what format of number from Yahoo would be
> translated to 783.25.
>
> If the number had been 78.325, German conversion wouldn't result in
> 783.25, correct?
>
>
> On Fri, Aug 28, 2015 at 12:14 PM, Alexander Lang lang.alex@yahoo.de
> <mailto:lang.alex@yahoo.de> [smf_addin] <smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>> wrote:
>
> [Attachment(s) <#14f75bbe5c7014e0_TopText> from Alexander Lang
> included below]
>
> Yes I am from Germany.
> Excel 2003/Windows 7 User
>
>
>
> Output of the letter l
>
> Changed Excel to US but that was not the problem I guess....dunno
> what I am doing wrong :/
>
> Am 28.08.2015 um 21:03 schrieb Randy Harmelink
> rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin]:
>> My initial reaction was that it must have been a glitch from Yahoo.
>>
>> However, I see some items your email that indicate you're a
>> German user. Is it possible that it is a result of some type of
>> misinterpretation of the CSV file, because of German denotation
>> of dollars and cents? The program is designed to run under US
>> regional settings of the operating system, as that affects how
>> numbers are processed in VBA.
>>
>> Are you doing an array-entered formula, or individual formulas?
>> If array-entered, are those the only four data items you are
>> retrieving for each stock?
>>
>> Overall, I'm confused.
>>
>> On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang lang.alex@... wrote:
>>
>>
>> Hello there,
>>
>> first of all great addin but I have a problem regarding the
>> format of a cell:
>>
>>
>> That's what I want, but when I push F9 again to refresh I am
>> getting the following from time to time for each stock:
>>
>>
>>
>> How can I avoid that?
>>
>> cheers
>>
>>
>
>
>

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

Fri Aug 28, 2015 1:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It certainly appears that VBA using the non-US regional setting from the
operating system is the cause of the problem, based on the "l1" vs "l"
comparison.

On Fri, Aug 28, 2015 at 12:51 PM, Alexander Lang lang.alex@... wrote:

> [Attachment(s) <#14f75dd469707e57_TopText> from Alexander Lang included
> below]
>
> Yep I had l1 before.
>
> Well in Germany we use , (comma) instead of . (dot)
>
> Do you think that is the problem?
>
>
>
> The cells are formated in "Standard"
>
> That is the output of custom:
>
>
>
> As soon as I push the f9 button and the output is e.g. 1432221, the cell
> interprets that as 14322,21
>
>
>
> As long as the yahoo output is xx.xx everthing is fine
>
>
> Am 28.08.2015 um 21:30 schrieb Randy Harmelink rharmelink@gmail.com
> [smf_addin]:
>
>
> The VBA environment wouldn't care what your EXCEL setting was. VBA uses
> the regional setting of the operating system, not EXCEL.
>
> I'm still confused. I can't imagine what would have caused such a number,
> other than a glitch from Yahoo, based on your formula invocation (I'm
> assuming you had "l1" before instead of "l").
>
> I just can't think what format of number from Yahoo would be translated to
> 783.25.
>
> If the number had been 78.325, German conversion wouldn't result in
> 783.25, correct?
>
>
> On Fri, Aug 28, 2015 at 12:14 PM, Alexander Lang <lang.alex@yahoo.de>
> lang.alex@yahoo.de [smf_addin] < <smf_addin@yahoogroups.com>
> smf_addin@yahoogroups.com> wrote:
>
>> [Attachment(s) <#14f75dd469707e57_14f75bbe5c7014e0_TopText> from
>> Alexander Lang included below]
>>
>> Yes I am from Germany.
>> Excel 2003/Windows 7 User
>>
>>
>>
>> Output of the letter l
>>
>> Changed Excel to US but that was not the problem I guess....dunno what I
>> am doing wrong :/
>>
>> Am 28.08.2015 um 21:03 schrieb Randy Harmelink <rharmelink@gmail.com>
>> rharmelink@gmail.com [smf_addin]:
>>
>>
>> My initial reaction was that it must have been a glitch from Yahoo.
>>
>> However, I see some items your email that indicate you're a German user.
>> Is it possible that it is a result of some type of misinterpretation of the
>> CSV file, because of German denotation of dollars and cents? The program is
>> designed to run under US regional settings of the operating system, as that
>> affects how numbers are processed in VBA.
>>
>> Are you doing an array-entered formula, or individual formulas? If
>> array-entered, are those the only four data items you are retrieving for
>> each stock?
>>
>> Overall, I'm confused.
>>
>> On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang lang.alex@... wrote:
>>
>>>
>>> Hello there,
>>>
>>> first of all great addin but I have a problem regarding the format of a
>>> cell:
>>>
>>>
>>> That's what I want, but when I push F9 again to refresh I am getting the
>>> following from time to time for each stock:
>>>
>>>
>>>
>>> How can I avoid that?
>>>
>>> cheers
>>>
>>

Fri Aug 28, 2015 1:18 pm (PDT) . Posted by:

"Alexander Lang"

Is there a workaround? Modifying the VBA that only 2 numbers after the
dot are allowed?

Am 28.08.2015 um 22:12 schrieb Randy Harmelink rharmelink@gmail.com
[smf_addin]:
> It certainly appears that VBA using the non-US regional setting from
> the operating system is the cause of the problem, based on the "l1" vs
> "l" comparison.
>
> On Fri, Aug 28, 2015 at 12:51 PM, Alexander Lang lang.alex@... wrote:
>
> [Attachment(s) <#14f75dd469707e57_TopText> from Alexander Lang
> included below]
>
> Yep I had l1 before.
>
> Well in Germany we use , (comma) instead of . (dot)
>
> Do you think that is the problem?
>
>
>
> The cells are formated in "Standard"
>
> That is the output of custom:
>
>
>
> As soon as I push the f9 button and the output is e.g. 1432221,
> the cell interprets that as 14322,21
>
>
>
> As long as the yahoo output is xx.xx everthing is fine
>
>
> Am 28.08.2015 um 21:30 schrieb Randy Harmelink
> rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin]:
>> The VBA environment wouldn't care what your EXCEL setting was.
>> VBA uses the regional setting of the operating system, not EXCEL.
>>
>> I'm still confused. I can't imagine what would have caused such a
>> number, other than a glitch from Yahoo, based on your formula
>> invocation (I'm assuming you had "l1" before instead of "l").
>>
>> I just can't think what format of number from Yahoo would be
>> translated to 783.25.
>>
>> If the number had been 78.325, German conversion wouldn't result
>> in 783.25, correct?
>>
>>
>> On Fri, Aug 28, 2015 at 12:14 PM, Alexander Lang
>> lang.alex@yahoo.de <mailto:lang.alex@yahoo.de> [smf_addin]
>> <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>> wrote:
>>
>> [Attachment(s) <#14f75dd469707e57_14f75bbe5c7014e0_TopText>
>> from Alexander Lang included below]
>>
>> Yes I am from Germany.
>> Excel 2003/Windows 7 User
>>
>>
>>
>> Output of the letter l
>>
>> Changed Excel to US but that was not the problem I
>> guess....dunno what I am doing wrong :/
>>
>> Am 28.08.2015 um 21:03 schrieb Randy Harmelink
>> rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin]:
>>> My initial reaction was that it must have been a glitch from
>>> Yahoo.
>>>
>>> However, I see some items your email that indicate you're a
>>> German user. Is it possible that it is a result of some type
>>> of misinterpretation of the CSV file, because of German
>>> denotation of dollars and cents? The program is designed to
>>> run under US regional settings of the operating system, as
>>> that affects how numbers are processed in VBA.
>>>
>>> Are you doing an array-entered formula, or individual
>>> formulas? If array-entered, are those the only four data
>>> items you are retrieving for each stock?
>>>
>>> Overall, I'm confused.
>>>
>>> On Fri, Aug 28, 2015 at 9:58 AM, Alexander Lang
>>> lang.alex@... wrote:
>>>
>>>
>>> Hello there,
>>>
>>> first of all great addin but I have a problem regarding
>>> the format of a cell:
>>>
>>>
>>> That's what I want, but when I push F9 again to refresh
>>> I am getting the following from time to time for each stock:
>>>
>>>
>>>
>>> How can I avoid that?
>>>
>>> cheers
>>>
>
>

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

Fri Aug 28, 2015 1:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Now that I think about it, the RCHGetYahooQuotes() routine is nothing
more than a CSV parser. It doesn't actually convert anything into numeric
values. So it has to be EXCEL doing it. RCHGetYahooQuotes() is simply
returning a string for the value of the cell.

What happens if you type this in a cell in EXCEL:

143.625

What number do you end up with? Or, maybe more appropriately, the German
equivalent of:

=VALUE("143.625")

On Fri, Aug 28, 2015 at 1:18 PM, Alexander Lang lang.alex@...wrote:

>
> Is there a workaround? Modifying the VBA that only 2 numbers after the dot
> are allowed?
>

Fri Aug 28, 2015 1:39 pm (PDT) . Posted by:

"Alexander Lang"



Am 28.08.2015 um 22:27 schrieb Randy Harmelink rharmelink@gmail.com
[smf_addin]:
> Hmmm. Now that I think about it, the RCHGetYahooQuotes() routine is
> nothing more than a CSV parser. It doesn't actually convert anything
> into numeric values. So it has to be EXCEL doing it.
> RCHGetYahooQuotes() is simply returning a string for the value of the
> cell.
>
> What happens if you type this in a cell in EXCEL:
>
> 143.625
>
> What number do you end up with? Or, maybe more appropriately, the
> German equivalent of:
>
> =VALUE("143.625")
>
> On Fri, Aug 28, 2015 at 1:18 PM, Alexander Lang lang.alex@...wrote:
>
>
> Is there a workaround? Modifying the VBA that only 2 numbers after
> the dot are allowed?
>
>
>

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

Fri Aug 28, 2015 2:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That really didn't tell me anything. Not sure what to tell you at this
point...

The problem is that you're retrieving data in a US format, under a non-US
regional setting, using a US-based tool.

Staying with a non-US regional setting, I think your only workaround is to
retrieve the "l" data item and then extract it and convert it yourself.

On Fri, Aug 28, 2015 at 1:39 PM, Alexander Lang lang.alex@...wrote:

> [Attachment(s) <#14f7609bcfd32df0_TopText> from Alexander Lang included
> below]
>
>
>
>
>
>
>
> Am 28.08.2015 um 22:27 schrieb Randy Harmelink rharmelink@gmail.com
> [smf_addin]:
>
>
> Hmmm. Now that I think about it, the RCHGetYahooQuotes() routine is
> nothing more than a CSV parser. It doesn't actually convert anything into
> numeric values. So it has to be EXCEL doing it. RCHGetYahooQuotes() is
> simply returning a string for the value of the cell.
>
> What happens if you type this in a cell in EXCEL:
>
> 143.625
>
> What number do you end up with? Or, maybe more appropriately, the German
> equivalent of:
>
> =VALUE("143.625")
>
>
>

Fri Aug 28, 2015 2:43 pm (PDT) . Posted by:

"Alexander Lang"

Okay, I will test it!

Thx for your help

Am 8/28/2015 um 11:05 PM schrieb Randy Harmelink rharmelink@gmail.com
[smf_addin]:
> That really didn't tell me anything. Not sure what to tell you at this
> point...
>
> The problem is that you're retrieving data in a US format, under a
> non-US regional setting, using a US-based tool.
>
> Staying with a non-US regional setting, I think your only workaround
> is to retrieve the "l" data item and then extract it and convert it
> yourself.
>
> On Fri, Aug 28, 2015 at 1:39 PM, Alexander Lang lang.alex@...wrote:
>
> [Attachment(s) <#14f7609bcfd32df0_TopText> from Alexander Lang
> included below]
>
>
>
>
>
>
>
> Am 28.08.2015 um 22:27 schrieb Randy Harmelink
> rharmelink@gmail.com <mailto:rharmelink@gmail.com> [smf_addin]:
>> Hmmm. Now that I think about it, the RCHGetYahooQuotes() routine
>> is nothing more than a CSV parser. It doesn't actually convert
>> anything into numeric values. So it has to be EXCEL doing it.
>> RCHGetYahooQuotes() is simply returning a string for the value of
>> the cell.
>>
>> What happens if you type this in a cell in EXCEL:
>>
>> 143.625
>>
>> What number do you end up with? Or, maybe more appropriately, the
>> German equivalent of:
>>
>> =VALUE("143.625")
>
>
>

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar