12 Messages
Digest #3382
Messages
Mon Apr 13, 2015 4:35 am (PDT) . Posted by:
"V. Shankar" tarakayan
| Stock Market Functions add-in, Version 2.1.2012.07.09 (C:\Program Files\SMF Add-In; 1) |
| 167.07 |
This is what I get...I need to download and install the latest?....This notebook I rarely use and while on travel..
On Friday, April 10, 2015 8:26 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I doubt it's the operating system. Are you sure you have the add-in installed properly? No unresolved links?
If you open a new workbook, what do you get for:
=RCHGetElementNumber("Version")
=RCHGetYahooQuotes("MMM","l1")
On Fri, Apr 10, 2015 at 6:35 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
SMF addin works fine in my Windows 8.1 system...Recently, in my windows xp Dell Vostro notebook, not able to see rchgetyahooquotes functions working (or appearing in excel cells)....what could be the problem?
#yiv3584425763 #yiv3584425763 -- #yiv3584425763ygrp-
Mon Apr 13, 2015 5:09 am (PDT) . Posted by:
"V. Shankar" tarakayan
I think the problem was due to reading off my "flash drive" and it was referring to smf in my other notebook drive.
I copied the files to this notebook desktop and checked/changed the links again in the cell formula....all values appeared...will check it again and report.
Thanks for your quick response, as always..
Shankar
On Monday, April 13, 2015 5:05 PM, "'V. Shankar' tarakayan@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
| Stock Market Functions add-in, Version 2.1.2012.07.09 (C:\Program Files\SMF Add-In; 1) |
| 167.07 |
This is what I get...I need to download and install the latest?....This notebook I rarely use and while on travel..
On Friday, April 10, 2015 8:26 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I doubt it's the operating system. Are you sure you have the add-in installed properly? No unresolved links?
If you open a new workbook, what do you get for:
=RCHGetElementNumber("Version")
=RCHGetYahooQuotes("MMM","l1")
On Fri, Apr 10, 2015 at 6:35 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
SMF addin works fine in my Windows 8.1 system...Recently, in my windows xp Dell Vostro notebook, not able to see rchgetyahooquotes functions working (or appearing in excel cells)....what could be the problem?
#yiv3514393939 #yiv3514393939 -- #yiv3514393939ygrp-
Mon Apr 13, 2015 10:52 am (PDT) . Posted by:
polomorabe
Hello Randy,
I'm also interested in being able to do this.
When I look at the Zachs screener tool, I can only see a list of predefined screening conditions.
On the left side pane:
Select a criteria: Popilar Criteria, Company descriptors, Size & Price changes, etc.
On the right side pane:
Select items: Zachs rank, Zachs indistry rank, growth score, value score, etc.
But I can't see a way to add a custom criteria such as "Next EPS Report Data" > 0.
Is this possible, or am I missing something?
Many thanks,
Paul
I'm also interested in being able to do this.
When I look at the Zachs screener tool, I can only see a list of predefined screening conditions.
On the left side pane:
Select a criteria: Popilar Criteria, Company descriptors, Size & Price changes, etc.
On the right side pane:
Select items: Zachs rank, Zachs indistry rank, growth score, value score, etc.
But I can't see a way to add a custom criteria such as "Next EPS Report Data" > 0.
Is this possible, or am I missing something?
Many thanks,
Paul
Mon Apr 13, 2015 12:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On the left side pane, click on the 7th item down, "EPS surprises and
Actuals". Then the "Next EPS Report Date" is the second item from the
bottom on the right side pane. Change the "EQUAL" to ">" and enter 0 in the
input box next to it, then click the "Add" button. Then you should see a
message in the middle of the screener that says: "Matches: 5896".
Just click on "Run Screen". Since the "Next EPS Report Date" was a
criteria, it's automatically part of the output view. Now just click the
"Export" tab at the top and it'll export a file you can open into EXCEL.
You can also include other fields in the view if you'd like. For example, I
know some people like to use the "Sector" and "Industry" fields.
On Mon, Apr 13, 2015 at 10:52 AM, polomora@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm also interested in being able to do this.
>
> When I look at the Zachs screener tool, I can only see a list of
> predefined screening conditions.
>
> On the left side pane:
> Select a criteria: Popilar Criteria, Company descriptors, Size & Price
> changes, etc.
>
> On the right side pane:
> Select items: Zachs rank, Zachs indistry rank, growth score, value score,
> etc.
>
> But I can't see a way to add a custom criteria such as "Next EPS Report
> Data" > 0.
> Is this possible, or am I missing something?
>
>
>
Actuals". Then the "Next EPS Report Date" is the second item from the
bottom on the right side pane. Change the "EQUAL" to ">" and enter 0 in the
input box next to it, then click the "Add" button. Then you should see a
message in the middle of the screener that says: "Matches: 5896".
Just click on "Run Screen". Since the "Next EPS Report Date" was a
criteria, it's automatically part of the output view. Now just click the
"Export" tab at the top and it'll export a file you can open into EXCEL.
You can also include other fields in the view if you'd like. For example, I
know some people like to use the "Sector" and "Industry" fields.
On Mon, Apr 13, 2015 at 10:52 AM, polomora@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm also interested in being able to do this.
>
> When I look at the Zachs screener tool, I can only see a list of
> predefined screening conditions.
>
> On the left side pane:
> Select a criteria: Popilar Criteria, Company descriptors, Size & Price
> changes, etc.
>
> On the right side pane:
> Select items: Zachs rank, Zachs indistry rank, growth score, value score,
> etc.
>
> But I can't see a way to add a custom criteria such as "Next EPS Report
> Data" > 0.
> Is this possible, or am I missing something?
>
>
>
Mon Apr 13, 2015 3:15 pm (PDT) . Posted by:
polomorabe
That's brilliant Randy, would never have found it on my own. Many thanks,
Paul
Paul
Mon Apr 13, 2015 11:47 am (PDT) . Posted by:
panda317
Randy;
I'm using this to fetch dividend yield from finviz.com;
=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")
It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because finviz.com doesn't have the info.
Is there an alternate (google?) that would perhaps have the correct and current info?
How would I change the above formula to accomodate this?
Thanks in advance.
You really need a tip jar, or a buy me a drink button, or some way for us to 'financially' show our appreciation.
I'm using this to fetch dividend yield from finviz.com;
=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin(
It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because finviz.com doesn't have the info.
Is there an alternate (google?) that would perhaps have the correct and current info?
How would I change the above formula to accomodate this?
Thanks in advance.
You really need a tip jar, or a buy me a drink button, or some way for us to 'financially&#
Mon Apr 13, 2015 12:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can get the dividend amount and yield from Google Finance with
something like:
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
...but it will be slower, because you'll need to retrieve a web page for
each ticker symbol.
As far as donations, I always ask people to "Pay it Forward" and donate
some of their profits to a charitable group. That way, it can also get a
little tax break. :)
On Mon, Apr 13, 2015 at 11:47 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm using this to fetch dividend yield from finviz.com;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend
> %")
>
> It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because
> finviz.com doesn't have the info.
>
> Is there an alternate (google?) that would perhaps have the correct and
> current info?
>
> How would I change the above formula to accomodate this?
>
> Thanks in advance.
>
> You really need a tip jar, or a buy me a drink button, or some way for us
> to 'financially' show our appreciation.
>
something like:
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
...but it will be slower, because you'll need to retrieve a web page for
each ticker symbol.
As far as donations, I always ask people to "Pay it Forward" and donate
some of their profits to a charitable group. That way, it can also get a
little tax break. :)
On Mon, Apr 13, 2015 at 11:47 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm using this to fetch dividend yield from finviz.com;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin(
> %")
>
> It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because
> finviz.com doesn't have the info.
>
> Is there an alternate (google?) that would perhaps have the correct and
> current info?
>
> How would I change the above formula to accomodate this?
>
> Thanks in advance.
>
> You really need a tip jar, or a buy me a drink button, or some way for us
> to 'financially&#
>
Mon Apr 13, 2015 1:09 pm (PDT) . Posted by:
panda317
How can I change this;
=RCHGetTableCell("http://finviz.com/quote.ashx?t= http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")
to use this (I just want the yield %);
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
My tickers are in column 'D'
Would it be something like this;
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&smfJoin($D10:$D$16,","),1,"Div/Yield"),"/","~"))
Thanks in advance
Pat
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
You can get the dividend amount and yield from Google Finance with something like:
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
...but it will be slower, because you'll need to retrieve a web page for each ticker symbol.
As far as donations, I always ask people to "Pay it Forward" and donate some of their profits to a charitable group. That way, it can also get a little tax break. :)
On Mon, Apr 13, 2015 at 11:47 AM, pat@... mailto:pat@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
I'm using this to fetch dividend yield from finviz.com http://finviz.com;
=RCHGetTableCell("http://finviz.com/quote.ashx?t= http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")
It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because finviz.com http://finviz.com doesn't have the info.
Is there an alternate (google?) that would perhaps have the correct and current info?
How would I change the above formula to accomodate this?
Thanks in advance.
You really need a tip jar, or a buy me a drink button, or some way for us to 'financially' show our appreciation.
=RCHGetTableCell("http://finviz.com/quote.ashx?t= http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")
to use this (I just want the yield %);
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
My tickers are in column 'D'
Would it be something like this;
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&smfJoin($D10:$D$16,","),1,"Div/Yield"),"/","~"))
Thanks in advance
Pat
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
You can get the dividend amount and yield from Google Finance with something like:
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
...but it will be slower, because you'll need to retrieve a web page for each ticker symbol.
As far as donations, I always ask people to "Pay it Forward" and donate some of their profits to a charitable group. That way, it can also get a little tax break. :)
On Mon, Apr 13, 2015 at 11:47 AM, pat@... mailto:pat@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
I'm using this to fetch dividend yield from finviz.com http://finviz.com;
=RCHGetTableCell("http://finviz.com/quote.ashx?t= http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")
It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because finviz.com http://finviz.com doesn't have the info.
Is there an alternate (google?) that would perhaps have the correct and current info?
How would I change the above formula to accomodate this?
Thanks in advance.
You really need a tip jar, or a buy me a drink button, or some way for us to 'financially&#
Mon Apr 13, 2015 1:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You would do this for row 10:
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$D10,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$D10,"td",1,"Div/Yield"),"/","~"))
...and copy the formulas down as needed. One formula per ticker.
On Mon, Apr 13, 2015 at 1:09 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> How can I change this;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend
> %")
>
> to use this (I just want the yield %);
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
>
> My tickers are in column 'D'
>
> Would it be something like this;
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&smfJoin($D10:$D$16,",")
> ,1,"Div/Yield"),"/","~"))
>
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$D10,"td",1,"Div/Yield"),"~","/"))
=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$D10,"td",1,"Div/Yield"),"/","~"))
...and copy the formulas down as needed. One formula per ticker.
On Mon, Apr 13, 2015 at 1:09 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> How can I change this;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend
> %")
>
> to use this (I just want the yield %);
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
>
> My tickers are in column 'D'
>
> Would it be something like this;
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&smfJoin(
> ,1,"Div/
>
Mon Apr 13, 2015 5:13 pm (PDT) . Posted by:
panda317
Thanks!
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q="&$D12,"td",1,"Div/Yield"),"/","~"))/100
works like a charm for row 12!
I had to add the '/100' so it would format correctly.
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q="&$D12,
works like a charm for row 12!
I had to add the '/100' so it would format correctly.
Mon Apr 13, 2015 5:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just be aware that if you get a #VALUE! result, it may be because the
add-in function is returning "Error"...which can't be divided by 100.
On Mon, Apr 13, 2015 at 5:13 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$D12,"td",1,"Div/Yield"),"/","~"))/100
>
> works like a charm for row 12!
>
> I had to add the '/100' so it would format correctly.
>
add-in function is returning "Error"...which can't be divided by 100.
On Mon, Apr 13, 2015 at 5:13 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$D12,
>
> works like a charm for row 12!
>
> I had to add the '/100' so it would format correctly.
>
Tue Apr 14, 2015 12:00 am (PDT) . Posted by:
panda317
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
Just be aware that if you get a #VALUE! result, it may be because the add-in function is returning "Error"...which can't be divided by 100.
That's ok. I'll just divide by zero in that case.
;-)
thanks again!
On Mon, Apr 13, 2015 at 5:13 PM, pat@... mailto:pat@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$D12,
works like a charm for row 12!
I had to add the '/100' so it would format correctly.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar