12 New Messages
Digest #2621
Messages
Thu May 16, 2013 6:21 am (PDT) . Posted by:
"willemlenaerts" willemlenaerts
Hello everybody,
Just updated to Excel 2013, and a previously perfectly functioning workbook now gives the Visual Basic "Insufficient Memory" Error.
I've tried a new workbook, with only one call to the smf addin, but I get the same error. Is there anybody with the same experience, and how can this be fixed?
Thanks in advance!
Kind regards,
Willem
Just updated to Excel 2013, and a previously perfectly functioning workbook now gives the Visual Basic "Insufficient Memory" Error.
I've tried a new workbook, with only one call to the smf addin, but I get the same error. Is there anybody with the same experience, and how can this be fixed?
Thanks in advance!
Kind regards,
Willem
Thu May 16, 2013 6:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not to be flippant, but add more memory?
Can you use Task Manager to see which processes you have running are using
up the memory?
On Thu, May 16, 2013 at 6:17 AM, willemlenaerts
<willemlenaerts@hotmail.com >wrote:
>
> Just updated to Excel 2013, and a previously perfectly functioning
> workbook now gives the Visual Basic "Insufficient Memory" Error.
> I've tried a new workbook, with only one call to the smf addin, but I get
> the same error. Is there anybody with the same experience, and how can this
> be fixed?
>
Can you use Task Manager to see which processes you have running are using
up the memory?
On Thu, May 16, 2013 at 6:17 AM, willemlenaerts
<willemlenaerts@
>
> Just updated to Excel 2013, and a previously perfectly functioning
> workbook now gives the Visual Basic "Insufficient Memory" Error.
> I've tried a new workbook, with only one call to the smf addin, but I get
> the same error. Is there anybody with the same experience, and how can this
> be fixed?
>
Thu May 16, 2013 2:21 pm (PDT) . Posted by:
"Roger" rogerdiazbernal
How to extract data 10 quarters of all income statement from Wikinvest
for http://www.wikinvest.com/stock/3M_Company_%28MMM%29/Data/Income_Statement#Income_Statement
using smfGetCSVFile
Roger
for http://www.wikinves
using smfGetCSVFile
Roger
Thu May 16, 2013 6:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see a way to do it, since the extended data is placed on the web
page dynamically. And I don't see a CSV file option?
On Thu, May 16, 2013 at 2:21 PM, Roger <rogerdiazb@gmail.com > wrote:
> How to extract data 10 quarters of all income statement from Wikinvest
> for
> http://www.wikinvest.com/stock/3M_Company_%28MMM%29/Data/Income_Statement#Income_Statement
> using smfGetCSVFile
>
page dynamically. And I don't see a CSV file option?
On Thu, May 16, 2013 at 2:21 PM, Roger <rogerdiazb@gmail.
> How to extract data 10 quarters of all income statement from Wikinvest
> for
> http://www.wikinves
> using smfGetCSVFile
>
Thu May 16, 2013 6:14 pm (PDT) . Posted by:
"bob_15861586" bob_15861586
I am trying to use the SMF macros to get the value of index calls
on the S&P 500. However, it is not working. Here is the call
that I am using:
smfGetYahooOptionQuote(B9,"C",C9,D9,"a")
where the cell B9 has the value: ^SPX
the cell C9 has the value: Sep-13
and the cell D9 has the value: 1700
Is there something I am doing wrong?
Bob
on the S&P 500. However, it is not working. Here is the call
that I am using:
smfGetYahooOptionQu
where the cell B9 has the value: ^SPX
the cell C9 has the value: Sep-13
and the cell D9 has the value: 1700
Is there something I am doing wrong?
Bob
Thu May 16, 2013 6:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but Yahoo handles index options differently than other items, so the
function isn't set up to work with them.
For example, if you go to the ^GSPC page (i.e. ^SPX), there aren't even any
options listed:
http://finance.yahoo.com/q?s= ^SPX
http://finance.yahoo.com/q?s= ^GSPC
On Thu, May 16, 2013 at 2:09 PM, bob_15861586 <bob_15861586@yahoo.com >wrote:
> I am trying to use the SMF macros to get the value of index calls
> on the S&P 500. However, it is not working. Here is the call
> that I am using:
> smfGetYahooOptionQuote(B9,"C",C9,D9,"a")
> where the cell B9 has the value: ^SPX
> the cell C9 has the value: Sep-13
> and the cell D9 has the value: 1700
>
> Is there something I am doing wrong?
>
function isn't set up to work with them.
For example, if you go to the ^GSPC page (i.e. ^SPX), there aren't even any
options listed:
http://finance.
http://finance.
On Thu, May 16, 2013 at 2:09 PM, bob_15861586 <bob_15861586@
> I am trying to use the SMF macros to get the value of index calls
> on the S&P 500. However, it is not working. Here is the call
> that I am using:
> smfGetYahooOptionQu
> where the cell B9 has the value: ^SPX
> the cell C9 has the value: Sep-13
> and the cell D9 has the value: 1700
>
> Is there something I am doing wrong?
>
Thu May 16, 2013 8:02 pm (PDT) . Posted by:
"hjreed@swbell.net" hjreed@swbell.net
Randy
I want to pull the "Bullish" and "Bearish" numbers off of www.aaii.com/sentimentsurvey.
Here's what I am using to capture the numbers:
=LEFT(RCHGetWebData("http://www.aaii.com/sentimentsurvey ","Bullish",168,169),4)
It works, but is there a "better", "more efficient" way to do this?
Thank you...
I want to pull the "Bullish" and "Bearish" numbers off of www.aaii.com/
Here's what I am using to capture the numbers:
=LEFT(RCHGetWebData
It works, but is there a "better"
Thank you...
Thu May 16, 2013 8:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetWebData() is usually my function of last resort. In this case, what
you want is within a table cell, so this could extract it:
=RCHGetTableCell("http://www.aaii.com/sentimentsurvey ",1,">Bullish";)
Unfortunately, they have both pieces of data within the table, using "span"
tags, so that ends up with:
38.5%down 2.3
You certainly could extract it from that string with smfStrExtr(). But you
could also extract it directly from the first "span" tag within that table
cell, with:
=smfConvertData(smfGetTagContent("http://www.aaii.com/sentimentsurvey
","span",1,">Bullish";))
...so that is what I would have ended up using.
Your use of the "Bullish" search string below is unreliable, as that string
appears numerous places on the web page, including within Meta tags that
describe the web page. The ">" prefix above, if how they code the web page,
is usually a useful way to make a search string unique.
And that is usually my preferred order of extraction, depending on which is
the first to work properly:
-- RCHGetTableCell()
-- smfGetTagContent()
-- RCHGetWebData()
However, in all three cases, it can take looking at the coding of the
source code of the web page to determine right away which is appropriate,
and which search terms may be unique (and will remain consistent) within
the source code.
On Thu, May 16, 2013 at 8:02 PM, hjreed@swbell.net <hjreed@swbell.net >wrote:
>
> I want to pull the "Bullish" and "Bearish" numbers off of
> www.aaii.com/sentimentsurvey.
>
> Here's what I am using to capture the numbers:
> =LEFT(RCHGetWebData("http://www.aaii.com/sentimentsurvey
> ","Bullish",168,169),4)
>
> It works, but is there a "better", "more efficient" way to do this?
>
you want is within a table cell, so this could extract it:
=RCHGetTableCell(
Unfortunately, they have both pieces of data within the table, using "span"
tags, so that ends up with:
38.5%down 2.3
You certainly could extract it from that string with smfStrExtr()
could also extract it directly from the first "span" tag within that table
cell, with:
=smfConvertData(
","
...so that is what I would have ended up using.
Your use of the "Bullish" search string below is unreliable, as that string
appears numerous places on the web page, including within Meta tags that
describe the web page. The ">" prefix above, if how they code the web page,
is usually a useful way to make a search string unique.
And that is usually my preferred order of extraction, depending on which is
the first to work properly:
-- RCHGetTableCell(
-- smfGetTagContent(
-- RCHGetWebData(
However, in all three cases, it can take looking at the coding of the
source code of the web page to determine right away which is appropriate,
and which search terms may be unique (and will remain consistent) within
the source code.
On Thu, May 16, 2013 at 8:02 PM, hjreed@swbell.
>
> I want to pull the "Bullish" and "Bearish" numbers off of
> www.aaii.com/
>
> Here's what I am using to capture the numbers:
> =LEFT(RCHGetWebData
> ","
>
> It works, but is there a "better"
>
Thu May 16, 2013 8:03 pm (PDT) . Posted by:
"almondtree" almondtree
does anyone else offer P&F charts, I really liked StockCharts stuff
Thanks for great works. Ditto
Thanks for great works. Ditto
Thu May 16, 2013 9:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
How were you using the data? StockCharts does have scans on P&F patterns:
http://stockcharts.com/def/servlet/SC.scan
On Thu, May 16, 2013 at 8:03 PM, almondtree <almondtree@yahoo.com > wrote:
> does anyone else offer P&F charts, I really liked StockCharts stuff
>
http://stockcharts.
On Thu, May 16, 2013 at 8:03 PM, almondtree <almondtree@yahoo.
> does anyone else offer P&F charts, I really liked StockCharts stuff
>
Fri May 17, 2013 1:05 am (PDT) . Posted by:
"anagoge" anagoge
I'm unable to get smfPricesByDates and RCHGetYahooHistory to adjust for dividends. For example, both of these:
=smfPricesByDates("VIIIX";,"12/31/2012") = 130.53 instead of Adj of 129.91
=smfPricesByDates("IWD","12/31/2012") = 72.82 instead of Adj of 72.47
return the values under Close instead of Adj Close on the web site based on these reference Links:
http://finance.yahoo.com/q/hp?s=VIIIX&d=4&e=17&f=2013&g=d&a=7&b=19&c=1997&z=66&y=66
http://finance.yahoo.com/q/hp?s=IWD&d=4&e=17&f=2013&g=d&a=4&b=26&c=2000&z=66&y=66
The web site numbers seem to properly adjust for dividends, but the link at the bottom to download the .csv does not adjust for dividends (Close = Adj Close) for that date. I assume this is a Yahoo bug, and there is nothing we can do about it? Or maybe the web site data and csv data get calculated/updated on different schedules?
=smfPricesByDates(
=smfPricesByDates(
return the values under Close instead of Adj Close on the web site based on these reference Links:
http://finance.
http://finance.
The web site numbers seem to properly adjust for dividends, but the link at the bottom to download the .csv does not adjust for dividends (Close = Adj Close) for that date. I assume this is a Yahoo bug, and there is nothing we can do about it? Or maybe the web site data and csv data get calculated/updated on different schedules?
Fri May 17, 2013 1:28 am (PDT) . Posted by:
"sri yanto" sri.yanto
hello randy
l had tried smfforcecalculation for the woorbook
it's works properly, and any ticker that before can't load,
now can loaded
but it take slower than before
does always like that?
Thank you
--- In smf_addin@yahoogroups.com , sri yanto <sri.yanto@...> wrote:
>
>
>
> hmm randy, i'd logged in before i run the addin
>
> okey randy i'll try smfforcecalculation first..thx before randy
>
> ________________________________
> From: Randy Harmelink <rharmelink@...>
> To: smf_addin@yahoogroups.com
> Sent: Thursday, May 16, 2013 1:43 PM
> Subject: Re: [smf_addin] Re: Need Help Randy - Reuters Error Notification
>
>
>
> Â
> PGAS.JK works here.
>
> Did you try it first BEFORE you logged in? If so, you'll need to run smfForceRecalculation (see LINKS area of group for more info) to force the add-in to retrieve the web page again. Otherwise, you're still trying to extract data from the web page retrieved before you logged in.
>
>
> On Wed, May 15, 2013 at 11:23 PM, sri yanto <sri.yanto@...> wrote:
>
> for particular stock it works, but for other stock like PGAS.JK
> >it's have a problem.
> >
>
l had tried smfforcecalculation for the woorbook
it's works properly, and any ticker that before can't load,
now can loaded
but it take slower than before
does always like that?
Thank you
--- In smf_addin@yahoogrou
>
>
>
> hmm randy, i'd logged in before i run the addin
>
> okey randy i'll try smfforcecalculation first..thx before randy
>
> ____________
> From: Randy Harmelink <rharmelink@
> To: smf_addin@yahoogrou
> Sent: Thursday, May 16, 2013 1:43 PM
> Subject: Re: [smf_addin] Re: Need Help Randy - Reuters Error Notification
>
>
>
> Â
> PGAS.JK works here.
>
> Did you try it first BEFORE you logged in? If so, you'll need to run smfForceRecalculati
>
>
> On Wed, May 15, 2013 at 11:23 PM, sri yanto <sri.yanto@
>
> for particular stock it works, but for other stock like PGAS.JK
> >it's have a problem.
> >
>
Tidak ada komentar:
Posting Komentar