6 New Messages
Digest #2342
| 1b Re: rchcreatecomment to get chart for "http://www.bloomberg.com/quot by "Randy Harmelink" rharmelink 2b Re: Using VBA to read RCHGetYahooHistory into an array by "zarathustra_winced@yahoo.com" zarathustra_winced |
Messages
Mon Sep 10, 2012 7:07 am (PDT) . Posted by:
"boo1712" boo1712
Dear All,
Any of you guys is able to use rchcreatecomment to display the picture file for "http://www.bloomberg.com/quote/FARBAST:IND " into excel?
This used to work in the past
=rchcreatecomment("http://www.bloomberg.com/apps/chart?h=152&w=240&range=5y&type=gp_line&cfg=BQuote.xml&ticks=FARBAST:IND ",99,240,152,1,,)
Thanks alot for reading my email.
Terry
Any of you guys is able to use rchcreatecomment to display the picture file for "http://www.bloomber
This used to work in the past
=rchcreatecomment(
Thanks alot for reading my email.
Terry
Mon Sep 10, 2012 8:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, they changed the displayed chart from an image to an
interactive object...
On Mon, Sep 10, 2012 at 7:07 AM, boo1712 <boo1712@yahoo.co.uk > wrote:
>
> Any of you guys is able to use rchcreatecomment to display the picture
> file for "http://www.bloomberg.com/quote/FARBAST:IND " into excel?
>
> This used to work in the past
> =rchcreatecomment("
> http://www.bloomberg.com/apps/chart?h=152&w=240&range=5y&type=gp_line&cfg=BQuote.xml&ticks=FARBAST:IND
> ",99,240,152,1,,)
>
> Thanks alot for reading my email.
>
interactive object...
On Mon, Sep 10, 2012 at 7:07 AM, boo1712 <boo1712@yahoo.
>
> Any of you guys is able to use rchcreatecomment to display the picture
> file for "http://www.bloomber
>
> This used to work in the past
> =rchcreatecomment(
> http://www.bloomber
> ",99,240,152,
>
> Thanks alot for reading my email.
>
Mon Sep 10, 2012 11:45 am (PDT) . Posted by:
"ds5ec" ds5ec
Hello, firstly I'd like to says thanks for providing such a useful set of functions.
I'm not sure if RCHGetYahooHistory was intended to be read into an array but it has been working. I have a loop that runs once for each stock I'm interested in. The data is read into the array in the line below:
SP500Array = RCHGetYahooHistory(StockName, _
pResort:=0, _
pNames:=0, _
pItems:="DOHLCAV", _
pAdjust:=1, _
pDim1:=270, _
pDim2:=7)
The array is dimensioned as Public SP500Array() As Variant. The data is processed for each StockName and stored, then StockName is updated and the process repeated. I recently increased the number of stocks and found that at the 70th stock the function return no data in all elements from 238 (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred on the 75th stock.
Should I not use the function this way or would you expect it to work.
Thanks, David
I'm not sure if RCHGetYahooHistory was intended to be read into an array but it has been working. I have a loop that runs once for each stock I'm interested in. The data is read into the array in the line below:
SP500Array = RCHGetYahooHistory(
pResort:=0, _
pNames:=0, _
pItems:="DOHLCAV"
pAdjust:=1, _
pDim1:=270, _
pDim2:=7)
The array is dimensioned as Public SP500Array() As Variant. The data is processed for each StockName and stored, then StockName is updated and the process repeated. I recently increased the number of stocks and found that at the 70th stock the function return no data in all elements from 238 (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred on the 75th stock.
Should I not use the function this way or would you expect it to work.
Thanks, David
Mon Sep 10, 2012 11:51 am (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
Do the stocks have enough history to fill the array?
Sent via BlackBerry by AT&T
-----Original Message-----
From: "ds5ec" <ds5ec@yahoo.com >
Sender: smf_addin@yahoogroups.com
Date: Mon, 10 Sep 2012 18:23:18
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: [smf_addin] Using VBA to read RCHGetYahooHistory into an array
Hello, firstly I'd like to says thanks for providing such a useful set of functions.
I'm not sure if RCHGetYahooHistory was intended to be read into an array but it has been working. I have a loop that runs once for each stock I'm interested in. The data is read into the array in the line below:
SP500Array = RCHGetYahooHistory(StockName, _
pResort:=0, _
pNames:=0, _
pItems:="DOHLCAV", _
pAdjust:=1, _
pDim1:=270, _
pDim2:=7)
The array is dimensioned as Public SP500Array() As Variant. The data is processed for each StockName and stored, then StockName is updated and the process repeated. I recently increased the number of stocks and found that at the 70th stock the function return no data in all elements from 238 (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred on the 75th stock.
Should I not use the function this way or would you expect it to work.
Thanks, David
------------------------------------
Yahoo! Groups Links
Sent via BlackBerry by AT&T
-----Original Message-----
From: "ds5ec" <ds5ec@yahoo.
Sender: smf_addin@yahoogrou
Date: Mon, 10 Sep 2012 18:23:18
To: <smf_addin@yahoogrou
Reply-To: smf_addin@yahoogrou
Subject: [smf_addin] Using VBA to read RCHGetYahooHistory into an array
Hello, firstly I'd like to says thanks for providing such a useful set of functions.
I'm not sure if RCHGetYahooHistory was intended to be read into an array but it has been working. I have a loop that runs once for each stock I'm interested in. The data is read into the array in the line below:
SP500Array = RCHGetYahooHistory(
pResort:=0, _
pNames:=0, _
pItems:="DOHLCAV"
pAdjust:=1, _
pDim1:=270, _
pDim2:=7)
The array is dimensioned as Public SP500Array() As Variant. The data is processed for each StockName and stored, then StockName is updated and the process repeated. I recently increased the number of stocks and found that at the 70th stock the function return no data in all elements from 238 (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred on the 75th stock.
Should I not use the function this way or would you expect it to work.
Thanks, David
------------
Yahoo! Groups Links
Mon Sep 10, 2012 1:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That looks like it should work to me. I suspect the issues you're having
troubles with only have that much history on Yahoo...
On Mon, Sep 10, 2012 at 11:23 AM, ds5ec <ds5ec@yahoo.com > wrote:
> Hello, firstly I'd like to says thanks for providing such a useful set of
> functions.
> I'm not sure if RCHGetYahooHistory was intended to be read into an array
> but it has been working. I have a loop that runs once for each stock I'm
> interested in. The data is read into the array in the line below:
>
> SP500Array = RCHGetYahooHistory(StockName, _
> pResort:=0, _
> pNames:=0, _
> pItems:="DOHLCAV", _
> pAdjust:=1, _
> pDim1:=270, _
> pDim2:=7)
>
> The array is dimensioned as Public SP500Array() As Variant. The data is
> processed for each StockName and stored, then StockName is updated and the
> process repeated. I recently increased the number of stocks and found that
> at the 70th stock the function return no data in all elements from 238
> (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred
> on the 75th stock.
> Should I not use the function this way or would you expect it to work.
>
troubles with only have that much history on Yahoo...
On Mon, Sep 10, 2012 at 11:23 AM, ds5ec <ds5ec@yahoo.
> Hello, firstly I'd like to says thanks for providing such a useful set of
> functions.
> I'm not sure if RCHGetYahooHistory was intended to be read into an array
> but it has been working. I have a loop that runs once for each stock I'm
> interested in. The data is read into the array in the line below:
>
> SP500Array = RCHGetYahooHistory(
> pResort:=0, _
> pNames:=0, _
> pItems:="DOHLCAV"
> pAdjust:=1, _
> pDim1:=270, _
> pDim2:=7)
>
> The array is dimensioned as Public SP500Array() As Variant. The data is
> processed for each StockName and stored, then StockName is updated and the
> process repeated. I recently increased the number of stocks and found that
> at the 70th stock the function return no data in all elements from 238
> (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred
> on the 75th stock.
> Should I not use the function this way or would you expect it to work.
>
Mon Sep 10, 2012 1:13 pm (PDT) . Posted by:
"ds5ec" ds5ec
This may be it - I'll check - thanks. The point of error seems close to a year so that may be all the data for that symbol (eg. BWA - all in S&P 500).
--- In smf_addin@yahoogroups.com , zarathustra_winced@... wrote:
>
> Do the stocks have enough history to fill the array?
> Sent via BlackBerry by AT&T
>
> -----Original Message-----
> From: "ds5ec" <ds5ec@...>
> Sender: smf_addin@yahoogroups.com
> Date: Mon, 10 Sep 2012 18:23:18
> To: <smf_addin@yahoogroups.com >
> Reply-To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Using VBA to read RCHGetYahooHistory into an array
>
> Hello, firstly I'd like to says thanks for providing such a useful set of functions.
> I'm not sure if RCHGetYahooHistory was intended to be read into an array but it has been working. I have a loop that runs once for each stock I'm interested in. The data is read into the array in the line below:
>
> SP500Array = RCHGetYahooHistory(StockName, _
> pResort:=0, _
> pNames:=0, _
> pItems:="DOHLCAV", _
> pAdjust:=1, _
> pDim1:=270, _
> pDim2:=7)
>
> The array is dimensioned as Public SP500Array() As Variant. The data is processed for each StockName and stored, then StockName is updated and the process repeated. I recently increased the number of stocks and found that at the 70th stock the function return no data in all elements from 238 (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred on the 75th stock.
> Should I not use the function this way or would you expect it to work.
> Thanks, David
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
--- In smf_addin@yahoogrou
>
> Do the stocks have enough history to fill the array?
> Sent via BlackBerry by AT&T
>
> -----Original Message-----
> From: "ds5ec" <ds5ec@...>
> Sender: smf_addin@yahoogrou
> Date: Mon, 10 Sep 2012 18:23:18
> To: <smf_addin@yahoogrou
> Reply-To: smf_addin@yahoogrou
> Subject: [smf_addin] Using VBA to read RCHGetYahooHistory into an array
>
> Hello, firstly I'd like to says thanks for providing such a useful set of functions.
> I'm not sure if RCHGetYahooHistory was intended to be read into an array but it has been working. I have a loop that runs once for each stock I'm interested in. The data is read into the array in the line below:
>
> SP500Array = RCHGetYahooHistory(
> pResort:=0, _
> pNames:=0, _
> pItems:="DOHLCAV"
> pAdjust:=1, _
> pDim1:=270, _
> pDim2:=7)
>
> The array is dimensioned as Public SP500Array() As Variant. The data is processed for each StockName and stored, then StockName is updated and the process repeated. I recently increased the number of stocks and found that at the 70th stock the function return no data in all elements from 238 (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred on the 75th stock.
> Should I not use the function this way or would you expect it to work.
> Thanks, David
>
>
>
> ------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar