14 New Messages
Digest #2616
Messages
Mon May 13, 2013 8:24 am (PDT) . Posted by:
"Marty" mtopper
Hi Randy
I use the SMF force recalc tool (and it is attached to a macro button). It works for most but not all functions in my spreadsheet.
The following formula updates when the sheet is opened, but NOT when i run SMF Forece Recalc.
=smfGetTagContent("http://finance.yahoo.com/q?s= ^DJI","span",-1,"yfs_l10_")-RCHGetTableCell("http://finance.yahoo.com/q?s= ^DJI",1,"Prev Close:")
Cant figure out why.........
thanks
Marty
I use the SMF force recalc tool (and it is attached to a macro button). It works for most but not all functions in my spreadsheet.
The following formula updates when the sheet is opened, but NOT when i run SMF Forece Recalc.
=smfGetTagContent(
Cant figure out why.........
thanks
Marty
Mon May 13, 2013 2:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
One possibility is that your Internet Option aren't set to get a fresh copy
of a web page each time it is visited, so you keep picking up a cached copy
of the web page. See the other smfForceRecalculation entry in the LINKS
area of the group.
On Mon, May 13, 2013 at 8:24 AM, Marty <mtopper@yahoo.com > wrote:
>
> I use the SMF force recalc tool (and it is attached to a macro button).
> It works for most but not all functions in my spreadsheet.
>
> The following formula updates when the sheet is opened, but NOT when i run
> SMF Forece Recalc.
>
> =smfGetTagContent("http://finance.yahoo.com/q?s=
> ^DJI","span",-1,"yfs_l10_")-RCHGetTableCell("http://finance.yahoo.com/q?s= ^DJI",1,"Prev
> Close:")
>
> Cant figure out why.........
>
of a web page each time it is visited, so you keep picking up a cached copy
of the web page. See the other smfForceRecalculati
area of the group.
On Mon, May 13, 2013 at 8:24 AM, Marty <mtopper@yahoo.
>
> I use the SMF force recalc tool (and it is attached to a macro button).
> It works for most but not all functions in my spreadsheet.
>
> The following formula updates when the sheet is opened, but NOT when i run
> SMF Forece Recalc.
>
> =smfGetTagContent(
> ^DJI","
> Close:"
>
> Cant figure out why.........
>
Mon May 13, 2013 8:47 am (PDT) . Posted by:
"almondtree" almondtree
RCH Element #1513,1514,1515 gets errors; using 2.1.2013.03.29.zip
Mon May 13, 2013 2:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like those are no longer available. I don't see a "text" version
of the P&F chart on StockCharts any longer...?
On Mon, May 13, 2013 at 8:47 AM, almondtree <almondtree@yahoo.com > wrote:
> RCH Element #1513,1514,1515 gets errors; using 2.1.2013.03.29.zip
>
of the P&F chart on StockCharts any longer...?
On Mon, May 13, 2013 at 8:47 AM, almondtree <almondtree@yahoo.
> RCH Element #1513,1514,1515 gets errors; using 2.1.2013.03.
>
Mon May 13, 2013 8:48 am (PDT) . Posted by:
"KailuaKid" garyhartling
This morning I'm getting a lot of bogus results for option prices using the smfGetOptionQuotes function. I expect it's a Yahoo problem.
Mon May 13, 2013 2:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Also check to make sure your Internet Options are still set to always get
fresh content. Otherwise, EXCEL's IE object could be picking up cached
copies of the web page for the add-in to extract data from...
On Mon, May 13, 2013 at 8:48 AM, KailuaKid <Gary.Hartling@gmail.com > wrote:
> This morning I'm getting a lot of bogus results for option prices using
> the smfGetOptionQuotes function. I expect it's a Yahoo problem.
>
fresh content. Otherwise, EXCEL's IE object could be picking up cached
copies of the web page for the add-in to extract data from...
On Mon, May 13, 2013 at 8:48 AM, KailuaKid <Gary.Hartling@
> This morning I'm getting a lot of bogus results for option prices using
> the smfGetOptionQuotes function. I expect it's a Yahoo problem.
>
Mon May 13, 2013 9:18 am (PDT) . Posted by:
"jmackro" jmackro
The documentation for the RHSGetYahooQuotes function defines the parameter "refresh" as:
"An optional parameter that allows automatic refreshing of quotes via the F9 key (i.e. "recalculate"). All you need to do is pass "NOW()" as the value of this parameter to activate a refresh capability. Basically, all it does is cause a change in parameter values, which makes the function recalculate."
When I set up my spreadsheet, I inserted "NOW()" for that parameter, and the stock values did refresh each time I hit F9. But, they also refreshed whenever I made an edit to my spreadsheet. Since my spreadsheet contains multiple stocks, the time required to perform those refreshes becomes excessive when I am maintaining the spreadsheet.
I tried replacing "NOW()"with a null. That solved the problem of waiting a minute for the hourglass to go away each time I made a minor edit. But it creats the problem that the stock values only update upon opening the spreadsheet. It is useful to hit F9 periodically through the trading session to see updates.
My question is: Will a different value for the refresh parameter (such as "NOW( value )" ) allow my spreadsheet to update when I hit F9, but not when I make edits? I experimented with "NOW(1)" and with putting in a cell reference, e.g. "NOW($A$1)", but got error messages.
"An optional parameter that allows automatic refreshing of quotes via the F9 key (i.e. "recalculate&q
When I set up my spreadsheet, I inserted "NOW()" for that parameter, and the stock values did refresh each time I hit F9. But, they also refreshed whenever I made an edit to my spreadsheet. Since my spreadsheet contains multiple stocks, the time required to perform those refreshes becomes excessive when I am maintaining the spreadsheet.
I tried replacing "NOW()"
My question is: Will a different value for the refresh parameter (such as "NOW( value )" ) allow my spreadsheet to update when I hit F9, but not when I make edits? I experimented with "NOW(1)
Mon May 13, 2013 2:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The purpose of the "NOW()" function is to make the function volatile, so it
WILL recalculate every time. Any time that parameter changes (which is
every time you make a change to the workbook or press F9), it updates the
formula.
I can offer several suggestions:
1. I never use that parameter myself. I use smfForceRecalculation to
update all of my add-in formulas. See the LINKS area of the group for more
info on this macro.
2. Get all of your RCHGetYahooQuotes() data with a single Internet
access by array-entering it over a range. This can significantly speed up
the recalculation because it cuts down on all of those individual accesses
to the Internet for each cell formula.
3. Instead of inserting NOW() as the parameter, point it to a cell
reference that has NOW() in it. When you want to shut off the refreshing,
delete the content of that cell. Then, restore NOW() when you want to turn
refreshing back on. That's because the formulas only update when the
content of that cell would change. You could even manually use 1, 2, 3, 4,
..., etc. Any unique value would trigger the recalculation of an function
that referred to it.
On Mon, May 13, 2013 at 9:18 AM, jmackro <jmackro@alum.mit.edu > wrote:
> The documentation for the RHSGetYahooQuotes function defines the parameter
> "refresh" as:
>
> "An optional parameter that allows automatic refreshing of quotes via the
> F9 key (i.e. "recalculate"). All you need to do is pass "NOW()" as the
> value of this parameter to activate a refresh capability. Basically, all it
> does is cause a change in parameter values, which makes the function
> recalculate."
>
> When I set up my spreadsheet, I inserted "NOW()" for that parameter, and
> the stock values did refresh each time I hit F9. But, they also refreshed
> whenever I made an edit to my spreadsheet. Since my spreadsheet contains
> multiple stocks, the time required to perform those refreshes becomes
> excessive when I am maintaining the spreadsheet.
>
> I tried replacing "NOW()"with a null. That solved the problem of waiting
> a minute for the hourglass to go away each time I made a minor edit. But
> it creats the problem that the stock values only update upon opening the
> spreadsheet. It is useful to hit F9 periodically through the trading
> session to see updates.
>
> My question is: Will a different value for the refresh parameter (such as
> "NOW( value )" ) allow my spreadsheet to update when I hit F9, but not when
> I make edits? I experimented with "NOW(1)" and with putting in a cell
> reference, e.g. "NOW($A$1)", but got error messages.
>
WILL recalculate every time. Any time that parameter changes (which is
every time you make a change to the workbook or press F9), it updates the
formula.
I can offer several suggestions:
1. I never use that parameter myself. I use smfForceRecalculati
update all of my add-in formulas. See the LINKS area of the group for more
info on this macro.
2. Get all of your RCHGetYahooQuotes(
access by array-entering it over a range. This can significantly speed up
the recalculation because it cuts down on all of those individual accesses
to the Internet for each cell formula.
3. Instead of inserting NOW() as the parameter, point it to a cell
reference that has NOW() in it. When you want to shut off the refreshing,
delete the content of that cell. Then, restore NOW() when you want to turn
refreshing back on. That's because the formulas only update when the
content of that cell would change. You could even manually use 1, 2, 3, 4,
..., etc. Any unique value would trigger the recalculation of an function
that referred to it.
On Mon, May 13, 2013 at 9:18 AM, jmackro <jmackro@alum.
> The documentation for the RHSGetYahooQuotes function defines the parameter
> "refresh" as:
>
> "An optional parameter that allows automatic refreshing of quotes via the
> F9 key (i.e. "recalculate&q
> value of this parameter to activate a refresh capability. Basically, all it
> does is cause a change in parameter values, which makes the function
> recalculate.
>
> When I set up my spreadsheet, I inserted "NOW()" for that parameter, and
> the stock values did refresh each time I hit F9. But, they also refreshed
> whenever I made an edit to my spreadsheet. Since my spreadsheet contains
> multiple stocks, the time required to perform those refreshes becomes
> excessive when I am maintaining the spreadsheet.
>
> I tried replacing "NOW()"
> a minute for the hourglass to go away each time I made a minor edit. But
> it creats the problem that the stock values only update upon opening the
> spreadsheet. It is useful to hit F9 periodically through the trading
> session to see updates.
>
> My question is: Will a different value for the refresh parameter (such as
> "NOW( value )" ) allow my spreadsheet to update when I hit F9, but not when
> I make edits? I experimented with "NOW(1)
> reference, e.g. "NOW($A$
>
Mon May 13, 2013 12:26 pm (PDT) . Posted by:
"jbkbob1" jbkbob1
Hi,
First of All, Thank you for all you do. It is an outstanding group of functions.
My questions Refer to a message you posted in about extracting FinViz data that isn't part of the 68 fields;
http://finance.groups.yahoo.com/group/smf_addin/message/19489
I am able to get the data I want except it seems to be pulling it 1 cell at a time. When I have tickers in column A and column headers in Row 8, I use the following command:
=RCHGetTableCell("http://finviz.com/quote.ashx?t= "&smfJoin($A$9:$A$19,","),1,"?t="&$A9&"&",">"&B$8)
This cell is copied from A9 to the other 10 rows and for the columns up to AZ19. It is slow and I haven't been able to code an Array formula. Even trying it on 1 Row; say Apple it is pretty slow.
I was hoping you could help me to solve this one if it is my coding that is at fault.
Secondly, The Industry, sector and Company Description appear on the quotes page; http://www.finviz.com/quote.ashx?t=aapl however I can't figure out how to extract them with the other information. I am assuming that it is not a table and therefore the RCHGetTableCell function is the wrong one to use.
Thank you
First of All, Thank you for all you do. It is an outstanding group of functions.
My questions Refer to a message you posted in about extracting FinViz data that isn't part of the 68 fields;
http://finance.
I am able to get the data I want except it seems to be pulling it 1 cell at a time. When I have tickers in column A and column headers in Row 8, I use the following command:
=RCHGetTableCell(
This cell is copied from A9 to the other 10 rows and for the columns up to AZ19. It is slow and I haven't been able to code an Array formula. Even trying it on 1 Row; say Apple it is pretty slow.
I was hoping you could help me to solve this one if it is my coding that is at fault.
Secondly, The Industry, sector and Company Description appear on the quotes page; http://www.finviz.
Thank you
Mon May 13, 2013 2:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You're correct that they aren't in a table. You can get sector and industry
in the table with:
=smfGetTagContent("http://finviz.com/quote.ashx?t=
"&smfJoin($C$5:$C$12,","),"a",-1,"?t="&$C5&"&","f=sec_")
=smfGetTagContent("http://finviz.com/quote.ashx?t=
"&smfJoin($C$5:$C$12,","),"a",-1,"?t="&$C5&"&","f=ind_")
I'd suggest taking a look at the other FinViz entry in the LINKS area of
the group. You can also grab all of the data with an smfGetCSVFile()
function, since they do provide a CSV file with the data. And it updates
quickly, because everything is done in one fell swoop...
On Mon, May 13, 2013 at 12:25 PM, jbkbob1 <jbkbob@gmail.com > wrote:
>
> My questions Refer to a message you posted in about extracting FinViz data
> that isn't part of the 68 fields;
> http://finance.groups.yahoo.com/group/smf_addin/message/19489
> I am able to get the data I want except it seems to be pulling it 1 cell
> at a time. When I have tickers in column A and column headers in Row 8, I
> use the following command:
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=
> "&smfJoin($A$9:$A$19,","),1,"?t="&$A9&"&",">"&B$8)
>
> This cell is copied from A9 to the other 10 rows and for the columns up to
> AZ19. It is slow and I haven't been able to code an Array formula. Even
> trying it on 1 Row; say Apple it is pretty slow.
>
> I was hoping you could help me to solve this one if it is my coding that
> is at fault.
>
> Secondly, The Industry, sector and Company Description appear on the
> quotes page; http://www.finviz.com/quote.ashx?t=aapl however I can't
> figure out how to extract them with the other information. I am assuming
> that it is not a table and therefore the RCHGetTableCell function is the
> wrong one to use.
>
in the table with:
=smfGetTagContent(
"&smfJoin(
=smfGetTagContent(
"&smfJoin(
I'd suggest taking a look at the other FinViz entry in the LINKS area of
the group. You can also grab all of the data with an smfGetCSVFile(
function, since they do provide a CSV file with the data. And it updates
quickly, because everything is done in one fell swoop...
On Mon, May 13, 2013 at 12:25 PM, jbkbob1 <jbkbob@gmail.
>
> My questions Refer to a message you posted in about extracting FinViz data
> that isn't part of the 68 fields;
> http://finance.
> I am able to get the data I want except it seems to be pulling it 1 cell
> at a time. When I have tickers in column A and column headers in Row 8, I
> use the following command:
>
> =RCHGetTableCell(
> "&smfJoin(
>
> This cell is copied from A9 to the other 10 rows and for the columns up to
> AZ19. It is slow and I haven't been able to code an Array formula. Even
> trying it on 1 Row; say Apple it is pretty slow.
>
> I was hoping you could help me to solve this one if it is my coding that
> is at fault.
>
> Secondly, The Industry, sector and Company Description appear on the
> quotes page; http://www.finviz.
> figure out how to extract them with the other information. I am assuming
> that it is not a table and therefore the RCHGetTableCell function is the
> wrong one to use.
>
Tue May 14, 2013 12:58 am (PDT) . Posted by:
"Ashwin Kumar" ashwin_rn186
Hello,
This is Ashwin from Chennai. Kindly help me in step-by-step installing of the SMF add-in office 365. First of all, is it possible to add it in office 365. Kindly revert back ASAP. This is urgent.
Regards,
Ashwin
This is Ashwin from Chennai. Kindly help me in step-by-step installing of the SMF add-in office 365. First of all, is it possible to add it in office 365. Kindly revert back ASAP. This is urgent.
Regards,
Ashwin
Tue May 14, 2013 12:59 am (PDT) . Posted by:
"Ashwin Kumar" ashwin_rn186
Can u please give me the step-by-step instruction on how to install it. I actually installed it, not sure whether it is working or not. but I dont know how to test it too. Kindly help me in this regard.
Regards,
Ashwin
--- In smf_addin@yahoogroups.com , "Bob" <rkd@...> wrote:
>
>
>
> So far (2 days) the RCH Stock Market Functions seem to be working perfectly in the released version of Office 365 Home Premium. Using the 29 Dec 12 2.1 release of RCH in 32-bit Office version running on Windows 8 64-bit.
>
> Thanks for a wonderfully useful utility.
>
> Bob
>
>
> --- In smf_addin@yahoogroups.com , David Van Aken wrote:
> >
> > works on the excel 2013 preview
> >
> > -dave
> >
> >
> > On Sat, Feb 2, 2013 at 7:28 PM, Randy Harmelink wrote:
> >
> > >
> > >
> > > Sounds like it should -- I just did a Google search and found this on an
> > > MSFT forum:
> > >
> > > "Office Pro Plus in Office 365 is the same Office bits as Office 2010, so
> > > any VBA development you've done that works with Office 2010 today will
> > > continue to work in Office 365."
> > >
> > > However, I've also seen comments that VBA doesn't work with the Cloud
> > > apps...
> > >
> > > So maybe the answer is yes AND no?
> > >
> > > Has anyone tried it?
> > >
> > >
> > > On Sat, Feb 2, 2013 at 8:07 PM, cgrablew wrote:
> > >
> > >> Will the smf_addin work in new Office 365?
> > >>
> > >
> > >
> > >
> > >
> >
>
Regards,
Ashwin
--- In smf_addin@yahoogrou
>
>
>
> So far (2 days) the RCH Stock Market Functions seem to be working perfectly in the released version of Office 365 Home Premium. Using the 29 Dec 12 2.1 release of RCH in 32-bit Office version running on Windows 8 64-bit.
>
> Thanks for a wonderfully useful utility.
>
> Bob
>
>
> --- In smf_addin@yahoogrou
> >
> > works on the excel 2013 preview
> >
> > -dave
> >
> >
> > On Sat, Feb 2, 2013 at 7:28 PM, Randy Harmelink wrote:
> >
> > >
> > >
> > > Sounds like it should -- I just did a Google search and found this on an
> > > MSFT forum:
> > >
> > > "Office Pro Plus in Office 365 is the same Office bits as Office 2010, so
> > > any VBA development you've done that works with Office 2010 today will
> > > continue to work in Office 365."
> > >
> > > However, I've also seen comments that VBA doesn't work with the Cloud
> > > apps...
> > >
> > > So maybe the answer is yes AND no?
> > >
> > > Has anyone tried it?
> > >
> > >
> > > On Sat, Feb 2, 2013 at 8:07 PM, cgrablew wrote:
> > >
> > >> Will the smf_addin work in new Office 365?
> > >>
> > >
> > >
> > >
> > >
> >
>
Tue May 14, 2013 1:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The easiest way to test it is to check if the version can be returned, with:
=RCHGetElementNumber("Version")
On Mon, May 13, 2013 at 11:38 PM, Ashwin Kumar <ashwin_rn186@yahoo.com >wrote:
> Can u please give me the step-by-step instruction on how to install it. I
> actually installed it, not sure whether it is working or not. but I dont
> know how to test it too. Kindly help me in this regard.
>
=RCHGetElementNumbe
On Mon, May 13, 2013 at 11:38 PM, Ashwin Kumar <ashwin_rn186@
> Can u please give me the step-by-step instruction on how to install it. I
> actually installed it, not sure whether it is working or not. but I dont
> know how to test it too. Kindly help me in this regard.
>
Tue May 14, 2013 1:57 am (PDT) . Posted by:
"bagzigingahouse" bagzigingahouse
Hello Randy
i am trying to get the csv file from ivolatility.com and im not sure what im doing wrong. Could you maybe check why is this not working?
=smfGetCSVFile("http://www.ivolatility.com/favourites.csv?fav_g=52182 ")
I know ivol is kind of special case, so if this cant be done, is there a way to get the entire table from them some other way?
Thanks,
Igor
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> This appears to work just fine:
>
> =smfGetCSVFile("
> http://cfe.cboe.com/Publish/ScheduledTask/MktData/datahouse/CFE_F13_VX.csv ")
>
> On Wed, May 16, 2012 at 4:43 AM, bagzigingahouse
> <bagzigingahouse@...>wrote:
>
> > The files are contract months located here:
> >
> > http://cfe.cboe.com/Products/historicalVIX.aspx
> >
> > Each contract has its own file. Im going to review how the smfGetCSVFile()
> > function works in the meanwhile. Any further help is appreciated.
> >
>
i am trying to get the csv file from ivolatility.
=smfGetCSVFile(
I know ivol is kind of special case, so if this cant be done, is there a way to get the entire table from them some other way?
Thanks,
Igor
--- In smf_addin@yahoogrou
>
> This appears to work just fine:
>
> =smfGetCSVFile(
> http://cfe.cboe.
>
> On Wed, May 16, 2012 at 4:43 AM, bagzigingahouse
> <bagzigingahouse
>
> > The files are contract months located here:
> >
> > http://cfe.cboe.
> >
> > Each contract has its own file. Im going to review how the smfGetCSVFile(
> > function works in the meanwhile. Any further help is appreciated.
> >
>
Tidak ada komentar:
Posting Komentar