9 New Messages
Digest #2338
| |
Messages
Wed Sep 5, 2012 11:48 am (PDT) . Posted by:
"Cullen Rogers" cullenrogers
I'm trying to snag data off of Hoovers - revenue for example - but the data doesn't seem to be in a table so it is not fetching it properly. Any ideas?
Wed Sep 5, 2012 11:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Without a sample URL, I can only guess what you're looking at. But this
works for me:
=RCHGetTableCell("
http://www.hoovers.com/company/3M_Company/rrffyi-1-1njht4-1njhft.html
",1,">Revenue")
On Wed, Sep 5, 2012 at 11:09 AM, Cullen Rogers <cullenrogers@yahoo.com >wrote:
> I'm trying to snag data off of Hoovers - revenue for example - but the
> data doesn't seem to be in a table so it is not fetching it properly. Any
> ideas?
>
works for me:
=RCHGetTableCell(
http://www.hoovers.
",1,">Revenue"
On Wed, Sep 5, 2012 at 11:09 AM, Cullen Rogers <cullenrogers@
> I'm trying to snag data off of Hoovers - revenue for example - but the
> data doesn't seem to be in a table so it is not fetching it properly. Any
> ideas?
>
Wed Sep 5, 2012 12:03 pm (PDT) . Posted by:
"whitney" thelancour
Randy, Thanks a Million! That really helped. Referring to the other post about the real URL, is that how you were able to find the URL I needed with Firefox?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> When I right-click on the table in FireFox, the context menu has a sub-menu
> called "This Frame". On the sub-menu, there is an option similar to IE,
> called "View Frame Info". However, I usually just pick the option to show
> the frame in a new tab.
>
> On Mon, Sep 3, 2012 at 2:50 PM, Ron Spruell <hashky@...> wrote:
>
> >
> > You have given me this answer before. How do I find the "real" URL. If I
> > am using IE, I right click on the frame and click on Properties. That
> > gives me the correct URL.
> >
> > How do I find it in Firefox?
> >
>
--- In smf_addin@yahoogrou
>
> When I right-click on the table in FireFox, the context menu has a sub-menu
> called "This Frame". On the sub-menu, there is an option similar to IE,
> called "View Frame Info". However, I usually just pick the option to show
> the frame in a new tab.
>
> On Mon, Sep 3, 2012 at 2:50 PM, Ron Spruell <hashky@...> wrote:
>
> >
> > You have given me this answer before. How do I find the "real" URL. If I
> > am using IE, I right click on the frame and click on Properties. That
> > gives me the correct URL.
> >
> > How do I find it in Firefox?
> >
>
Wed Sep 5, 2012 12:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yes.
On Wed, Sep 5, 2012 at 12:03 PM, whitney <thelancour@yahoo.com > wrote:
> Randy, Thanks a Million! That really helped. Referring to the other post
> about the real URL, is that how you were able to find the URL I needed with
> Firefox?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > When I right-click on the table in FireFox, the context menu has a
> sub-menu
> > called "This Frame". On the sub-menu, there is an option similar to IE,
> > called "View Frame Info". However, I usually just pick the option to show
> > the frame in a new tab.
>
On Wed, Sep 5, 2012 at 12:03 PM, whitney <thelancour@yahoo.
> Randy, Thanks a Million! That really helped. Referring to the other post
> about the real URL, is that how you were able to find the URL I needed with
> Firefox?
>
> --- In smf_addin@yahoogrou
> >
> > When I right-click on the table in FireFox, the context menu has a
> sub-menu
> > called "This Frame". On the sub-menu, there is an option similar to IE,
> > called "View Frame Info". However, I usually just pick the option to show
> > the frame in a new tab.
>
Wed Sep 5, 2012 7:01 pm (PDT) . Posted by:
"Ken W" ericthered1974
Wed Sep 5, 2012 10:49 pm (PDT) . Posted by:
"Stephan Moebius" spikemgm
Hi Randy,
I tried using the following, in an array for data yesterday.
=RCHGetYahooHistory("SPY",,,,,,,,"d1ohgal1v",0,,1,2,1)
It only returned the date. but if I run each cell with one code it works
except for low price which returns nothing, but if I substitute l1 instead
of g it returns yesterdays low and you have to use al1 to get last price.
Today's data works fine
=RCHGetYahooQuotes("spy","d1ohgl1v")
Any help,
Thanks
Steve
On Fri, Aug 31, 2012 at 8:03 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Either of the following should do the trick:
>
> =RCHGetYahooHistory("SPY",,,,,,,,"O",0,,1,10,1)
> =INDEX(RCHGetYahooHistory("SPY",,,,,,,,"O",0,,,10,1),10,1)
>
>
> On Fri, Aug 31, 2012 at 7:37 PM, MoeB <smoebius@gmail.com > wrote:
>
>>
>> I'm using this one you posted for average volume for 10days,and it works
>> great.
>>
>> =AVERAGE(RCHGetYahooHistory("SPY",,,,,,,,"V",0,,,10,1))
>>
>> Now I'm trying to get just the open price for spy 10 days ago.
>> I removed AVERAGE and replaced V with "O",,,,10)) and it brings up todays
>> open.
>>
>> Do i need to use the smfpricesbydates? something like (opentoday-9).
>>
>> So, the data will change everyday.
>>
>
>
>
I tried using the following, in an array for data yesterday.
=RCHGetYahooHistory
It only returned the date. but if I run each cell with one code it works
except for low price which returns nothing, but if I substitute l1 instead
of g it returns yesterdays low and you have to use al1 to get last price.
Today's data works fine
=RCHGetYahooQuotes(
Any help,
Thanks
Steve
On Fri, Aug 31, 2012 at 8:03 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Either of the following should do the trick:
>
> =RCHGetYahooHistory
> =INDEX(RCHGetYahooH
>
>
> On Fri, Aug 31, 2012 at 7:37 PM, MoeB <smoebius@gmail.
>
>>
>> I'm using this one you posted for average volume for 10days,and it works
>> great.
>>
>> =AVERAGE(RCHGetYaho
>>
>> Now I'm trying to get just the open price for spy 10 days ago.
>> I removed AVERAGE and replaced V with "O",,,,10)) and it brings up todays
>> open.
>>
>> Do i need to use the smfpricesbydates? something like (opentoday-9)
>>
>> So, the data will change everyday.
>>
>
>
>
Wed Sep 5, 2012 11:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check the documentation for the two functions -- they don't use the same
Yahoo codes.
RCHGetYahooQuotes() has dozens of items available. RCHGetYahooHistory()
only has five things available, although it can also return dividend
history.
Since your pDim2 value is "1" for the function, it will only return a
single data item for each row -- which will be the date, since "d" was the
first byte of your pItems value.
In most cases, the pDim1 and pDim2 parameters aren't used -- they're set to
be the size of the range that the function is array-entered over. So there
really is only a need to use them when you need the entire array for some
other function to process -- SUM, AVERAGE, INDEX, etc.
Just what are you trying to accomplish?
On Wed, Sep 5, 2012 at 10:49 PM, Stephan Moebius <smoebius@gmail.com > wrote:
>
> I tried using the following, in an array for data yesterday.
>
> =RCHGetYahooHistory("SPY",,,,,,,,"d1ohgal1v",0,,1,2,1)
>
> It only returned the date. but if I run each cell with one code it works
> except for low price which returns nothing, but if I substitute l1 instead
> of g it returns yesterdays low and you have to use al1 to get last price.
>
> Today's data works fine
> =RCHGetYahooQuotes("spy","d1ohgl1v")
>
>
Yahoo codes.
RCHGetYahooQuotes(
only has five things available, although it can also return dividend
history.
Since your pDim2 value is "1" for the function, it will only return a
single data item for each row -- which will be the date, since "d" was the
first byte of your pItems value.
In most cases, the pDim1 and pDim2 parameters aren't used -- they're set to
be the size of the range that the function is array-entered over. So there
really is only a need to use them when you need the entire array for some
other function to process -- SUM, AVERAGE, INDEX, etc.
Just what are you trying to accomplish?
On Wed, Sep 5, 2012 at 10:49 PM, Stephan Moebius <smoebius@gmail.
>
> I tried using the following, in an array for data yesterday.
>
> =RCHGetYahooHistory
>
> It only returned the date. but if I run each cell with one code it works
> except for low price which returns nothing, but if I substitute l1 instead
> of g it returns yesterdays low and you have to use al1 to get last price.
>
> Today's data works fine
> =RCHGetYahooQuotes(
>
>
Thu Sep 6, 2012 12:49 am (PDT) . Posted by:
"Stephan Moebius" spikemgm
One sheet i have is a range pivot system, right now i copy and paste
history into it and i'd like to automate the 7days data.
*SPY
Close
is lower* Date Open High Low Close Volume Hourly High Low
Open to Open
to Open to Stop Trend Volume Range Close Range High Range Low
Range Reverse 141.09 141.73 1 9/5/2012 141.09 141.47 140.63
140.91 100499300 15,461,431 0.84 -0.18 +0.38 -0.46 -140.45 2 9/4/2012
141.04 141.46 140.13 141.03 120056100 18,470,169 1.33 -0.01 +0.42 -0.91
142.01 3 8/31/2012 141.29 141.82 140.36 141.16 151907200 23,370,338 1.46
-0.13 +0.53 -0.93 141.79 4 8/30/2012 140.9 140.94 140.19 140.49 96589900
14,859,985 0.75 -0.41 +0.04 -0.71 141.41 5 8/29/2012 141.52 141.89 141.12
141.51 65421300 10,064,815 0.77 -0.01 +0.37 -0.40 -140.80 6 8/28/2012
141.18 141.84 140.97 141.4 75689600 11,644,554 0.87 +0.22 +0.66 -0.21
-140.69 7 8/27/2012 141.89 142.08 141.34 141.54 68785900 10,582,446 0.74
-0.35 +0.19 -0.55 #REF! +0.37 *-0.60* 7Day AVG 141.64 140.68
141.15 96,992,757 14,921,963 *0.97* Bitmap Avg price 7 days 141.16
remove H/L *Close is lower than previous close* 0.96 high x2
low close pivot r1 s1
141.47 282.94 140.63 140.91 141.12 141.61 140.77 Pivot
Points Demark #'s Fibonacci Day Range R3 142.68 33% High
141.47 0.000 R2 141.84 50% 141.15 0.382 0.72 R1 *141.38* 70%
*141.61* Close 140.91 Pivot *141.00* *141.12* Middle *141.05*
0.500 Avg Pivots / Vwap *141.06* Close 140.91 S1 *140.54* 70% *
140.77* 140.95 0.618 Short at 141.73 S2 140.16 50% Low
140.63 0.100 S3 139.32 33% The Stretch
On Wed, Sep 5, 2012 at 11:50 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Check the documentation for the two functions -- they don't use the same
> Yahoo codes.
>
> RCHGetYahooQuotes() has dozens of items available. RCHGetYahooHistory()
> only has five things available, although it can also return dividend
> history.
>
> Since your pDim2 value is "1" for the function, it will only return a
> single data item for each row -- which will be the date, since "d" was the
> first byte of your pItems value.
>
> In most cases, the pDim1 and pDim2 parameters aren't used -- they're set
> to be the size of the range that the function is array-entered over. So
> there really is only a need to use them when you need the entire array for
> some other function to process -- SUM, AVERAGE, INDEX, etc.
>
> Just what are you trying to accomplish?
>
>
> On Wed, Sep 5, 2012 at 10:49 PM, Stephan Moebius <smoebius@gmail.com >wrote:
>
>>
>> I tried using the following, in an array for data yesterday.
>>
>> =RCHGetYahooHistory("SPY",,,,,,,,"d1ohgal1v",0,,1,2,1)
>>
>> It only returned the date. but if I run each cell with one code it works
>> except for low price which returns nothing, but if I substitute l1 instead
>> of g it returns yesterdays low and you have to use al1 to get last price.
>>
>> Today's data works fine
>> =RCHGetYahooQuotes("spy","d1ohgl1v")
>>
>>
>
>
>
history into it and i'd like to automate the 7days data.
*SPY
Close
is lower* Date Open High Low Close Volume Hourly High Low
Open to Open
to Open to Stop Trend Volume Range Close Range High Range Low
Range Reverse 141.09 141.73 1 9/5/2012 141.09 141.47 140.63
140.91 100499300 15,461,431 0.84 -0.18 +0.38 -0.46 -140.45 2 9/4/2012
141.04 141.46 140.13 141.03 120056100 18,470,169 1.33 -0.01 +0.42 -0.91
142.01 3 8/31/2012 141.29 141.82 140.36 141.16 151907200 23,370,338 1.46
-0.13 +0.53 -0.93 141.79 4 8/30/2012 140.9 140.94 140.19 140.49 96589900
14,859,985 0.75 -0.41 +0.04 -0.71 141.41 5 8/29/2012 141.52 141.89 141.12
141.51 65421300 10,064,815 0.77 -0.01 +0.37 -0.40 -140.80 6 8/28/2012
141.18 141.84 140.97 141.4 75689600 11,644,554 0.87 +0.22 +0.66 -0.21
-140.69 7 8/27/2012 141.89 142.08 141.34 141.54 68785900 10,582,446 0.74
-0.35 +0.19 -0.55 #REF! +0.37 *-0.60* 7Day AVG 141.64 140.68
141.15 96,992,757 14,921,963 *0.97* Bitmap Avg price 7 days 141.16
remove H/L *Close is lower than previous close* 0.96 high x2
low close pivot r1 s1
141.47 282.94 140.63 140.91 141.12 141.61 140.77 Pivot
Points Demark #'s Fibonacci Day Range R3 142.68 33% High
141.47 0.000 R2 141.84 50% 141.15 0.382 0.72 R1 *141.38* 70%
*141.61* Close 140.91 Pivot *141.00* *141.12* Middle *141.05*
0.500 Avg Pivots / Vwap *141.06* Close 140.91 S1 *140.54* 70% *
140.77* 140.95 0.618 Short at 141.73 S2 140.16 50% Low
140.63 0.100 S3 139.32 33% The Stretch
On Wed, Sep 5, 2012 at 11:50 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Check the documentation for the two functions -- they don't use the same
> Yahoo codes.
>
> RCHGetYahooQuotes(
> only has five things available, although it can also return dividend
> history.
>
> Since your pDim2 value is "1" for the function, it will only return a
> single data item for each row -- which will be the date, since "d" was the
> first byte of your pItems value.
>
> In most cases, the pDim1 and pDim2 parameters aren't used -- they're set
> to be the size of the range that the function is array-entered over. So
> there really is only a need to use them when you need the entire array for
> some other function to process -- SUM, AVERAGE, INDEX, etc.
>
> Just what are you trying to accomplish?
>
>
> On Wed, Sep 5, 2012 at 10:49 PM, Stephan Moebius <smoebius@gmail.
>
>>
>> I tried using the following, in an array for data yesterday.
>>
>> =RCHGetYahooHistory
>>
>> It only returned the date. but if I run each cell with one code it works
>> except for low price which returns nothing, but if I substitute l1 instead
>> of g it returns yesterdays low and you have to use al1 to get last price.
>>
>> Today's data works fine
>> =RCHGetYahooQuotes(
>>
>>
>
>
>
Thu Sep 6, 2012 1:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you just need the last 7 days of historical quotes, just array-enter:
=RCHGetYahooHistory("SPY",,,,,,,,,,1)
....over an 8-row by 6-column range.
On Thu, Sep 6, 2012 at 12:49 AM, Stephan Moebius <smoebius@gmail.com > wrote:
>
> One sheet i have is a range pivot system, right now i copy and paste
> history into it and i'd like to automate the 7days data.
>
=RCHGetYahooHistory
....over an 8-row by 6-column range.
On Thu, Sep 6, 2012 at 12:49 AM, Stephan Moebius <smoebius@gmail.
>
> One sheet i have is a range pivot system, right now i copy and paste
> history into it and i'd like to automate the 7days data.
>
Tidak ada komentar:
Posting Komentar