That should be all you need to do. Unless you're using data source "OX",
which is calls only.

Can you have me an example of one that doesn't work? What results do you
get?

On Fri, Dec 14, 2012 at 4:39 AM, andrewhills97 <andrewhills97@yahoo.com>wrote:

>
> How do I change the smfGetOptionQuotes file to retrieve Put prices instead
> of Call option prices? I have tried replacing "Call" with "Put" but didnt
> work.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2a

Re: Morningstar Closed End Fund Data

Fri Dec 14, 2012 4:57 am (PST) . Posted by:

"jhfrazer@ymail.com" jhfrazer@ymail.com

Randy...THANK YOU. I was able to cobble together the syntax for the remaining data from that table. Now if I may be so bold to ask for some assistance with the piece of data I was never smart enough to ever place in my spreadsheet. If you look a little further down the right hand side of the page you will notice that AFB is in a category named "Muni National Long". How do I get that data?

I tried looking at the source code for the page and searchingfor the header but I was not smart enough to find the underlying page.

Your guidance as always will be greatly appreciated.

Thank you,

John

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The bad news -- unfortunately it's another web page that Morningstar is
> dynamically generating, so there are no longer any tables of data in the
> source code of the web page for the add-in to extract.
>
> HOWEVER, the good news -- I did find a source page that the data comes from
> that they use to dynamically load the web page from. For example, to get
> the "Total Leverage Ratio":
>
> =RCHGetTableCell("
> http://cef.morningstar.com/cef-header?returnType=html&t=AFB",6,"Total
> Leverage",,,,1,"</table")
>
> That sourced web page appears to have all the data items you mention. I'm
> assuming the formula above is similar to what you were using, other than
> the URL...
>
> On Thu, Dec 13, 2012 at 12:10 PM, jhfrazer@... <jhfrazer@...>wrote:
>
> >
> > For a long time I used your =RCHGetTableCell function to extract certain
> > data from Morningstar.com Closedend fund data pages. For example if you
> > enter AFB in the quote window of morningstar.com the data for
> > AllianceBernstein Nat Muni Inc Commonwill be displayed. I used your
> > function to extract "total leverage ratio", "Last actual Discount",
> > "6-month Avg. Discount" and "Total Dist. Rate".
> >
> > With what I understand are changes to the morningstr pages I am now unable
> > to extract anything from these pages which are slightly different for
> > closed end funds.
> >
> > How might I access this data now?
> >
> > One more thing..please be gentle, I'm probably the oldest guy in the forum
> > and not as technical as I would like.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2b

Re: Morningstar Closed End Fund Data

Fri Dec 14, 2012 5:06 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Source page for that item appears to be:

http://cef.morningstar.com/cef-category?t=AFB

=RCHGetTableCell("http://cef.morningstar.com/cef-category?t=AFB",1,"<tr")

I found it by looking through the JavaScript code for "tempReqUrl ". That
appears to be how many of the various data items are loaded.

On Fri, Dec 14, 2012 at 5:57 AM, jhfrazer@ymail.com <jhfrazer@ymail.com>wrote:

> Randy...THANK YOU. I was able to cobble together the syntax for the
> remaining data from that table. Now if I may be so bold to ask for some
> assistance with the piece of data I was never smart enough to ever place in
> my spreadsheet. If you look a little further down the right hand side of
> the page you will notice that AFB is in a category named "Muni National
> Long". How do I get that data?
>
> I tried looking at the source code for the page and searchingfor the
> header but I was not smart enough to find the underlying page.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2c

Re: Morningstar Closed End Fund Data

Fri Dec 14, 2012 5:54 am (PST) . Posted by:

"jhfrazer@ymail.com" jhfrazer@ymail.com

You are absolutely amazing! I fumbled around for over an hour trying to nail that down. Absolutely amazing!! Thank you!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Source page for that item appears to be:
>
> http://cef.morningstar.com/cef-category?t=AFB
>
> =RCHGetTableCell("http://cef.morningstar.com/cef-category?t=AFB",1,"<tr")
>
> I found it by looking through the JavaScript code for "tempReqUrl ". That
> appears to be how many of the various data items are loaded.
>
> On Fri, Dec 14, 2012 at 5:57 AM, jhfrazer@... <jhfrazer@...>wrote:
>
> > Randy...THANK YOU. I was able to cobble together the syntax for the
> > remaining data from that table. Now if I may be so bold to ask for some
> > assistance with the piece of data I was never smart enough to ever place in
> > my spreadsheet. If you look a little further down the right hand side of
> > the page you will notice that AFB is in a category named "Muni National
> > Long". How do I get that data?
> >
> > I tried looking at the source code for the page and searchingfor the
> > header but I was not smart enough to find the underlying page.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

3a

Re: Excel 2010 crashes every time "Enable Editing" is clicked

Fri Dec 14, 2012 5:19 am (PST) . Posted by:

"Ron Spruell" hashky

I don't have a clue what you are talking about, but my suggestion would be to go through your settings in Excel, and make sure it isn't locked down.
http://bribg.pbworks.com/w/file/50396066/Step-by-Step%20SMF%20Add-In.doc

Then reboot.

Ron Spruell

>________________________________
> From: lexstar <lexstar@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, December 12, 2012 9:49 AM
>Subject: [smf_addin] Re: Excel 2010 crashes every time "Enable Editing" is clicked
>
>
>
>And, if I'm not having this problem, I'm getting this other problem:
>
>"Microsoft Visual Basic for Applications.... Can't find project or library".
>
>Man, I'm totally screwed today... Any help would be greatly appreciated. I've looked online, and tried some of the stuffs they said to try...but none has worked so far.
>
>Frustrating.
>
>--- In smf_addin@yahoogroups.com, "lexstar" <lexstar@...> wrote:
>>
>> Hello. Anyway have a way to help me out? My Excel 2010 workbook crashes everytime the Protected View shows up with "Enable Editing" and I clicked on it.
>>
>> I did some search online and someone came up with this code, but where do you put in order to make it work?
>>
>> ............One additional note that I just stumbled on was that the code will error if the workbook isn't in "ProtectedView". So to avoid this the following code will only enable editing if the workbook has "ProtectedView" enabled.
>>
>> Otherwise the enable editing is skipped and everyone is happy.
>>
>> If Application.ProtectedViewWindows.Count > 0 Then
>> Application.ActiveProtectedViewWindow.Edit
>> End If
>>
>>
>> Any help is much appreciated.
>>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4a

Re: Any success using this on a Mac?

Fri Dec 14, 2012 5:22 am (PST) . Posted by:

"Ron Spruell" hashky

Search through the messages. I think there has be success with Parallels and VirtualBox.

Ron Spruell

>________________________________
> From: peterson8484 <peterson8484@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, December 11, 2012 10:27 AM
>Subject: [smf_addin] Any success using this on a Mac?
>
>
>
>I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
>
>Has anyone found a way to successfully use this add-in on a Mac?
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4b

Re: Any success using this on a Mac?

Fri Dec 14, 2012 6:44 am (PST) . Posted by:

"james morlock" kagawonger

If these products work on a Mac does that also mean they are likely to
run on an iPad? I have avoided Mac products because most investing
software is Windows based.

Jim

On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:

Search through the messages. I think there has be success with
Parallels and VirtualBox.

Ron Spruell

___________________________________

From: peterson8484 <peterson8484@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, December 11, 2012 10:27 AM
Subject: [smf_addin] Any success using this on a Mac?

I'm switching from a PC to a Mac and before I resort to a solution
that will run Windows on my Mac I wanted to check:

Has anyone found a way to successfully use this add-in on a Mac?

<javascript:parent.wgMail.openComposeWindow('ygroupsnotifications@yahoogroups.com')>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5a

a quick help~

Fri Dec 14, 2012 6:08 am (PST) . Posted by:

"wongkayau" wongkayau

Hello Randy,

I hv been using smf and found it extremely helpful. Thanks a lot.

Just a quick one:I would like to download the interest rate table from:
http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20

I tried both formula below
(1) =RCHGetTableCell("http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20",1,"2 Months")

(2) =smfGetTagContent("http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20","td",1,"2 Month")

Both of them return "error". Could you pls help?

Thanks a lot!!!

Cheers, Laurent

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

5b

Re: a quick help~

Fri Dec 14, 2012 6:11 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't even access the web page. FireFox returns an error, after a long
delay (a time out?):

"The server encountered an internal error (Internal Server Error) that
prevented it from fulfilling this request."

On Fri, Dec 14, 2012 at 7:07 AM, wongkayau <wongkayau@yahoo.com> wrote:

> Hello Randy,
>
> I hv been using smf and found it extremely helpful. Thanks a lot.
>
> Just a quick one:I would like to download the interest rate table from:
>
> http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20
>
> I tried both formula below
> (1) =RCHGetTableCell("
> http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20",1,"2
> Months")
>
> (2) =smfGetTagContent("
> http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20","td",1,"2
> Month")
>
> Both of them return "error". Could you pls help?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

5c

Re: a quick help~

Fri Dec 14, 2012 6:25 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Randy, I was able to view it on IE browser

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, December 14, 2012 9:12 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] a quick help~

I can't even access the web page. FireFox returns an error, after a long delay (a time out?):

"The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request."
On Fri, Dec 14, 2012 at 7:07 AM, wongkayau <wongkayau@yahoo.com> wrote:
Hello Randy,

I hv been using smf and found it extremely helpful. Thanks a lot.

Just a quick one:I would like to download the interest rate table from:
http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search <http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20> &lang=en&year=2012&month=11&day=20

I tried both formula below
(1) =RCHGetTableCell("http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search <http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20> &lang=en&year=2012&month=11&day=20",1,"2 Months")

(2) =smfGetTagContent("http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search <http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20> &lang=en&year=2012&month=11&day=20","td",1,"2 Month")

Both of them return "error". Could you pls help?

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

5d

Re: a quick help~

Fri Dec 14, 2012 6:33 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The web page is working now...must have been a temporary issue with their
server.

Your problem is that the data is not located on that web page. It is within
a frame on that web page. So you need to use the URL of the frame. Try:

=RCHGetTableCell("
http://www.hkab.org.hk/hibor/listRates.do?lang=en&year=2012&month=11&day=20",1,"2
Months")

On Fri, Dec 14, 2012 at 7:07 AM, wongkayau <wongkayau@yahoo.com> wrote:

>
>
> Just a quick one:I would like to download the interest rate table from:
>
> http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20
>
> I tried both formula below
> (1) =RCHGetTableCell("
> http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20",1,"2
> Months")
>
> (2) =smfGetTagContent("
> http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20","td",1,"2
> Month")
>
> Both of them return "error". Could you pls help?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

5e

Re: a quick help~

Fri Dec 14, 2012 7:21 am (PST) . Posted by:

"wongkayau" wongkayau

Hello Randy,

You are the best! it works! Thanks a lot. By the way, how do u find the link? Thanks!

Cheers, Laurent

P.S. Thanks Kermit for solving the firefox problem.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The web page is working now...must have been a temporary issue with their
> server.
>
> Your problem is that the data is not located on that web page. It is within
> a frame on that web page. So you need to use the URL of the frame. Try:
>
> =RCHGetTableCell("
> http://www.hkab.org.hk/hibor/listRates.do?lang=en&year=2012&month=11&day=20",1,"2
> Months")
>
> On Fri, Dec 14, 2012 at 7:07 AM, wongkayau <wongkayau@...> wrote:
>
> >
> >
> > Just a quick one:I would like to download the interest rate table from:
> >
> > http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20
> >
> > I tried both formula below
> > (1) =RCHGetTableCell("
> > http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20",1,"2
> > Months")
> >
> > (2) =smfGetTagContent("
> > http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2012&month=11&day=20","td",1,"2
> > Month")
> >
> > Both of them return "error". Could you pls help?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

6a

Re: Real-Time stock data import

Fri Dec 14, 2012 6:17 am (PST) . Posted by:

"Stock Jock" stockjocktrader

So, if I understand what you are saying. The RCHGetYahooQuotes() function retrieves the current quote, not the EOD quote? Also, the current quote can be updated at a user defined interval by using the smfForceRecalculation macro; whereby this will simulate a real time data stream? Please confirm.
---------------------------------

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It's my understanding that the CSV current quotes file that Yahoo provides
> gives real time quotes if you are signed up for them. But I've never done
> it myself.
>
> In order for that to work for the add-in, you need to log in with either
> the EXCEL Web Query process (preferred) or with IE. That should create the
> proper security cookie for the XMLHTTP process that the add-in uses to
> retrieve data from the Internet. EXCEL/XMLHTTP/IE are all MicroSoft
> products and use the same methods to access the Internet. So the add-in
> uses IE settings, IE cookies, and IE temporary Internet files. Logging in
> with something like FireFox would not create the necessary security cookie
> for EXCEL or the add-in to use.
>
> Each RCHGetYahooQuotes() function can get data on up to 200 ticker symbols
> (a limit imposed by Yahoo on how many stocks can be loaded into that CSV
> file). But you can use six different functions to get 1200 ticker symbols.
>
> You'd need to write your own VBA code to do the timing routine, using VBA's
> onTime command. Really, all you'd need to have the routine do is execute
> the smfForceRecalculation macro of the add-in (see the LINKS area of the
> group for more info on that macro). That would update all add-in functions
> you have in the workbook.
>
> Or, you could have your VBA routine load values into the workbook, using
> the same functions.
>
> On Fri, Dec 14, 2012 at 1:07 AM, randc_1yh <randcinv@...> wrote:
>
> >
> > Have been using an Excel macro I purchased long ago to import real time
> > stock data into an Excel spreadsheet. It takes a "snapshot" of Real-Time
> > stock data (OHLV etc.), in user-definable set time increments (i.e., every
> > 10 seconds, 30 seconds, 60 seconds, etc.) for 1200+ stock tickers at a time.
> >
> > Problem is, it runs only under WindowsXP, and I am upgrading computers and
> > need something similar to run under Vista or newer Windows OS.
> >
> > Apparently Yahoo! Finanace has two databases, one for end-of-day, and one
> > for real time. (I pay a monthly fee for real time access to Yahoo! stock
> > data.)
> >
> > Simple as this, I want to put a random 1200+ stock symbols vertically in
> > Column A, and every 30 seconds import real-time data to update Last, High,
> > Low, Volume, etc. in columns B thru H, can smf_addin pull in real time data
> > like that from Yahoo!?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

6b

Re: Real-Time stock data import

Fri Dec 14, 2012 6:20 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Correct on both counts.

But RCHGetYahooQuotes() will collect EOD quotes after the market is closed.

If you want historical EOD quotes, you would use the RCHGetYahooHistory()
function.

On Fri, Dec 14, 2012 at 7:17 AM, Stock Jock <stockjocktrader@yahoo.com>wrote:

>
> So, if I understand what you are saying. The RCHGetYahooQuotes() function
> retrieves the current quote, not the EOD quote? Also, the current quote
> can be updated at a user defined interval by using the
> smfForceRecalculation macro; whereby this will simulate a real time data
> stream? Please confirm.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

6c

Re: Real-Time stock data import

Fri Dec 14, 2012 6:31 am (PST) . Posted by:

"Stock Jock" stockjocktrader

Excellent. Now, I need to study your documentation to learn how to do that. Thanks.
-----------------------------------

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Correct on both counts.
>
> But RCHGetYahooQuotes() will collect EOD quotes after the market is closed.
>
> If you want historical EOD quotes, you would use the RCHGetYahooHistory()
> function.
>
> On Fri, Dec 14, 2012 at 7:17 AM, Stock Jock <stockjocktrader@...>wrote:
>
> >
> > So, if I understand what you are saying. The RCHGetYahooQuotes() function
> > retrieves the current quote, not the EOD quote? Also, the current quote
> > can be updated at a user defined interval by using the
> > smfForceRecalculation macro; whereby this will simulate a real time data
> > stream? Please confirm.
> >
>