7 Messages
Digest #4374
Messages
Sat Aug 4, 2018 7:16 am (PDT) . Posted by:
dan.smith33220@gmail.com
I'm using smfPricesByDates to return prices for several Fidelity mutual funds for different time periods. Most of the data appears to be fine, but I'm seeing some issues in the returned data that appears to be related to the add-in.
For instance, here is the incorrect data returned for a series of dates for FSELX:
FSELX
02-28-17 -0.1492
03-31-17 -0.1542
04-28-17 -0.2214
However, if I start with 1/31/17, I get correct data:
FSELX
01-31-17 8.4373
02-28-17 8.7332
03-31-17 9.0247
04-28-17 8.8863
I've tried entering other random January dates in the range and INCORRECT data is returned. I've also placed the 1/31/17 date at other positions (like the second or third date requested) and CORRECT data is returned.
The formula being used is an array formula:
=TRANSPOSE(smfPricesByDates(C$2, $A3:$A21))
For instance, here is the incorrect data returned for a series of dates for FSELX:
FSELX
02-28-17 -0.1492
03-31-17 -0.1542
04-28-17 -0.2214
However, if I start with 1/31/17, I get correct data:
FSELX
01-31-17 8.4373
02-28-17 8.7332
03-31-17 9.0247
04-28-17 8.8863
I've tried entering other random January dates in the range and INCORRECT data is returned. I've also placed the 1/31/17 date at other positions (like the second or third date requested) and CORRECT data is returned.
The formula being used is an array formula:
=TRANSPOSE(smfPrice
Sat Aug 4, 2018 7:37 am (PDT) . Posted by:
dan.smith33220@gmail.com
I should add that this phenomena does not occur for other mutual funds. Very strange.
Sat Aug 4, 2018 7:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not seeing the problem here when I try those dates:
FSELX
2017-02-28 $8.73
2017-03-31 $9.02
2017-04-28 $8.89
Can you create a sample workbook with just the erring formula and attach it
to a message?
On Sat, Aug 4, 2018 at 7:15 AM, dan.smith33220@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm using smfPricesByDates to return prices for several Fidelity mutual
> funds for different time periods. Most of the data appears to be fine,
> but I'm seeing some issues in the returned data that appears to be related
> to the add-in.
>
> For instance, here is the incorrect data returned for a series of dates
> for FSELX:
>
> FSELX
>
> 02-28-17 -0.1492
>
> 03-31-17 -0.1542
>
> 04-28-17 -0.2214
>
> However, if I start with 1/31/17, I get correct data:
>
> FSELX
>
> 01-31-17 8.4373
>
> 02-28-17 8.7332
>
> 03-31-17 9.0247
>
> 04-28-17 8.8863
>
> I've tried entering other random January dates in the range and INCORRECT
> data is returned. I've also placed the 1/31/17 date at other positions
> (like the second or third date requested) and CORRECT data is returned.
>
> The formula being used is an array formula:
>
> =TRANSPOSE(smfPricesByDates(C$2, $A3:$A21))
>
>
>
FSELX
2017-02-28 $8.73
2017-03-31 $9.02
2017-04-28 $8.89
Can you create a sample workbook with just the erring formula and attach it
to a message?
On Sat, Aug 4, 2018 at 7:15 AM, dan.smith33220@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm using smfPricesByDates to return prices for several Fidelity mutual
> funds for different time periods. Most of the data appears to be fine,
> but I'm seeing some issues in the returned data that appears to be related
> to the add-in.
>
> For instance, here is the incorrect data returned for a series of dates
> for FSELX:
>
> FSELX
>
> 02-28-17 -0.1492
>
> 03-31-17 -0.1542
>
> 04-28-17 -0.2214
>
> However, if I start with 1/31/17, I get correct data:
>
> FSELX
>
> 01-31-17 8.4373
>
> 02-28-17 8.7332
>
> 03-31-17 9.0247
>
> 04-28-17 8.8863
>
> I've tried entering other random January dates in the range and INCORRECT
> data is returned. I've also placed the 1/31/17 date at other positions
> (like the second or third date requested) and CORRECT data is returned.
>
> The formula being used is an array formula:
>
> =TRANSPOSE(smfPrice
>
>
>
Sat Aug 4, 2018 7:12 pm (PDT) . Posted by:
s_trader888
Hi. I've been happily using SMF Addin for years (thanks, Randy!) to retrieve stock data from Finviz... but have never figured out how to get the full company name for a given symbol (e.g., "Alcoa Corporation" for "AA").
Been using the following format for my cells (ticker in cell A1, and using "Price" as the example metric here):
=RCHGetTableCell("https://finviz.com/quote.ashx?t=" &$A1,1,">Price")
I've tried "Company," "Name," "Company Name," etc. -- no luck. Can someone please help me with that?
Thanks!
Been using the following format for my cells (ticker in cell A1, and using "Price" as the example metric here):
=RCHGetTableCell("https://finviz.com/quote.ashx?t=" &$A1,1,"
I've tried "Company,
Thanks!
Sat Aug 4, 2018 8:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Easiest is probably to pull it from the title of the web page:
=smfStrExtr(smfGetTagContent("https://finviz.com/quote.ashx?t="&$A1,"title",1),"
"," Stock Quote")
On Sat, Aug 4, 2018 at 7:12 PM, 888hitrader@
....
wrote:
> Hi. I've been happily using SMF Addin for years (thanks, Randy!) to
> retrieve stock data from Finviz... but have never figured out how to get
> the full company name for a given symbol (e.g., "Alcoa Corporation" for
> "AA").
>
> Been using the following format for my cells (ticker in cell A1, and using
> "Price" as the example metric here):
>
> =RCHGetTableCell("https://finviz.com/quote.ashx?t=" &$A1,1,">Price")
>
> I've tried "Company," "Name," "Company Name," etc. -- no luck. Can
> someone please help me with that?
>
>
>
=smfStrExtr(smfGetTagContent("https://finviz.com/quote.ashx?t="&$A1,"title",1),"
"," Stock Quote")
On Sat, Aug 4, 2018 at 7:12 PM, 888hitrader@
....
wrote:
> Hi. I've been happily using SMF Addin for years (thanks, Randy!) to
> retrieve stock data from Finviz... but have never figured out how to get
> the full company name for a given symbol (e.g., "Alcoa Corporation" for
> "AA").
>
> Been using the following format for my cells (ticker in cell A1, and using
> "Price" as the example metric here):
>
> =RCHGetTableCell("https://finviz.com/quote.ashx?t=" &$A1,1,"
>
> I've tried "Company,
> someone please help me with that?
>
>
>
Sat Aug 4, 2018 7:51 pm (PDT) . Posted by:
sjagers
Hi Randy,
Thanks for the reply.
When I use these formulas on my Windows Vista PC (Excel 2007), all three return "Error".
When I use these in Windows 10 (Excel 2007), all three return:
>Zacks Rank:</a> <span class="info-tooltip" rel="quote_rank_ribbon";></span> </label> <p class="rank_view"> 4-Sell <span class="rank_chip rankrect_1"> </s
Excel 2007 is common to both PCs.
Could Windows Vista (with IE 9) and Windows 10 (with IE 11) be using different versions of IE Object?
Maybe Zacks no longer supports the Ineternet Explorer version that my Vista PC uses?
Can you think of a workaround for my Windows Vista PC?
Thanks.
Thanks for the reply.
When I use these formulas on my Windows Vista PC (Excel 2007), all three return "Error"
When I use these in Windows 10 (Excel 2007), all three return:
>Zacks Rank:</a> <span class="
Excel 2007 is common to both PCs.
Could Windows Vista (with IE 9) and Windows 10 (with IE 11) be using different versions of IE Object?
Maybe Zacks no longer supports the Ineternet Explorer version that my Vista PC uses?
Can you think of a workaround for my Windows Vista PC?
Thanks.
Sat Aug 4, 2018 11:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you try the URL in the EXCEL IE object? That should confirm whether the
web page has an issue with the version of IE that EXCEL is using.
You can also use this web page to determine what version it is actually
using:
http://www.pinlady.net/PluginDetect/IE/
On my machine, I get these responses from the EXCEL IE object and my IE
browser:
------------------------------
Internet Explorer (IE) Detection
*Internet Explorer Browser Detector*
Your browser is IE: true
Your IE browser version: 11.137
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): 11.137.17134.0
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7
------------------------------
Internet Explorer (IE) Detection
*Internet Explorer Browser Detector*
Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): null
IE browser version (derived from navigator.userAgent): 11
IE browser document mode: 11
------------------------------
But, no, I don't know of a workaround. The add-in uses the same Microsoft
Internet engines that EXCEL is using.
On Sat, Aug 4, 2018 at 7:51 PM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks for the reply.
>
> When I use these formulas on my Windows Vista PC (Excel 2007), all three
> return "Error".
>
> When I use these in Windows 10 (Excel 2007), all three return:
>
> >Zacks Rank:</a> <span class="info-tooltip"
> rel="quote_rank_ribbon";></span> </label> <p
> class="rank_view"> 4-Sell
> <span class="rank_chip rankrect_1"> </s
> Excel 2007 is common to both PCs.
>
> Could Windows Vista (with IE 9) and Windows 10 (with IE 11) be using
> different versions of IE Object?
>
> Maybe Zacks no longer supports the Ineternet Explorer version that my
> Vista PC uses?
>
> Can you think of a workaround for my Windows Vista PC?
>
web page has an issue with the version of IE that EXCEL is using.
You can also use this web page to determine what version it is actually
using:
http://www.pinlady.net/PluginDetect/IE/
On my machine, I get these responses from the EXCEL IE object and my IE
browser:
------------------------------
Internet Explorer (IE) Detection
*Internet Explorer Browser Detector*
Your browser is IE: true
Your IE browser version: 11.137
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): 11.137.17134.0
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7
------------------------------
Internet Explorer (IE) Detection
*Internet Explorer Browser Detector*
Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): null
IE browser version (derived from navigator.userAgent): 11
IE browser document mode: 11
------------------------------
But, no, I don't know of a workaround. The add-in uses the same Microsoft
Internet engines that EXCEL is using.
On Sat, Aug 4, 2018 at 7:51 PM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks for the reply.
>
> When I use these formulas on my Windows Vista PC (Excel 2007), all three
> return "Error"
>
> When I use these in Windows 10 (Excel 2007), all three return:
>
> >Zacks Rank:</a> <span class="
> rel="quote_
> class="
> <span class="
> Excel 2007 is common to both PCs.
>
> Could Windows Vista (with IE 9) and Windows 10 (with IE 11) be using
> different versions of IE Object?
>
> Maybe Zacks no longer supports the Ineternet Explorer version that my
> Vista PC uses?
>
> Can you think of a workaround for my Windows Vista PC?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar