Kamis, 30 Oktober 2014

[smf_addin] Digest Number 3225

15 Messages

Digest #3225
1a
Rchcreatecomment by bushpilote
1b
Re: Rchcreatecomment by "Randy Harmelink" rharmelink
2a
Option Data by bob_15861586
2b
Re: Option Data by bill_d_tx
2c
Re: Option Data by "Randy Harmelink" rharmelink
2d
Re: Option Data by "Randy Harmelink" rharmelink
2e
Re: Option Data by garyhartling
3a
Re: Changes in Yahoo Option Quotes web pages by 313946e2c69ab04a4ab7c262cf9da361
3b
Re: Changes in Yahoo Option Quotes web pages by 313946e2c69ab04a4ab7c262cf9da361
3c
Re: Changes in Yahoo Option Quotes web pages by "Randy Harmelink" rharmelink
4a
4b
Re: getting started with smf by "Randy Harmelink" rharmelink
6
getting started by kassenrendant
7a
Re: Getting data from MSN again with pointer & by "Randy Harmelink" rharmelink

Messages

Thu Oct 30, 2014 5:28 am (PDT) . Posted by:

bushpilote

Hi Randy,

hope all is well with you.


Can the rchcreatecomment function be used with an embedded chart in an excel workbook? More specifically, if I have an embedded chart buried in sheet 25 of a workbook, is it possible to use the function to show the chart [e.g. Worksheets("Sheet25").ChartObjects(1).Chart ]in sheet 1 of the same workbook?



I'm familiar with various vba and non-vba commands to get it done but would prefer using rchcreatecomment if possible.

Thu Oct 30, 2014 4:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Actually, having problems here. My computer monitor went black on
Wednesday, so I'm operating on a reduced platform and have a limited
ability to respond to questions. Hoping to get a new monitor up and working
by Monday.

RCHCreateComment() is just used to pull images from the web, so it wouldn't
work for a chart embedded within EXCEL. Sorry.

On Thu, Oct 30, 2014 at 5:28 AM, bushpilote@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hi Randy,
>
> hope all is well with you.
>
> Can the rchcreatecomment function be used with an embedded chart in an
> excel workbook? More specifically, if I have an embedded chart buried in
> sheet 25 of a workbook, is it possible to use the function to show the
> chart [e.g. Worksheets("Sheet25").ChartObjects(1).Chart ]in sheet 1 of the
> same workbook?
>
> I'm familiar with various vba and non-vba commands to get it done but
> would prefer using rchcreatecomment if possible.
>

Thu Oct 30, 2014 12:58 pm (PDT) . Posted by:

bob_15861586

I am using the function smfGetYahooOptionQuote to get option data. It was working but it is no longer working. All I get the message Error. I do not think Yahoo changed again.


Bob

Thu Oct 30, 2014 1:39 pm (PDT) . Posted by:

bill_d_tx

I am experiencing the same issue although using =smfGetOptionQuotes

any feedback would be appreciated

Thu Oct 30, 2014 4:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Example please. I just tried this and it worked fine for me:

=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","b")

I assume you are using the beta version of the add-in (i.e.
2.1.2014.10.23.B), since I had to make changes to the Yahoo retrieval
process because of recent Yahoo changes?

On Thu, Oct 30, 2014 at 12:58 PM, bob_15861586@...wrote:

> I am using the function smfGetYahooOptionQuote to get option data. It
> was working but it is no longer working. All I get the message Error. I do
> not think Yahoo changed again.
>

Thu Oct 30, 2014 4:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Example please. I just tried this and it worked fine for me:

=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","b")

I assume you are using the beta version of the add-in (i.e.
2.1.2014.10.23.B), since I had to make changes to the Yahoo retrieval
process because of recent Yahoo changes?

On Thu, Oct 30, 2014 at 1:39 PM, wmd0914@... wrote:

>
> I am experiencing the same issue although using =smfGetOptionQuotes
>
> any feedback would be appreciated
>
>

Thu Oct 30, 2014 5:34 pm (PDT) . Posted by:

garyhartling

I'm getting lots of option quote errors. The 5 following produce "Error":

=smfGetOptionQuotes("EBAY 11/22 2014 52.5 C","v")
=smfGetOptionQuotes("EBAY 11/22 2014 52.5 C","i")
=smfGetOptionQuotes("EBAY 11/22 2014 52.5 C","l")
=smfGetOptionQuotes("EBAY 11/22 2014 52.5 C","b")
=smfGetOptionQuotes("EBAY 11/22 2014 52.5 C","a")


Some quotes work. For example:
=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","b") works.
=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","a") works.

=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","v") works.



But:
=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","i") Error

=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","l") Error



--Gary H.



Thu Oct 30, 2014 4:45 pm (PDT) . Posted by:

313946e2c69ab04a4ab7c262cf9da361

I had this problem, and it was fixed by the work in progress update ... but then it stopped working again today. Anyone else have this crop up again today?

Thu Oct 30, 2014 4:47 pm (PDT) . Posted by:

313946e2c69ab04a4ab7c262cf9da361

Looks like yahoo option quotes web pages changed again. The 10/21 update, which worked for me until today, stopped working.

Best regards, and thank you so much for the valuable tool,
-Travis

