Frankfurt stock prices are incorrect
The group you are posting to is a
Usenet group . Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
From:
Hugo Blanc <hugo.bl... @gmail.com>
Date: Wed, 30 May 2012 09:15:22 -0700 (PDT)
Local: Wed, May 30 2012 12:15 pm
Subject: Frankfurt stock prices are incorrect
I have reported many stocks from the Frankfurt stock market that have
all incorrect data (historical and stock prices)!
Does someone know why is this happening?
Thanks,
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
"Karolina (Google Finance team)" <k... @google.com>
Date: Wed, 30 May 2012 16:23:02 -0700 (PDT)
Local: Wed, May 30 2012 7:23 pm
Subject: Re: Frankfurt stock prices are incorrect
Hello Hugo, which stocks in particular?
On Wednesday, May 30, 2012 9:15:22 AM UTC-7, Hugo Blanc wrote:
> I have reported many stocks from the Frankfurt stock market that have > all incorrect data (historical and stock prices)! > Does someone know why is this happening? > Thanks,
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Hugo Blanc <hugo.bl... @gmail.com>
Date: Thu, 31 May 2012 01:29:01 -0700 (PDT)
Local: Thurs, May 31 2012 4:29 am
Subject: Re: Frankfurt stock prices are incorrect
Deutsche Bank, BMW, for instance. This is the data shown by Google Finance: http://www.google.com/finance/historical?q=FRA:DBK <http://www.google.com/finance/historical?q=FRA:DBK >
May 30, 201229.0129.4128.5828.9538,432May 29, 201229.2129.5128.7529.1525,323May 28, 201229.6029.8629.0029.1120,470May 25, 201229.0029.7128.8229.3071,805May 24, 201229.1729.2928.5828.8829,387May 23, 201229.0529.2928.6528.9541,570May 22, 201229.4529.7628.6529.5841,619May 21, 201228.4229.0528.4228.9530,602May 18, 201227.7129.3227.7128.5057,956May 17, 201229.1029.1927.7928.4340,695May 16, 201229.0029.6528.6328.6967,210May 15, 201229.9030.3129.0829.2475,523May 14, 201230.7930.8029.7330.0052,792May 11, 201230.8031.2530.1030.8839,397May 10, 201230.6331.7030.3631.2851,391May 9, 201231.0031.0029.8030.5050,307May 8, 201231.7731.7730.5030.5369,336May 7, 201229.9031.8529.9031.8270,649May 4, 201231.1031.8630.6931.1555,757May 3, 201232.2332.3030.9631.1660,891May 2, 201233.2133.4931.7832.2867,779Apr 30, 201233.5333.7832.8532.9033,167Apr 27, 201232.8034.0132.1833.4855,593Apr 26, 201233.6533.9532.0733.2587,088Apr 25, 201233.6534.6833.5734.3237,336Apr 24, 201233.2533.5832.2433.3757,874Apr 23, 201234.0534.1032.7433.2054,710Apr 20, 201233.8335.0733.7834.3027,571Apr 19, 201234.7035.3433.7033.7052,861Apr 18, 201235.3835.5234.5834.6828,469
and this is the correct data:
Timestamp Trade Open Trade High Trade Low Trade Close Trade Volume
5/30/2012 28.925 29.48 28.52 28.825 6637968 5/29/2012 29.45 29.54 28.74 29.23 5698037 5/28/2012 29.695 29.89 29.055 29.165 3830628 5/25/2012 29.15 29.73 29.05 29.39 6928389 5/24/2012 29.2 29.315 28.55 29.08 6282706 5/23/2012 28.85 29.34 28.64 28.84 7296851 5/22/2012 29.195 29.8 28.625 29.66 6987335 5/21/2012 28.465 29.055 28.4 28.95 6856715 5/18/2012 28 29.35 27.95 28.465 10142295 5/17/2012 29.075 29.24 27.735 28.49 6968699 5/16/2012 28.85 29.645 28.58 29.06 9024640 5/15/2012 30.05 30.34 29.065 29.375 8330572 5/14/2012 30.79 30.79 29.715 29.88 7352262 5/11/2012 30.7 31.29 30.09 31.165 8642839 5/10/2012 30.74 31.705 30.33 31.23 8676043 5/9/2012 30.875 30.9 29.785 30.415 8196361 5/8/2012 31.55 31.55 30.55 30.76 6375881 5/7/2012 30.05 31.635 29.91 31.55 6719768 5/4/2012 31 31.915 30.58 31.08 8167601 5/3/2012 32.105 32.41 30.985 31.23 10115112 5/2/2012 33.48 33.5 31.75 32.06 8949308 4/30/2012 33.57 33.655 32.775 32.87 6226946 4/27/2012 32.2 34.04 32.11 33.5 9220939 4/26/2012 33.46 33.61 32.075 33.195 12970170 4/25/2012 33.81 34.745 33.805 34.135 7274274 4/24/2012 33.265 33.59 32.235 33.42 7233783 4/23/2012 34 34.04 32.735 32.98 7415658 4/20/2012 33.955 35.2 33.75 34.48 8703340 4/19/2012 35.18 35.445 33.9 33.9 13361916 Kind regards,
Hugo Garcia
On Thursday, May 31, 2012 1:23:02 AM UTC+2, Karolina (Google Finance team) wrote:
> Hello Hugo, which stocks in particular?
> On Wednesday, May 30, 2012 9:15:22 AM UTC-7, Hugo Blanc wrote:
>> I have reported many stocks from the Frankfurt stock market that have >> all incorrect data (historical and stock prices)! >> Does someone know why is this happening? >> Thanks,
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Hugo Blanc <hugo.bl... @gmail.com>
Date: Thu, 31 May 2012 02:40:43 -0700 (PDT)
Local: Thurs, May 31 2012 5:40 am
Subject: Re: Frankfurt stock prices are incorrect
for BMW, Google data:
DateOpenHighLowCloseVolumeMay 30, 201263.7063.7061.7962.123,048May 29, 2012 62.9164.7162.9064.008,959May 28, 201262.4363.1062.1262.382,226May 25, 2012 62.0062.6061.4961.823,606May 24, 201262.5262.7361.4061.709,607May 23, 2012 62.5562.8061.6762.079,153May 22, 201262.3263.5962.3263.439,428May 21, 2012 60.8662.5560.8661.927,919May 18, 201261.3462.1260.9360.9417,844May 17, 2012 64.5064.8362.6062.8318,564May 16, 201265.6666.9264.6666.2813,347May 15, 2012 66.7867.2865.7266.2221,390May 14, 201266.9567.2366.0066.6119,445May 11, 2012 65.9767.5065.6667.2115,293May 10, 201268.0068.3266.0066.4217,070May 9, 2012 67.7568.3766.3667.7514,764May 8, 201270.3970.3966.9667.8628,394May 7, 2012 67.8070.4066.9570.4028,057May 4, 201271.3071.8068.7469.3312,791May 3, 2012 72.5073.9071.2571.6080,085May 2, 201272.6272.8970.2871.4810,571Apr 30, 2012 72.1272.6471.7371.8311,224Apr 27, 201270.9072.4670.5772.0613,688Apr 26, 2012 69.5171.3869.5171.0015,282Apr 25, 201267.8070.0067.6869.7013,698Apr 24, 2012 67.4268.0367.3867.427,388Apr 23, 201269.4469.4466.4567.2916,275Apr 20, 2012 68.4069.8968.0369.5614,535Apr 19, 201269.5570.0268.2868.2821,060Apr 18, 2012 69.7570.3668.9969.3813,477 and the correct data:
Timestamp Trade Open Trade High Trade Low Trade Close Trade Volume
5/30/2012 63.61 63.74 61.66 62.01 2858769 5/29/2012 63.13 64.79 62.98 64 2426478 5/28/2012 62.44 63.42 62.02 62.28 1201981 5/25/2012 62.01 62.62 61.4 61.9 1634898 5/24/2012 62.44 62.58 61.25 61.98 2459775 5/23/2012 62.71 62.83 61.53 61.81 2670776 5/22/2012 62.77 63.76 62.48 63.43 2880567 5/21/2012 61.48 62.66 61.39 61.77 2362798 5/18/2012 61.81 62.24 61.02 61.31 4288518 5/17/2012 64.8 64.88 62.37 62.73 2629253 5/16/2012 65.31 67.16 64.57 66.53 4103589 5/15/2012 66.95 67.3 65.5 66.17 2965273 5/14/2012 67.23 67.35 65.91 66.44 2222874 5/11/2012 65.82 67.6 65.51 67.6 2729961 5/10/2012 68.1 68.28 65.9 66.24 4070960 5/9/2012 67.8 68.5 66.36 67.7 2938800 5/8/2012 69.3 69.73 66.88 67.35 2917030 5/7/2012 67.1 70.25 66.89 70.05 2454028 5/4/2012 71.62 71.86 68.73 68.99 2956169 5/3/2012 71.81 73.95 71.11 71.68 5130666 5/2/2012 72.64 72.91 70.29 71.07 2681607 4/30/2012 72.31 72.67 71.61 71.81 1892410 4/27/2012 70.8 72.5 70.51 72.13 2623097 4/26/2012 69.63 71.44 69.3 71.25 3749825 4/25/2012 67.95 70.08 67.83 69.68 2337231 4/24/2012 67.3 68.11 66.97 67.6 1937241 4/23/2012 68.8 68.84 66.4 67 2617648 4/20/2012 68.41 69.97 67.82 69.84 2618937 4/19/2012 69.79 70.25 68.25 68.32 2865183
On Thursday, May 31, 2012 10:29:01 AM UTC+2, Hugo Blanc wrote:
> Deutsche Bank, BMW, for instance. This is the data shown by Google Finance: > http://www.google.com/finance/historical?q=FRA:DBK <http://www.google.com/finance/historical?q=FRA:DBK >
> May 30, 201229.0129.4128.5828.9538,432May 29, 201229.2129.5128.7529.15 > 25,323May 28, 201229.6029.8629.0029.1120,470May 25, 201229.0029.7128.82 > 29.3071,805May 24, 201229.1729.2928.5828.8829,387May 23, 201229.0529.29 > 28.6528.9541,570May 22, 201229.4529.7628.6529.5841,619May 21, 201228.42 > 29.0528.4228.9530,602May 18, 201227.7129.3227.7128.5057,956May 17, 2012 > 29.1029.1927.7928.4340,695May 16, 201229.0029.6528.6328.6967,210May 15, > 201229.9030.3129.0829.2475,523May 14, 201230.7930.8029.7330.0052,792May > 11, 201230.8031.2530.1030.8839,397May 10, 201230.6331.7030.3631.2851,391May > 9, 201231.0031.0029.8030.5050,307May 8, 201231.7731.7730.5030.5369,336May > 7, 201229.9031.8529.9031.8270,649May 4, 201231.1031.8630.6931.1555,757May > 3, 201232.2332.3030.9631.1660,891May 2, 201233.2133.4931.7832.2867,779Apr > 30, 201233.5333.7832.8532.9033,167Apr 27, 201232.8034.0132.1833.4855,593Apr > 26, 201233.6533.9532.0733.2587,088Apr 25, 201233.6534.6833.5734.3237,336Apr > 24, 201233.2533.5832.2433.3757,874Apr 23, 201234.0534.1032.7433.2054,710Apr > 20, 201233.8335.0733.7834.3027,571Apr 19, 201234.7035.3433.7033.7052,861Apr > 18, 201235.3835.5234.5834.6828,469
> and this is the correct data:
> Timestamp Trade Open Trade High Trade Low Trade Close Trade Volume
> 5/30/2012 28.925 29.48 28.52 28.825 6637968 5/29/2012 29.45 29.54 28.74 > 29.23 5698037 5/28/2012 29.695 29.89 29.055 29.165 3830628 5/25/2012 > 29.15 29.73 29.05 29.39 6928389 5/24/2012 29.2 29.315 28.55 29.08 6282706 > 5/23/2012 28.85 29.34 28.64 28.84 7296851 5/22/2012 29.195 29.8 28.625 > 29.66 6987335 5/21/2012 28.465 29.055 28.4 28.95 6856715 5/18/2012 28 > 29.35 27.95 28.465 10142295 5/17/2012 29.075 29.24 27.735 28.49 6968699 > 5/16/2012 28.85 29.645 28.58 29.06 9024640 5/15/2012 30.05 30.34 29.065 > 29.375 8330572 5/14/2012 30.79 30.79 29.715 29.88 7352262 5/11/2012 30.7 > 31.29 30.09 31.165 8642839 5/10/2012 30.74 31.705 30.33 31.23 8676043 > 5/9/2012 30.875 30.9 29.785 30.415 8196361 5/8/2012 31.55 31.55 30.55 > 30.76 6375881 5/7/2012 30.05 31.635 29.91 31.55 6719768 5/4/2012 31 > 31.915 30.58 31.08 8167601 5/3/2012 32.105 32.41 30.985 31.23 10115112 > 5/2/2012 33.48 33.5 31.75 32.06 8949308 4/30/2012 33.57 33.655 32.775 > 32.87 6226946 4/27/2012 32.2 34.04 32.11 33.5 9220939 4/26/2012 33.46 > 33.61 32.075 33.195 12970170 4/25/2012 33.81 34.745 33.805 34.135 7274274 > 4/24/2012 33.265 33.59 32.235 33.42 7233783 4/23/2012 34 34.04 32.735 > 32.98 7415658 4/20/2012 33.955 35.2 33.75 34.48 8703340 4/19/2012 35.18 > 35.445 33.9 33.9 13361916 > Kind regards,
> Hugo Garcia
> On Thursday, May 31, 2012 1:23:02 AM UTC+2, Karolina (Google Finance team) > wrote:
>> Hello Hugo, which stocks in particular?
>> On Wednesday, May 30, 2012 9:15:22 AM UTC-7, Hugo Blanc wrote:
>>> I have reported many stocks from the Frankfurt stock market that have >>> all incorrect data (historical and stock prices)! >>> Does someone know why is this happening? >>> Thanks,
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Hugo Blanc <hugo.bl... @gmail.com>
Date: Mon, 4 Jun 2012 14:39:22 -0700 (PDT)
Local: Mon, Jun 4 2012 5:39 pm
Subject: Re: Frankfurt stock prices are incorrect
No answer? Google still shows wrong data for the Frankfurt market everyday. Nobody has realized? I can't believe it!
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
"Karolina (Google Finance team)" <k... @google.com>
Date: Wed, 6 Jun 2012 14:53:03 -0700 (PDT)
Local: Wed, Jun 6 2012 5:53 pm
Subject: Re: Frankfurt stock prices are incorrect
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Bas de Kort <basdekort1... @gmail.com>
Date: Fri, 1 Feb 2013 06:53:12 -0800 (PST)
Local: Fri, Feb 1 2013 9:53 am
Subject: Re: Frankfurt stock prices are incorrect
Hi,
I have a similar problem. This query "GoogleFinance("MT"; "price")" gives me currently a price of 17,33. This is the NYSE listing for the Arcelor Mittal fund (http://www.google.com/finance?q=NYSE%3AMT ). I need to have the AMS listing (http://www.google.com/finance?q=AMS%3AMT ) in my Google spreadsheet. The current price there is 12,85. Kind of a difference...
Using the query "GoogleFinance("AMS:MT"; "price")" gives a N/A value. Is there an instruction on how to get the quote from another listing please? (encoding the colon as %3A also does not work btw)
Many thanks!
Op woensdag 6 juni 2012 23:53:03 UTC+2 schreef Karolina (Google Finance team) het volgende:
You must
Sign in before you can post messages.
You do not have the permission required to post.