Rabu, 06 Mei 2015

[smf_addin] Digest Number 3400

5 Messages

Digest #3400
1a
Re: Sector by "David Rossien" drrossien
2b
Re: RCHGetElementNumber function and arrays by "Randy Harmelink" rharmelink
3b
Re: Anyone encounter data delay update? by "Randy Harmelink" rharmelink

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

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.
>

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?


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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar