Kamis, 03 November 2011

[smf_addin] Digest Number 2005

Messages In This Digest (4 Messages)

1a.
RCHCreateComment Query From: Philip S
1b.
Re: RCHCreateComment Query From: Randy Harmelink
2a.
Just started From: John Zman
2b.
Re: Just started From: Randy Harmelink

Messages

1a.

RCHCreateComment Query

Posted by: "Philip S" Philip_R_Small@hotmail.com   philip_r_small

Wed Nov 2, 2011 6:04 am (PDT)

1b.

Re: RCHCreateComment Query

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Nov 2, 2011 8:42 am (PDT)



I don't think you can get the image. It appears to be a dynamically
generated one. That is, when I clicked on your GIF link, I didn't get any
image displayed in my browser. But when I visited the web page you cited, I
did see an image there. After that, I do see the image when I click your
GIF link. But not before.

On Wed, Nov 2, 2011 at 6:03 AM, Philip S <Philip_R_Small@hotmail.com> wrote:

>
> I have an image file:
>
>
> http://www.investtech.com/main/di.php?CompanyID=44102634&src=uk_lse%2Fcharts%2F7%2F44102634_7.gif
>
> This is from:
>
> http://www.investtech.com/main/market.php?CompanyID=44102634
>
> How do would I use RCHcreatecomment to view the image?
>
> Tried RCHCreatecomment("
> http://www.investtech.com/main/di.php?CompanyID=44102634&src=uk_lse%2Fcharts%2F7%2F44102634_7.gif")
> but it gives an error message.
>
2a.

Just started

Posted by: "John Zman" john.zman@yahoo.com   john.zman

Wed Nov 2, 2011 7:00 pm (PDT)



Hi:
I just started using the rchgetyahooquotes. I am running XP with Excel 2007. Had no problem installing or using the add-in ( great description of add-ins here -> http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/
I can get stock quotes easily, but not option quotes.  I build the option symbol string using VBA, and if I copy/paste the option symbol directly to Yahoo Finance it gives me a quote. BUT, it won't work using the function call. Anyone have any ideas why this is? Am I failing to use this properly, or does it only accept shorter string lengths?
Thanks.
John
2b.

Re: Just started

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Nov 2, 2011 7:32 pm (PDT)



The Yahoo quotes interface, which is what RCHGetYahooQuotes() uses, hasn't
supported option quotes since option symbols changed early last year. Take
a look at the smfGetOptionQuotes() function.

You may be getting an option quote on their web page, but click on the
"Download Data" link on that web page -- that's the interface that
RCHGetYahooQuotes() uses, because it allows retrieval of multiple data
items on up to 200 ticker symbols with a single internet access. But that
link right now returns "N/A" for almost all data fields.

On Wed, Nov 2, 2011 at 6:45 PM, John Zman <john.zman@yahoo.com> wrote:

>
> I just started using the rchgetyahooquotes. I am running XP with Excel
> 2007. Had no problem installing or using the add-in ( great description of
> add-ins here ->
> http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/
>
> I can get stock quotes easily, but not option quotes. I build the option
> symbol string using VBA, and if I copy/paste the option symbol directly to
> Yahoo Finance it gives me a quote. BUT, it won't work using the function
> call. Anyone have any ideas why this is? Am I failing to use this properly,
> or does it only accept shorter string lengths?
>
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Tidak ada komentar:

Posting Komentar