5 New Messages
Digest #2817
Messages
Fri Oct 18, 2013 8:37 pm (PDT) . Posted by:
kkkutty
Hi Randy, I'm just trying to understand this...
When I go this website for retail data:
http://www.census.gov/retail/marts/www/download/text/adv44000.txt http://www.census.gov/retail/marts/www/download/text/adv44000.txt
I can see the data I want to extract.
However, when I use the RCHgetwebdata function to extract data, I get this as part of the extraction even though I can see the data I want to extract:
"Due to congressional requirements, the federal government has shut down. All Census Bureau data is now offline until the bureau is reopened"
Why is that? How am I able to view the static data, but not extract it? Am I using the wrong function? Thanks in advance!
When I go this website for retail data:
http://www.census.
I can see the data I want to extract.
However, when I use the RCHgetwebdata function to extract data, I get this as part of the extraction even though I can see the data I want to extract:
"Due to congressional requirements, the federal government has shut down. All Census Bureau data is now offline until the bureau is reopened"
Why is that? How am I able to view the static data, but not extract it? Am I using the wrong function? Thanks in advance!
Fri Oct 18, 2013 9:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. This works fine for me:
=RCHGetWebData("
http://www.census.gov/retail/marts/www/download/text/adv44000.txt")
When you say you went to the website to view the data, were you using IE?
If not, maybe you have a cached page and need to change your Internet
Options to make sure IE always gets a fresh copy of the web page...
This might be a better way to extract the data, since it will at least
convert it into rows of data:
=smfGetCSVFile("
http://www.census.gov/retail/marts/www/download/text/adv44000.txt")
On Fri, Oct 18, 2013 at 8:37 PM, <kkkutty@yahoo.com> wrote:
>
> Hi Randy, I'm just trying to understand this...
>
> When I go this website for retail data:
>
> http://www.census.gov/retail/marts/www/download/text/adv44000.txt
>
> I can see the data I want to extract.
>
> However, when I use the RCHgetwebdata function to extract data, I get this
> as part of the extraction even though I can see the data I want to extract:
>
> "Due to congressional requirements, the federal government has shut down.
> All Census Bureau data is now offline until the bureau is reopened"
>
> Why is that? How am I able to view the static data, but not extract it?
> Am I using the wrong function? Thanks in advance!
>
=RCHGetWebData(
http://www.census.
When you say you went to the website to view the data, were you using IE?
If not, maybe you have a cached page and need to change your Internet
Options to make sure IE always gets a fresh copy of the web page...
This might be a better way to extract the data, since it will at least
convert it into rows of data:
=smfGetCSVFile(
http://www.census.
On Fri, Oct 18, 2013 at 8:37 PM, <kkkutty@yahoo.
>
> Hi Randy, I'm just trying to understand this...
>
> When I go this website for retail data:
>
> http://www.census.
>
> I can see the data I want to extract.
>
> However, when I use the RCHgetwebdata function to extract data, I get this
> as part of the extraction even though I can see the data I want to extract:
>
> "Due to congressional requirements, the federal government has shut down.
> All Census Bureau data is now offline until the bureau is reopened"
>
> Why is that? How am I able to view the static data, but not extract it?
> Am I using the wrong function? Thanks in advance!
>
Fri Oct 18, 2013 10:01 pm (PDT) . Posted by:
kkkutty
It was the cache settings...could have sworn I set this awhile ago. I'm not sure why it changed. Thanks for the advice as always.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Not sure what to tell you. This works fine for me:
=RCHGetWebData("http://www.census.gov/retail/marts/www/download/text/adv44000.txt http://www.census.gov/retail/marts/www/download/text/adv44000.txt")
When you say you went to the website to view the data, were you using IE? If not, maybe you have a cached page and need to change your Internet Options to make sure IE always gets a fresh copy of the web page...
This might be a better way to extract the data, since it will at least convert it into rows of data:
=smfGetCSVFile("http://www.census.gov/retail/marts/www/download/text/adv44000.txt http://www.census.gov/retail/marts/www/download/text/adv44000.txt")
On Fri, Oct 18, 2013 at 8:37 PM, <kkkutty@... mailto:kkkutty@...> wrote:
Hi Randy, I'm just trying to understand this...
When I go this website for retail data:
http://www.census.gov/retail/marts/www/download/text/adv44000.txt http://www.census.gov/retail/marts/www/download/text/adv44000.txt
I can see the data I want to extract.
However, when I use the RCHgetwebdata function to extract data, I get this as part of the extraction even though I can see the data I want to extract:
"Due to congressional requirements, the federal government has shut down. All Census Bureau data is now offline until the bureau is reopened"
Why is that? How am I able to view the static data, but not extract it? Am I using the wrong function? Thanks in advance!
---In smf_addin@yahoogrou
Not sure what to tell you. This works fine for me:
=RCHGetWebData(
When you say you went to the website to view the data, were you using IE? If not, maybe you have a cached page and need to change your Internet Options to make sure IE always gets a fresh copy of the web page...
This might be a better way to extract the data, since it will at least convert it into rows of data:
=smfGetCSVFile(
On Fri, Oct 18, 2013 at 8:37 PM, <kkkutty@
Hi Randy, I'm just trying to understand this...
When I go this website for retail data:
http://www.census.
I can see the data I want to extract.
However, when I use the RCHgetwebdata function to extract data, I get this as part of the extraction even though I can see the data I want to extract:
"Due to congressional requirements, the federal government has shut down. All Census Bureau data is now offline until the bureau is reopened"
Why is that? How am I able to view the static data, but not extract it? Am I using the wrong function? Thanks in advance!
Fri Oct 18, 2013 10:28 pm (PDT) . Posted by:
tenenbaum88
Hi Randy,
I've been using the following function call:
=RCHGetYahooHistory(V$2,,,,,,,,"A",0,0,,253,2)
to get the past year of adjusted close price data from the ticker in the above cell reference. However, I've noticed that sometimes it instead returns the unadjusted close price data. In fact, if I repeatedly update this function call, it appears to randomly return either the adjusted or unadjusted data. I've tried using different versions of the function call, as well, but the results are the same. Have you ever seen this type of behavior before or have any idea of what might be causing this?
I've been using the following function call:
=RCHGetYahooHistory
to get the past year of adjusted close price data from the ticker in the above cell reference. However, I've noticed that sometimes it instead returns the unadjusted close price data. In fact, if I repeatedly update this function call, it appears to randomly return either the adjusted or unadjusted data. I've tried using different versions of the function call, as well, but the results are the same. Have you ever seen this type of behavior before or have any idea of what might be causing this?
Fri Oct 18, 2013 10:52 pm (PDT) . Posted by:
tenenbaum88
Ok, the plot thickens.
The good news is that this doesn't seem to be a problem with the smf_addin. The bad news is that this is a Yahoo problem. I have been experimenting with manually downloading a year's worth of daily data for the ticker 'HYLD' and am randomly getting different csv files from Yahoo. Some of them are correctly calculating the 'Adj Close' field and some are returning the 'Close' field data in the 'Adj Close' column.
This is insanely frustrating to say the least since it casts an enormous amount of doubt on any calculations using Yahoo's historical data. Can anyone else please confirm that they are able to replicate this issue?
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Hi Randy,
I've been using the following function call:
=RCHGetYahooHistory(V$2,,,,,,,,"A",0,0,,253,2)
to get the past year of adjusted close price data from the ticker in the above cell reference. However, I've noticed that sometimes it instead returns the unadjusted close price data. In fact, if I repeatedly update this function call, it appears to randomly return either the adjusted or unadjusted data. I've tried using different versions of the function call, as well, but the results are the same. Have you ever seen this type of behavior before or have any idea of what might be causing this?
The good news is that this doesn't seem to be a problem with the smf_addin. The bad news is that this is a Yahoo problem. I have been experimenting with manually downloading a year's worth of daily data for the ticker 'HYLD' and am randomly getting different csv files from Yahoo. Some of them are correctly calculating the 'Adj Close' field and some are returning the 'Close&#
This is insanely frustrating to say the least since it casts an enormous amount of doubt on any calculations using Yahoo's historical data. Can anyone else please confirm that they are able to replicate this issue?
---In smf_addin@yahoogrou
Hi Randy,
I've been using the following function call:
=RCHGetYahooHistory
to get the past year of adjusted close price data from the ticker in the above cell reference. However, I've noticed that sometimes it instead returns the unadjusted close price data. In fact, if I repeatedly update this function call, it appears to randomly return either the adjusted or unadjusted data. I've tried using different versions of the function call, as well, but the results are the same. Have you ever seen this type of behavior before or have any idea of what might be causing this?
Tidak ada komentar:
Posting Komentar