Messages In This Digest (25 Messages)
- 1a.
- IE opens new tab when running macro From: friedman_steve
- 1b.
- Re: IE opens new tab when running macro From: Randy Harmelink
- 2a.
- curious From: wu_ming_sg
- 2b.
- Re: curious From: Randy Harmelink
- 2c.
- Re: curious From: sonny kasturi
- 2d.
- Re: curious From: dguillett1
- 2e.
- Re: curious From: Randy Harmelink
- 2f.
- Re: curious From: wu_ming_sg
- 2g.
- Re: curious From: Randy Harmelink
- 2h.
- Re: curious From: james morlock
- 3.
- greetings From: wu_ming_sg
- 4a.
- Morningstar additions needed From: msimmsx
- 4b.
- Re: Morningstar additions needed From: Randy Harmelink
- 4c.
- Re: Morningstar additions needed From: msimmsx
- 4d.
- Re: Morningstar additions needed From: Randy Harmelink
- 5a.
- Option quotes From: Glen Fullmer
- 5b.
- Re: Option quotes From: Randy Harmelink
- 6a.
- Nuveen Closed End funds From: msimmsx
- 6b.
- Re: Nuveen Closed End funds From: Randy Harmelink
- 6c.
- Re: Nuveen Closed End funds From: msimmsx
- 6d.
- Re: Nuveen Closed End funds From: Randy Harmelink
- 6e.
- Re: Nuveen Closed End funds From: msimmsx
- 6f.
- Re: Nuveen Closed End funds From: Randy Harmelink
- 7a.
- Array Limit From: wu_ming_sg
- 7b.
- Re: Array Limit From: Randy Harmelink
Messages
- 1a.
-
IE opens new tab when running macro
Posted by: "friedman_steve" friedman_steve@yahoo.com friedman_steve
Wed Sep 7, 2011 7:39 am (PDT)
I have an extensive spreadsheet set up that grabs SMF data from a variety of sources. Recently (last couple months), IE (Internet Explorer) sometimes opens up new blank tabs when I run the excel spreadsheet with a new stock ticker. the tab addresses are related to sites I'm grabbing data from. (incidentally, IE is not even my default browser).
Does anyone know why this happens & how to turn if off? It's just a nuisance and slows down computer.
below is an example of one of the tabs:
about:blank#http://finance.google.com/ finance?fstype= ii&q=MDRX
Happens using Windows Vista or Windows 7.
Excel 2007
IE 8
Thanks.
- 1b.
-
Re: IE opens new tab when running macro
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 8:20 am (PDT)
Try using a new element definition file from the "Works in Progress" folder
from the files area of the group. You'll need the one with Google elements,
but I'd just suggest updating all of them. You'll need to replace those
files in your SMF folder and then run the smfForceRecalculation macro to
reload the element definitions.
I think that fixed the problem last time someone brought it up.
On Wed, Sep 7, 2011 at 7:39 AM, friedman_steve <friedman_steve@yahoo.com >wrote:
> I have an extensive spreadsheet set up that grabs SMF data from a variety
> of sources. Recently (last couple months), IE (Internet Explorer) sometimes
> opens up new blank tabs when I run the excel spreadsheet with a new stock
> ticker. the tab addresses are related to sites I'm grabbing data from.
> (incidentally, IE is not even my default browser).
>
> Does anyone know why this happens & how to turn if off? It's just a
> nuisance and slows down computer.
>
> below is an example of one of the tabs:
> about:blank#http://finance.google.com/ finance?fstype= ii&q=MDRX
>
> Happens using Windows Vista or Windows 7.
> Excel 2007
> IE 8
>
- 2a.
-
curious
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Wed Sep 7, 2011 8:01 am (PDT)
hi Randy,
Your work is so impressive?
We are curious as to where you are from and what do you do?
Best regards,
- 2b.
-
Re: curious
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 8:28 am (PDT)
I'm a retired mainframe programmer, but I've been programming computers
since the late 60's. In my career, I was responsible for the system that
allowed the pricing and reserving actuaries to do their loss projections at
a large commercial insurance company. When I started, we used to do annual
loss triangles for 5 years. When I retired, they could do monthly loss
triangles for up to 40 years of data. As usual, people think more data
helps, but in too many cases, it's just additional noise.
IMO, the most difficult thing about application programming on the PC is the
variety of hardware/software platforms that exist. If the add-in were to
become a commercial product, it would require about 10 times as much work as
I've already put into it -- to account for all of those varying platforms
and to test all of those permutations.
On Wed, Sep 7, 2011 at 8:01 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Your work is so impressive?
>
> We are curious as to where you are from and what do you do?
>
- 2c.
-
Re: curious
Posted by: "sonny kasturi" skmelville@yahoo.com skmelville
Wed Sep 7, 2011 8:40 am (PDT)
Nice to know someone (especially one who has lot more experience than I) other than me who thinks/opines that more data is not necessarily better.
S Kasturi973 731 8737
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, September 7, 2011 11:28 AM
Subject: Re: [smf_addin] curious
I'm a retired mainframe programmer, but I've been programming computers since the late 60's. In my career, I was responsible for the system that allowed the pricing and reserving actuaries to do their loss projections at a large commercial insurance company. When I started, we used to do annual loss triangles for 5 years. When I retired, they could do monthly loss triangles for up to 40 years of data. As usual, people think more data helps, but in too many cases, it's just additional noise.
IMO, the most difficult thing about application programming on the PC is the variety of hardware/software platforms that exist. If the add-in were to become a commercial product, it would require about 10 times as much work as I've already put into it -- to account for all of those varying platforms and to test all of those permutations.
On Wed, Sep 7, 2011 at 8:01 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>Your work is so impressive?
>
>We are curious as to where you are from and what do you do?
>
- 2d.
-
Re: curious
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Wed Sep 7, 2011 9:02 am (PDT)
Randy, As a retired RM for ING and life & qualifying MDRT for 35 years, I'm personally curios as to what company_____________?
From: Randy Harmelink
Sent: Wednesday, September 07, 2011 10:28 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] curious
I'm a retired mainframe programmer, but I've been programming computers since the late 60's. In my career, I was responsible for the system that allowed the pricing and reserving actuaries to do their loss projections at a large commercial insurance company. When I started, we used to do annual loss triangles for 5 years. When I retired, they could do monthly loss triangles for up to 40 years of data. As usual, people think more data helps, but in too many cases, it's just additional noise.
IMO, the most difficult thing about application programming on the PC is the variety of hardware/software platforms that exist. If the add-in were to become a commercial product, it would require about 10 times as much work as I've already put into it -- to account for all of those varying platforms and to test all of those permutations.
On Wed, Sep 7, 2011 at 8:01 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
Your work is so impressive?
We are curious as to where you are from and what do you do?
- 2e.
-
Re: curious
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 9:27 am (PDT)
Used to be St. Paul Companies, which was acquired by/merged with Traveler's.
That was about the time I quit. I was with St. Paul Companies for about 27
years.
On Wed, Sep 7, 2011 at 9:01 AM, dguillett1 <dguillett1@gmail.com > wrote:
>
> Randy, As a retired RM for ING and life & qualifying MDRT for 35 years,
> I'm personally curios as to what company_____________?
>
- 2f.
-
Re: curious
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Wed Sep 7, 2011 5:30 pm (PDT)
Do you have a "about me" link?
I like to mail my friend and let him understand more what kind of a great person is behind this amazing plugin!
I am guessing you are in the East side of USA?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Used to be St. Paul Companies, which was acquired by/merged with Traveler's.
> That was about the time I quit. I was with St. Paul Companies for about 27
> years.
>
> On Wed, Sep 7, 2011 at 9:01 AM, dguillett1 <dguillett1@...> wrote:
>
> >
> > Randy, As a retired RM for ING and life & qualifying MDRT for 35 years,
> > I’m personally curios as to what company_____________?
> >
>
- 2g.
-
Re: curious
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 5:44 pm (PDT)
No "about me" link. Not that much to tell.
I lived in Minnesota (St. Paul) most of my life, from the ages of 4-49,
except for the 3 years I attended Iowa State University -- but moved to
Phoenix when I "retired" in 2006.
On Wed, Sep 7, 2011 at 5:30 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
> Do you have a "about me" link?
>
> I like to mail my friend and let him understand more what kind of a great
> person is behind this amazing plugin!
>
> I am guessing you are in the East side of USA?
>
- 2h.
-
Re: curious
Posted by: "james morlock" JimMorlock@optonline.net kagawonger
Wed Sep 7, 2011 6:51 pm (PDT)
I would tell your friend that Randy is just a highly skilled and gifted
man who is incredably helpful and generous in sharing what he knows.
Thank you Randy.
On Wed, Sep 7, 2011 at 8:44 PM, Randy Harmelink wrote:
No "about me" link. Not that much to tell.
I lived in Minnesota (St. Paul) most of my life, from the ages of 4-49,
except for the 3 years I attended Iowa State University -- but moved to
Phoenix when I "retired" in 2006.
On Wed, Sep 7, 2011 at 5:30 PM, wu_ming_sg < nghongchong@hotmail.com
<javascript:parent.wgMail. openComposeWindo w('nghongchong@ hotmail.com ')>
> wrote:
Do you have a "about me" link?
I like to mail my friend and let him understand more what kind of a
great person is behind this amazing plugin!
I am guessing you are in the East side of USA?
<javascript:parent.wgMail. openComposeWindo w('nghongchong@ hotmail.com ')>
<http://docs.yahoo.com/ >info/terms/
- 3.
-
greetings
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Wed Sep 7, 2011 8:03 am (PDT)
hi Randy,
Your work is so impressive!
We are curious as to where you are from and what do you do?
Best regards,
- 4a.
-
Morningstar additions needed
Posted by: "msimmsx" marksimms@verizon.net msimmsx
Wed Sep 7, 2011 10:42 am (PDT)
2 new elements:
% Developed Markets
% Emerging Markets
These are under the "Market Classification" heading....
http://portfolios.morningstar. com/fund/ summary?t= DEMSX
TIA
- 4b.
-
Re: Morningstar additions needed
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 12:34 pm (PDT)
You can always pick them up using another add-in function, such as
RCHGetTableCell(). I'm unlikely to add any more MorningStar elements,
because of their trend towards dynamic display of data, which prevents the
add-in from accessing the data.
On Wed, Sep 7, 2011 at 10:42 AM, msimmsx <marksimms@verizon.net > wrote:
> 2 new elements:
> % Developed Markets
> % Emerging Markets
> These are under the "Market Classification" heading....
> http://portfolios.morningstar. com/fund/ summary?t= DEMSX
>
- 4c.
-
Re: Morningstar additions needed
Posted by: "msimmsx" marksimms@verizon.net msimmsx
Wed Sep 7, 2011 3:15 pm (PDT)
I tried to mimic the existing element definitions, but "no dice"...somehow this HTML was not getting parsed correctly for those last 2 entries. I tried skipping 4 rows after Asia Emergings, but I got "undefined".
<td>Asia Emergings</td>
<td align="right">38.18</td>
<td align="right" id="regionsIndex13">—< /td>
<td align="right" id="regionsCategory13">31.75< /td>
</tr>
<tr class="hr">
<td colspan="4"></td>
</tr>
<tr class="height_divider">
<td colspan="4"></td>
</tr>
<tr class="fontsize_10">
<td class="str">Market Classification< /td>
<td class="str" align="right"></td>
<td class="str" align="right"></td>
<td class="str" align="right"></td>
</tr>
<tr class="hr">
<td colspan="4"></td>
</tr>
<tr>
<td>% Developed Markets</td>
<td align="right">30.81</td>
<td align="right" id="regionsIndex14">—< /td>
<td align="right" id="regionsCategory14">26.67< /td>
</tr>
<tr class="hr1">
<td colspan="4"></td>
</tr>
<tr>
<td>% Emerging Markets</td>
<td align="right">69.19</td>
<td align="right" id="regionsIndex15">—< /td>
<td align="right" id="regionsCategory15">73.33< /td>
</tr>
<tr class="hr">
<td colspan="4"></td>
</tr>
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You can always pick them up using another add-in function, such as
> RCHGetTableCell(). I'm unlikely to add any more MorningStar elements,
> because of their trend towards dynamic display of data, which prevents the
> add-in from accessing the data.
>
> On Wed, Sep 7, 2011 at 10:42 AM, msimmsx <marksimms@...> wrote:
>
> > 2 new elements:
> > % Developed Markets
> > % Emerging Markets
> > These are under the "Market Classification" heading....
> > http://portfolios.morningstar. com/fund/ summary?t= DEMSX
> >
>
- 4d.
-
Re: Morningstar additions needed
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 3:21 pm (PDT)
"Undefined" means an element number has no definition. If you change the
element definition files, you need to run smfForceRecalculation to have the
add-in load those new definitions. Otherwise, the definitions are only
loaded from the external files once, when you run the first
RCHGetElementNumber() function. It was actually the original purpose of the
smfForceRecalculation macro -- for me to test new element definitions.
On Wed, Sep 7, 2011 at 3:15 PM, msimmsx <marksimms@verizon.net > wrote:
> I tried to mimic the existing element definitions, but "no dice"...somehow
> this HTML was not getting parsed correctly for those last 2 entries. I tried
> skipping 4 rows after Asia Emergings, but I got "undefined".
>
- 5a.
-
Option quotes
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Wed Sep 7, 2011 1:07 pm (PDT)
Anyone else having a problem with option quotes today?
Getting a bunch of N/As but the stock quotes seem to be working OK and
the option quotes were working yesterday:
smfGetOptionQuotes using Yahoo
Ideas?
Thanks,
Glen
--
Glen Fullmer, gfullmer@cox.net , http://members.cox.net/gfullmer
---
http://personalcashflow.blogspot. - cash flow blogcom
http://www.alreadytoharvest. - historical novelcom
http://www.youtube.com/gfullmer - fractal Movies
"True love doesn't want anything" - Eckhardt Tolle
"Charity doesn't think about itself" - St. Paul
"all things whatsoever ye would that men
should do to you, do ye even so to them" - Jesus
---
- 5b.
-
Re: Option quotes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 1:12 pm (PDT)
Probably a temporary Yahoo thing. I assume you checked the Yahoo option
quotes pages for the equities in question? Do you have your IE options set
to always get a new web page? Sometimes N/A is what they have first thing in
the morning. If your browser cache settings aren't getting new web pages,
you'll see the N/A values later in the day.
On Wed, Sep 7, 2011 at 1:07 PM, Glen Fullmer <gfullmer@cox.net > wrote:
> Anyone else having a problem with option quotes today?
>
> Getting a bunch of N/As but the stock quotes seem to be working OK and
> the option quotes were working yesterday:
>
> smfGetOptionQuotes using Yahoo
>
> Ideas?
>
- 6a.
-
Nuveen Closed End funds
Posted by: "msimmsx" marksimms@verizon.net msimmsx
Wed Sep 7, 2011 3:05 pm (PDT)
http://www.cefconnect.com/Pricing/ DailyPricing. aspx
What's the best way to get all of these dynamic tables ?
Use IE automation to change the checkboxes, then fetch the data one at a time ?
- 6b.
-
Re: Nuveen Closed End funds
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 3:14 pm (PDT)
Give it a try...
Off hand, I don't see a way to get a bookmarkable URL that the add-in can
use. But I'm not all that familiar with ASP pages.
On Wed, Sep 7, 2011 at 3:05 PM, msimmsx <marksimms@verizon.net > wrote:
> http://www.cefconnect.com/Pricing/ DailyPricing. aspx
>
> What's the best way to get all of these dynamic tables ?
>
> Use IE automation to change the checkboxes, then fetch the data one at a
> time ?
>
- 6c.
-
Re: Nuveen Closed End funds
Posted by: "msimmsx" marksimms@verizon.net msimmsx
Wed Sep 7, 2011 8:27 pm (PDT)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Give it a try...
>
> Off hand, I don't see a way to get a bookmarkable URL that the add-in can
> use. But I'm not all that familiar with ASP pages.
A Query table worked, so I figured the add-in would work as well.
- 6d.
-
Re: Nuveen Closed End funds
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 8:42 pm (PDT)
Should, yes, since a query table requires a bookmarkable URL as well...
On Wed, Sep 7, 2011 at 8:27 PM, msimmsx <marksimms@verizon.net > wrote:
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Give it a try...
> >
> > Off hand, I don't see a way to get a bookmarkable URL that the add-in can
> > use. But I'm not all that familiar with ASP pages.
>
> A Query table worked, so I figured the add-in would work as well.
>
- 6e.
-
Re: Nuveen Closed End funds
Posted by: "msimmsx" marksimms@verizon.net msimmsx
Thu Sep 8, 2011 12:16 am (PDT)
Problem is....you don't expose nor retain your instance of IE. In fact you grab the HTML and then quit the session.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Should, yes, since a query table requires a bookmarkable URL as well...
- 6f.
-
Re: Nuveen Closed End funds
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Sep 8, 2011 12:31 am (PDT)
But in order to refresh the query table, it needs to have a bookmarkable
URL. It doesn't pull the HTML from that copy of IE. It's just used to create
the query table settings (URL, which table(s), etc).
I just tried it, and what's happening is that all the check boxes are
"sticky". They must store the check box settings in a cookie. So if you do a
query, you'll get the settings based on that combination of check boxes.
However, if you now go and change the check box settings and refresh the
query, you'll get the data based on your NEW settings, not the original
settings you created the query from.
So, your settings are NOT saved in the query's URL (which is what would make
the URL bookmarkable). The only way to get back to your original query table
results would be to reset all of the check boxes to the original values and
then refresh the query. That means you can't save multiple query tables,
each with their own settings, and refresh them all. When you do refresh them
all, all of them will return the exact same results based on the current
check box settings.
On Thu, Sep 8, 2011 at 12:16 AM, msimmsx <marksimms@verizon.net > wrote:
> Problem is....you don't expose nor retain your instance of IE. In fact you
> grab the HTML and then quit the session.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Should, yes, since a query table requires a bookmarkable URL as well...
>
- 7a.
-
Array Limit
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Wed Sep 7, 2011 7:58 pm (PDT)
Hi Randy,
Refer to the below quote from Documentation please."When elements are
retrieved, the source code of the web page is saved in an array within
the VBA environment, then the element is extracted from that source
code. It is done that way so that when a number of elements are
retrieved from the same web page, the web page only needs to be
retrieved once. Note that the array to save web pages is limited to 1000
pages. Anything beyond that will get an error message. The entire array
can be reset by either exiting and re-entering EXCEL or by running the
smfForceRecalculation macro. This macro purges all saved web pages and
reacalculates all functions. "
I am using a cell named Ticker. When I change the ticker symbol in my
template, the whole file will auto-calculate. I have a mix of
RHCGetElementNumbers and RHCGetTableCell. Will my template be restricted
by the array limit?
eg. If I change the ticker in my file a 1000 times to look at different
stocks, would I face the above situation?
And what will the error message look like?
- 7b.
-
Re: Array Limit
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Sep 7, 2011 8:08 pm (PDT)
The formula will return this if you try to access over 1000 web pages
without exiting EXCEL or running the smfForceRecalculation macro:
"Error -- Too many web page retrievals"
Just run the smfForceRecalculation macro from time to time and you should be
OK. If you're running in to the error message, you're trying to access too
much data, IMO. Same comment if you're entering 1000 ticker symbols into the
template. The add-in is intended for ad hoc usage. If you need that much
data, you should be looking at a database product like AAII's Stock Investor
Pro.
On Wed, Sep 7, 2011 at 7:58 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Refer to the below quote from Documentation please.
> *"When elements are retrieved, the source code of the web page is saved in
> an array within the VBA environment, then the element is extracted from that
> source code. It is done that way so that when a number of elements are
> retrieved from the same web page, the web page only needs to be retrieved
> once. Note that the array to save web pages is limited to 1000 pages.
> Anything beyond that will get an error message. The entire array can be
> reset by either exiting and re-entering EXCEL or by running the
> smfForceRecalculation macro. This macro purges all saved web pages and
> reacalculates all functions. "*
> *
> *
> I am using a cell named Ticker. When I change the ticker symbol in my
> template, the whole file will auto-calculate.
> I have a mix of RHCGetElementNumbers and RHCGetTableCell.
> Will my template be restricted by the array limit?
>
> eg. If I change the ticker in my file a 1000 times to look at different
> stocks, would I face the above situation?
>
> And what will the error message look like?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar