5 Messages
Digest #3400
Messages
Tue May 5, 2015 5:11 am (PDT) . Posted by:
"David Rossien" drrossien
I mention that the quasi-standard in the industry is GICS http://en.m.wikipedia.org/wiki/Global_Industry_Classification_Standard, 10 Sectors and 67 industries. Competing solutions include ICB http://en.m.wikipedia.org/wiki/Industry_Classification_Benchmark and BICS http://www.bloombergindexes.com/content/uploads/sites/3/2013/05/Index-Family-Methodology.pdf. These are available in a number of places but because they are proprietary I won't post urls and suggest Googling.
Sent from my iPhone
Sent from my iPhone
Tue May 5, 2015 11:55 am (PDT) . Posted by:
bebentrim
I think I can, but I am having a problem even pulling RCH Elements, ie, 5079 comes back undefined. email me at brent@carolopolis.com
Tue May 5, 2015 1:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
"Undefined" means you didn't extract all of the files in the ZIP archive,
because the element definitions are in the smf-elements-*.txt files. They
need to be in the same folder as the XLA file.
On Tue, May 5, 2015 at 11:55 AM, brent@... wrote:
>
> I think I can, but I am having a problem even pulling RCH Elements, ie,
> 5079 comes back undefined.
>
because the element definitions are in the smf-elements-
need to be in the same folder as the XLA file.
On Tue, May 5, 2015 at 11:55 AM, brent@... wrote:
>
> I think I can, but I am having a problem even pulling RCH Elements, ie,
> 5079 comes back undefined.
>
Tue May 5, 2015 8:09 pm (PDT) . Posted by:
tzewei_79
Hi,
I just found out, my formula is catching the closed price of MCD 2 days ago. It can't update the latest from the website.
=RCHGetTableCell("http://www.finviz.com/quote.ashx?t=MCD,1,"Current Stock Price")
Current'y it is 96.13 but I'm getting 97.8.
Is there an option in excel 2007?
I just found out, my formula is catching the closed price of MCD 2 days ago. It can't update the latest from the website.
=RCHGetTableCell("http://www.finviz.com/quote.ashx?t=MCD,1,"Current Stock Price")
Current'
Is there an option in excel 2007?
Tue May 5, 2015 9:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Two possible fixes come to mind:
1. Make sure your Internet Options are set to always get a fresh copy of
web pages.
2. Either exit and restart EXCEL, or run the smfForceRecalculation macro --
the add-in saves copies of web pages before data is extracted, so that
saved copy needs to be purged before a fresh copy of the web page can be
retrieved.
Either of those situations could cause the add-in to be extracting data
from a cached copy of the web page.
On Tue, May 5, 2015 at 8:09 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I just found out, my formula is catching the closed price of MCD 2 days
> ago. It can't update the latest from the website.
>
> =RCHGetTableCell("http://www.*finviz*.com/quote.ashx?t=*MCD*,1,"Current
> Stock Price")
>
> Current'y it is 96.13 but I'm getting 97.8.
>
> Is there an option in excel 2007?
>
1. Make sure your Internet Options are set to always get a fresh copy of
web pages.
2. Either exit and restart EXCEL, or run the smfForceRecalculation macro --
the add-in saves copies of web pages before data is extracted, so that
saved copy needs to be purged before a fresh copy of the web page can be
retrieved.
Either of those situations could cause the add-in to be extracting data
from a cached copy of the web page.
On Tue, May 5, 2015 at 8:09 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I just found out, my formula is catching the closed price of MCD 2 days
> ago. It can't update the latest from the website.
>
> =RCHGetTableCell("http://www.*finviz*.com/quote.ashx?t=*MCD*,1,"Current
> Stock Price")
>
> Current'
>
> Is there an option in excel 2007?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar