6 New Messages
Digest #2602
3a
Pulling Data for tickers with spaces by "corley.michael@rocketmail.com" corley.michael@rocketmail.com
Messages
Thu May 2, 2013 3:56 am (PDT) . Posted by:
"oryxius" oryxius
Hello Randy,
Is there an element number to get Yahoo's analysts mean recommendation for a stock? For example:
http://finance.yahoo.com/q/ao?s=mmm&ql=1
Thank you,
MK
Is there an element number to get Yahoo's analysts mean recommendation for a stock? For example:
http://finance.
Thank you,
MK
Thu May 2, 2013 10:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nope. You'd need to use RCHGetTableCell(), as in:
=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM ",1,"(this week)")
On Thu, May 2, 2013 at 3:56 AM, oryxius <oryxius@yahoo.com > wrote:
>
> Is there an element number to get Yahoo's analysts mean recommendation for
> a stock? For example:
>
> http://finance.yahoo.com/q/ao?s=mmm&ql=1
>
=RCHGetTableCell(
On Thu, May 2, 2013 at 3:56 AM, oryxius <oryxius@yahoo.
>
> Is there an element number to get Yahoo's analysts mean recommendation for
> a stock? For example:
>
> http://finance.
>
Thu May 2, 2013 10:50 am (PDT) . Posted by:
"ssztaba" ssztaba
I have a spreadsheet with over 1000 rows. There are stock symbols for currently 110 stocks, and one options for each of these stocks.
Because of the way the spreadsheet is constructed (with blank cells between the symbols) I have not been able to use the Array function for getting the prices with the RCHGetYahooQuotes function. A formula is entered in each cell needing a price.
Similarly for the option quotes: I'm using the smfGetOptionQuotes function, but again no array is used.
It works fine, but seems very slow. I use a VBA button to Call the smfForceRecalculation function. I checked the time from the beginning of the smfForceRecalculation funtcion until it's completion, and it was taking 59 seconds.
Any thoughts, suggestions on how I can lessen this calculation time ??
Thanks
Because of the way the spreadsheet is constructed (with blank cells between the symbols) I have not been able to use the Array function for getting the prices with the RCHGetYahooQuotes function. A formula is entered in each cell needing a price.
Similarly for the option quotes: I'm using the smfGetOptionQuotes function, but again no array is used.
It works fine, but seems very slow. I use a VBA button to Call the smfForceRecalculati
Any thoughts, suggestions on how I can lessen this calculation time ??
Thanks
Thu May 2, 2013 11:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, array-entering smfGetOptionQuotes() won't do anything to
speed it up. I just let it be array-entered so that it was consistent with
RCHGetYahooQuotes().
One thing you could do is move all of your RCHGetYahooQuotes() data
retrievals to an array-entered one on another worksheet, and then pull them
from there for your main worksheet using regular EXCEL functions like
VLOOKUP().
There may be ways to speed up your option quotes, using RCHGetTableCell(),
but it would also require a separate worksheet and depend on what data
items you are picking up. The technique would involve using the Yahoo
portfolio view web page, which you can customize for data items you want.
But if you don't log in and create an IE security cookie, you would just
pick up the default views.
On Thu, May 2, 2013 at 10:50 AM, ssztaba <ssjurik@optonline.net > wrote:
> I have a spreadsheet with over 1000 rows. There are stock symbols for
> currently 110 stocks, and one options for each of these stocks.
>
> Because of the way the spreadsheet is constructed (with blank cells
> between the symbols) I have not been able to use the Array function for
> getting the prices with the RCHGetYahooQuotes function. A formula is
> entered in each cell needing a price.
>
> Similarly for the option quotes: I'm using the smfGetOptionQuotes
> function, but again no array is used.
>
> It works fine, but seems very slow. I use a VBA button to Call the
> smfForceRecalculation function. I checked the time from the beginning of
> the smfForceRecalculation funtcion until it's completion, and it was taking
> 59 seconds.
>
> Any thoughts, suggestions on how I can lessen this calculation time ??
>
speed it up. I just let it be array-entered so that it was consistent with
RCHGetYahooQuotes(
One thing you could do is move all of your RCHGetYahooQuotes(
retrievals to an array-entered one on another worksheet, and then pull them
from there for your main worksheet using regular EXCEL functions like
VLOOKUP().
There may be ways to speed up your option quotes, using RCHGetTableCell(
but it would also require a separate worksheet and depend on what data
items you are picking up. The technique would involve using the Yahoo
portfolio view web page, which you can customize for data items you want.
But if you don't log in and create an IE security cookie, you would just
pick up the default views.
On Thu, May 2, 2013 at 10:50 AM, ssztaba <ssjurik@optonline.
> I have a spreadsheet with over 1000 rows. There are stock symbols for
> currently 110 stocks, and one options for each of these stocks.
>
> Because of the way the spreadsheet is constructed (with blank cells
> between the symbols) I have not been able to use the Array function for
> getting the prices with the RCHGetYahooQuotes function. A formula is
> entered in each cell needing a price.
>
> Similarly for the option quotes: I'm using the smfGetOptionQuotes
> function, but again no array is used.
>
> It works fine, but seems very slow. I use a VBA button to Call the
> smfForceRecalculati
> the smfForceRecalculati
> 59 seconds.
>
> Any thoughts, suggestions on how I can lessen this calculation time ??
>
Thu May 2, 2013 4:36 pm (PDT) . Posted by:
"corley.michael@rocketmail.com" corley.michael@rocketmail.com
Does anyone know how to pull a ticker which exists on multiple exchanges with the same name from two different international exchanges...i.e. if you have Ticker A that resides on Exchange A and Ticker B that resides on Exchange B, but Ticker A = Ticker B, how can you pull that specific data point using =RCHGetElementNumber(). Is there another way to go about it?
Thu May 2, 2013 4:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Example please? You are using a Yahoo ticker symbol, right?
On Thu, May 2, 2013 at 4:17 PM, corley.michael@rocketmail.com <
michaelacorley@gmail.com > wrote:
> Does anyone know how to pull a ticker which exists on multiple exchanges
> with the same name from two different international exchanges...i.e. if you
> have Ticker A that resides on Exchange A and Ticker B that resides on
> Exchange B, but Ticker A = Ticker B, how can you pull that specific data
> point using =RCHGetElementNumber(). Is there another way to go about it?
>
On Thu, May 2, 2013 at 4:17 PM, corley.michael@
michaelacorley@
> Does anyone know how to pull a ticker which exists on multiple exchanges
> with the same name from two different international exchanges...
> have Ticker A that resides on Exchange A and Ticker B that resides on
> Exchange B, but Ticker A = Ticker B, how can you pull that specific data
> point using =RCHGetElementNumbe
>
Tidak ada komentar:
Posting Komentar