Thu Oct 30, 2014 4:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Example please. I just tried this and it worked fine for me:

=smfGetOptionQuotes("MMM 10/31 2014 $150 Call","b")

On Thu, Oct 30, 2014 at 12:48 PM, travlake@... wrote:

>
> Looks like yahoo option quotes web pages changed again. The 10/21 update,
> which worked for me until today, stopped working.
>

Thu Oct 30, 2014 4:46 pm (PDT) . Posted by:

kassenrendant

Hi,
I'm looking for help. I have installed the add-in and obviously its installed correctly, because commands like =RCHGetElementNumber("Version&quot;) works. But every try to get some data like the %growth rate for dividends (element #63) of the element definition list, I fail.
Which command do I have to type or what else do I have to do? all the tutorials I could find didnt help me :(

Thu Oct 30, 2014 4:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but none of the MSN data elements for RCHGetElementNumber() work any
longer. Earlier this month, MSN Money changed the structure of their
company data web pages. Most data elements that they used to provide no
longer exist.

On Thu, Oct 30, 2014 at 11:49 AM, kassenrendant@...wrote:

>
> I'm looking for help. I have installed the add-in and obviously its
> installed correctly, because commands like =RCHGetElementNumber("Version&quot;)
> works. But every try to get some data like the %growth rate for dividends
> (element #63) of the element definition list, I fail.
> Which command do I have to type or what else do I have to do? all the
> tutorials I could find didnt help me :(
>

Thu Oct 30, 2014 4:48 pm (PDT) . Posted by:

brad.reel

Hi Randy. Stuck on this.


From a process perspective I have a screen running (whole different process, through my broker), I get that list and it usually has 10 or 20 symbols that are new to me. I built a procedure to go check if they are an ETF or not. I need to know if they are an ETF or not for other downstream processes.



I have a VBA sub that is invoking the following code:


If ETFCheck = True Then
Symbol = Sheets(SheetName).Range("A" & SymbolLoop).Value
ETFResponse = RCHGetTableCell("https://finance.yahoo.com/q?s=" & Symbol & "&ql=1", 1, "Legal Type")
If ETFResponse = "Exchange Traded Fund" Then
Sheets(SheetName).Range("B" & SymbolLoop).Value = True
Else
Sheets(SheetName).Range("B" & SymbolLoop).Value = False

End If


Basically, if I get a new symbol, I check it and if it results in "Exchange Traded Fund" I set a value to TRUE, otherwise FALSE (in the case of an equity).


At the end of the day, I am trying to confirm whether or not a list of symbols I have is an ETF or stock. The information I am pulling on the web page is the most reliable source I have found. So, first, if you are aware of some other simpler way I can query on a symbol and get whether or not it is an ETF, I am all ears.


The main point is I noticed I was not getting consistent results when looking at the output. Symbols I knew were ETF's were coming back as equities and vice-versa. So, to troubleshoot, I pulled out the formula and built a spreadsheet with 100 items to just make sure I wasn't doing something else wrong, etc. When I tried to retrieve for the 100 symbols, the result I got back was "Error" for all 100. "Error" is the result I would expect for a stock (since this field does not exist on the page for a given stock). This is basically the same result I was seeing in my procedure output. I am not really getting anything that should be set to ETF to be set that way; everything is coming back as equity.


In the spreadsheet, my suspicion is that this might come down to the page being cached. I've tried everything I found in your FAQ to address that (clear browser, set to get new page every time, run your macro, etc.). and I suspect that could be the problem I am experiencing on the spreadsheet. Ultimately the question I have that goes with my very long-winded explanation is could I have the same caching issue when making an individual VBA procedure call for each symbol? And if I am, what good way is there for me to work around it?


Thanks in advance.

Thu Oct 30, 2014 4:49 pm (PDT) . Posted by:

kassenrendant

Hi,
I have some problems getting started with smf.
I use excel 2013 (is that compatible?).
The add-in is obviously installed correctly. A command like =RCHGetElementNumber("Version&quot;) works.
But I don't know how to get any other data, e.g. the % growth rate - dividend for IBM.
Would be very happy if somebody helps me!


Thu Oct 30, 2014 5:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You just need to do the concatenation properly. You want to concatenate
three different strings:

"https://sg.finance.yahoo.com/q/is?s="
A12
"&annual"

Or:

=RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s=" & A12 &
"&annual",1,"Operating Income or Loss")

On Thu, Oct 30, 2014 at 2:24 AM, tzewei_79@...wrote:

> I'm using =RCHGetTableCell("
> https://sg.finance.yahoo.com/q/is?s=ARLP&annual",1,"Operating Income or
> Loss") to get operation income now. I am converting my long list to point
> the ticker to a specific cell so that I don't need to change formula from
> the cell.
>
> I used to be able to do this by =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol="&A12,1,"Operating
> Income") where cell A12 is my ticker ARLP.
>
> But I can't do the same with the new hyperlink. =RCHGetTableCell("
> https://sg.finance.yahoo.com/q/is?s=&annual"&A12,1,"Operating Income or
> Loss") will show an error.
>
> =RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s="&A12&annual,1,"Operating
> Income or Loss") will show #VALUE!.
>
> Anyone knows how I can point it correctly?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar