10 New Messages
Digest #2934
1b
Re: smfForceRecalculation - does it recalculate all open spreadsheet by "Randy Harmelink" rharmelink
Messages
Sun Jan 19, 2014 5:59 am (PST) . Posted by:
"PC_BABE" cs.holdings
Randy
If you pull 2 data elements from one page, will the function save one or 2 pages to accomplish this task?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, January 17, 2014 1:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfForceRecalculation - does it recalculate all open spreadsheets
F9 will only recalculate the formulas.
However, most functions, like RCHGetElementNumber() or RCHGetTableCell() extract data from a saved copy of a web page. So a simple recalculation doesn't gain you much. It just extracts the same data from the same saved copy of a web page.
smfForceRecalculation purges all of those saved web pages. That forces the add-in to get a fresh copy of the web page from the Internet before recalculating the formula. So then, the data extraction is from a new saved copy of the web page.
On Fri, Jan 17, 2014 at 7:22 AM, flangeneral <jefff@rogers.com <mailto:jefff@rogers.com> > wrote:
What is the difference between smfForceRecalculation and F9?
If you pull 2 data elements from one page, will the function save one or 2 pages to accomplish this task?
From: smf_addin@yahoogrou
Sent: Friday, January 17, 2014 1:16 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: smfForceRecalculati
F9 will only recalculate the formulas.
However, most functions, like RCHGetElementNumber
smfForceRecalculati
On Fri, Jan 17, 2014 at 7:22 AM, flangeneral <jefff@rogers.
What is the difference between smfForceRecalculati
Sun Jan 19, 2014 8:04 am (PST) . Posted by:
"Randy Harmelink" rharmelink
As long as the URL is the same, the web page will only be retrieved once.
That is why extraction is done from the stored web page. So it doesn't need
to be retrieved again and again.
And that's why you need to run smfForceRecalculation to get a fresh copy of
the web page.
On Sun, Jan 19, 2014 at 6:59 AM, PC_BABE <pc_babe@msn.com> wrote:
>
>
> If you pull 2 data elements from one page, will the function save one or 2
> pages to accomplish this task?
>
>
>
That is why extraction is done from the stored web page. So it doesn't need
to be retrieved again and again.
And that's why you need to run smfForceRecalculati
the web page.
On Sun, Jan 19, 2014 at 6:59 AM, PC_BABE <pc_babe@msn.
>
>
> If you pull 2 data elements from one page, will the function save one or 2
> pages to accomplish this task?
>
>
>
Sun Jan 19, 2014 6:53 am (PST) . Posted by:
john.kalkanis
Hi Randi. How do I get tha zacks rank for an ETF? they use a different url than for stocks...
Thanks
Thanks
Sun Jan 19, 2014 8:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.zacks.com/funds/etf/SPY/profile","p",-1,"ETF Rank:"),":","-"))
On Sun, Jan 19, 2014 at 7:53 AM, <john.kalkanis@yahoo.com> wrote:
> Hi Randi. How do I get tha zacks rank for an ETF? they use a different
> url than for stocks...
>
=smfConvertData(
http://www.zacks.
On Sun, Jan 19, 2014 at 7:53 AM, <john.kalkanis@
> Hi Randi. How do I get tha zacks rank for an ETF? they use a different
> url than for stocks...
>
Sun Jan 19, 2014 2:54 pm (PST) . Posted by:
cgrablew
Randy,
I tried the Morning Star Total Return Template but the entire spreadsheet is in error. It looks like all the elements aren't there. I've replace all my *.txt with the Work in Progress Folder txt files, so if this is a problem please let me know.
Thanks,
Chuck
I tried the Morning Star Total Return Template but the entire spreadsheet is in error. It looks like all the elements aren't there. I've replace all my *.txt with the Work in Progress Folder txt files, so if this is a problem please let me know.
Thanks,
Chuck
Sun Jan 19, 2014 4:04 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That template from the FILES area worked fine for me. Possible issues that
come to mind:
1. You didn't visit the Morningstar.com website with IE first. MorningStar
is one of those websites that has an "advertising" redirection on your
first visit of the day. So the IE cookie needs to be updated before the
add-in can grab any web pages.
2. You updated the *.txt files but never had the add-in reload the new
definitions -- either by running exiting and restarting EXCEL, or by
running the smfForceRecalculation macro (see LINKS area of group for info
on it).
3. You were trying to use it for something other than a mutual fund. That
template extracts data from a mutual fund web page.
Do any of those apply?
On Sun, Jan 19, 2014 at 3:54 PM, <cgrablew@gmail.com> wrote:
>
> I tried the Morning Star Total Return Template but the entire spreadsheet
> is in error. It looks like all the elements aren't there. I've replace
> all my *.txt with the Work in Progress Folder txt files, so if this is a
> problem please let me know.
>
come to mind:
1. You didn't visit the Morningstar.
is one of those websites that has an "advertising&q
first visit of the day. So the IE cookie needs to be updated before the
add-in can grab any web pages.
2. You updated the *.txt files but never had the add-in reload the new
definitions -- either by running exiting and restarting EXCEL, or by
running the smfForceRecalculati
on it).
3. You were trying to use it for something other than a mutual fund. That
template extracts data from a mutual fund web page.
Do any of those apply?
On Sun, Jan 19, 2014 at 3:54 PM, <cgrablew@gmail.
>
> I tried the Morning Star Total Return Template but the entire spreadsheet
> is in error. It looks like all the elements aren't there. I've replace
> all my *.txt with the Work in Progress Folder txt files, so if this is a
> problem please let me know.
>
Sun Jan 19, 2014 4:19 pm (PST) . Posted by:
cgrablew
Randy,
Thanks ... I did do the second item but not the first. Let me try again.
Chuck
PS - I know I'm probably just not seeing it, but since element 25 (Last Price) was marked obsolete I don't see another Stock Price (Closing) in the Elements Definition (2013-11-05). Is there one?
Thanks ... I did do the second item but not the first. Let me try again.
Chuck
PS - I know I'm probably just not seeing it, but since element 25 (Last Price) was marked obsolete I don't see another Stock Price (Closing) in the Elements Definition (2013-11-05)
Sun Jan 19, 2014 4:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No. I point people to the RCHGetYahooQuotes() function. Because it's a much
more efficient way of getting such data. You can get a dozens of items on
up to 200 companies, with a single Internet access.
RCHGetElementNumber() was never intended for use with things that update
frequently. Before the smfForceRecalculation macro, the only way to update
them was to exit and restart EXCEL. I only added the "Last Price" field
because the MSN print page was the first one I created elements for, and I
created an element for every item on the web page. Which has changed at
least a half dozen times since. :(
On Sun, Jan 19, 2014 at 5:19 PM, <cgrablew@gmail.com> wrote:
> PS - I know I'm probably just not seeing it, but since element 25 (Last
> Price) was marked obsolete I don't see another Stock Price (Closing) in the
> Elements Definition (2013-11-05). Is there one?
>
more efficient way of getting such data. You can get a dozens of items on
up to 200 companies, with a single Internet access.
RCHGetElementNumber
frequently. Before the smfForceRecalculati
them was to exit and restart EXCEL. I only added the "Last Price" field
because the MSN print page was the first one I created elements for, and I
created an element for every item on the web page. Which has changed at
least a half dozen times since. :(
On Sun, Jan 19, 2014 at 5:19 PM, <cgrablew@gmail.
> PS - I know I'm probably just not seeing it, but since element 25 (Last
> Price) was marked obsolete I don't see another Stock Price (Closing) in the
> Elements Definition (2013-11-05)
>
Sun Jan 19, 2014 8:57 pm (PST) . Posted by:
cgrablew
Randy,
Not sure if you got my response so I'm sending it again just in case.
I tried the RCHGETYAHOOQUOTES but I'm having problems with it using it as an array formula. It seems to work fine if I pull the Basic Quote Data but if I used it to pull the FUNDAMENTAL elements the data returns gets off shifted (it seems to return a couple of extra values which off shifts the data). Try putting the Fundamental elements across the top with 5 stocks (I used T, TW, AXP, GE, IBM). When you do this as an array formula the data get off shifted and date fields get numeric values (not a format issue). When you do the same with individual formulas in each cell it works fine. I'm using the SMF Add-in from the WORK IN PROGRESS folder so if that's a problem let me know. If this isn't clear, I'll be happy to send you the spreadsheet so you can see it. I'm using Excel 2013 on Windows 7 machine.
Thanks for all your help,
Chuck
Not sure if you got my response so I'm sending it again just in case.
I tried the RCHGETYAHOOQUOTES but I'm having problems with it using it as an array formula. It seems to work fine if I pull the Basic Quote Data but if I used it to pull the FUNDAMENTAL elements the data returns gets off shifted (it seems to return a couple of extra values which off shifts the data). Try putting the Fundamental elements across the top with 5 stocks (I used T, TW, AXP, GE, IBM). When you do this as an array formula the data get off shifted and date fields get numeric values (not a format issue). When you do the same with individual formulas in each cell it works fine. I'm using the SMF Add-in from the WORK IN PROGRESS folder so if that's a problem let me know. If this isn't clear, I'll be happy to send you the spreadsheet so you can see it. I'm using Excel 2013 on Windows 7 machine.
Thanks for all your help,
Chuck
Sun Jan 19, 2014 10:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There is a problem with the "float" field, because Yahoo then populates a
CSV file with a field that has commas in it. So you could see shifting if
you're using that item.
If that's not the issue, why don't you attach a copy of a sample workbook.
On Sun, Jan 19, 2014 at 9:57 PM, <cgrablew@gmail.com> wrote:
> I tried the RCHGETYAHOOQUOTES but I'm having problems with it using it as
> an array formula. It seems to work fine if I pull the Basic Quote Data but
> if I used it to pull the FUNDAMENTAL elements the data returns gets off
> shifted (it seems to return a couple of extra values which off shifts the
> data). Try putting the Fundamental elements across the top with 5 stocks (I
> used T, TW, AXP, GE, IBM). When you do this as an array formula the data
> get off shifted and date fields get numeric values (not a format issue).
> When you do the same with individual formulas in each cell it works fine.
> I'm using the SMF Add-in from the WORK IN PROGRESS folder so if that's a
> problem let me know. If this isn't clear, I'll be happy to send you the
> spreadsheet so you can see it. I'm using Excel 2013 on Windows 7 machine.
>
CSV file with a field that has commas in it. So you could see shifting if
you're using that item.
If that's not the issue, why don't you attach a copy of a sample workbook.
On Sun, Jan 19, 2014 at 9:57 PM, <cgrablew@gmail.
> I tried the RCHGETYAHOOQUOTES but I'm having problems with it using it as
> an array formula. It seems to work fine if I pull the Basic Quote Data but
> if I used it to pull the FUNDAMENTAL elements the data returns gets off
> shifted (it seems to return a couple of extra values which off shifts the
> data). Try putting the Fundamental elements across the top with 5 stocks (I
> used T, TW, AXP, GE, IBM). When you do this as an array formula the data
> get off shifted and date fields get numeric values (not a format issue).
> When you do the same with individual formulas in each cell it works fine.
> I'm using the SMF Add-in from the WORK IN PROGRESS folder so if that's a
> problem let me know. If this isn't clear, I'll be happy to send you the
> spreadsheet so you can see it. I'm using Excel 2013 on Windows 7 machine.
>
Tidak ada komentar:
Posting Komentar