EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3520

SMF page link for listing of Institutions from Nasdaq no longer work by shoenj

Re: SMF page link for listing of Institutions from Nasdaq no longer by "Randy Harmelink" rharmelink

Elements for identification by JCHyjun

3.1

New file uploaded to smf_addin by

Fw: important by grandcanuck

Messages

1a

SMF page link for listing of Institutions from Nasdaq no longer work

Tue Sep 22, 2015 6:16 am (PDT) . Posted by:

shoenj

Hi Randy,

I have been a user of various pages and using smf links for some time. I have never had an issue until recently. I have been using the link that you created to view the listing of Institutional investors as i look for where flow of money is going by the pro's each quarter.

Just in the past week or so, the data no longer comes in. Perhaps Nasdaq changed its website or code.

When you have some time, can you review the page that you created and see if you can get it to update.

I have attached the excel file-page that you created in case its no longer in your database.

Much appreciated.

Walt S

Attachment(s) from

1 of 1 File(s)

RCHGetTableCell-Template-NASDAQ-Institutional-Holders.xls

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: SMF page link for listing of Institutions from Nasdaq no longer

Tue Sep 22, 2015 6:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. They changed both the URL and the layout of the
web page.

I've updated the template and uploaded the new version to the FILES area of
the Yahoo group.

On Tue, Sep 22, 2015 at 6:15 AM, shoenj@y... wrote:

> I have been a user of various pages and using smf links for some time. I
> have never had an issue until recently. I have been using the link that
> you created to view the listing of Institutional investors as i look for
> where flow of money is going by the pro's each quarter.
>
> Just in the past week or so, the data no longer comes in. Perhaps Nasdaq
> changed its website or code.
>
> When you have some time, can you review the page that you created and see
> if you can get it to update.
>
> I have attached the excel file-page that you created in case its no longer
> in your database.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2 Elements for identification

Tue Sep 22, 2015 6:30 am (PDT) . Posted by:

JCHyjun

Dear Randy,
Thank you very much for SMF AddIn - I cannot imagine my investment decisions without it. I combine information about stocks from different databases using your tool and templates.

Usually company ticker is good enough for identification of the company, although various databases use different syntacs (e.g. IGG.L vs LON:IGG for IG Group in UK). Unfortunately sometimes the same ticker is used for different companies in different databases.

Right now you have only the single RCH element for company/industry name.
I think it is worth to have RCH elements for company name, industry name, country for each database (Morningstar, Yahoo, Zaks, Google, etc...) actively used in SMF AddIn. It would help avoid confusion for non-unique ticker cases (see examples below).

Thank you.
J. Chang

ABR Arbor Realty Trust Inc USA NYS
ABR Ashburton Ventures Inc Canada TVX
ADK Diagnos Inc Canada TVX
ADK AdCare Health Systems, Inc. USA ASE
BFS Saul Centers, Inc. USA NYS
BFS BFS Entertainment & Multimedia Ltd. Canada TVX
BKD Breaking Data Corp Canada TVX
BKD Brookdale Senior Living Inc USA NYS
CSU Constellation Software Inc Canada TSX
CSU Capital Senior Living Corp. USA NYS
CSV Carriage Services, Inc. USA NYS
CSV Caracara Silver Inc. Canada TVX
CVG Clairvest Group Inc. Canada TSX
CVG Convergys Corp. USA NYS
ESS Essex Property Trust, Inc. USA NYS
ESS Esstra Industries, Inc. Canada TVX
FC Firm Capital Mortgage Investment Corp Canada TSX
FC Franklin Covey Co. USA NYS
GEN Genesis Healthcare Inc USA NYS
GEN Genenews Ltd Canada TSX
IT Intertain Group Ltd (The) Canada TSX
IT Gartner, Inc. USA NYS
MGI MoneyGram International Inc USA NMS
MGI Magnum Goldcorp Inc Canada TVX
NCI NTG Clarity Networks Inc. Canada TVX
NCI Navigant Consulting, Inc. USA NYS
NRT North European Oil Royalty Trust USA NYS
NRT Big North Graphite Corp Canada TVX
ONE 01 Communique Laboratory Inc. Canada TVX
ONE Higher One Holdings Inc. USA NYS
PTC PTC Inc USA NMS
PTC Petrox Resource Corp Canada TVX
TCI Target Capital Inc Canada CNQ
TCI Transcontinental Realty Investors, Inc. USA NYS
TCX Tucows Inc USA NAS
TCX ThermoCeramix Corp Canada TVX
SAP SAP SE USA NYS
SAP Saputo Inc Canada TSX

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

3.1 New file uploaded to smf_addin

Tue Sep 22, 2015 6:47 am (PDT) . Posted by:

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Templates and Examples/RCHGetTableCell/RCHGetTableCell-Template-NASDAQ-Institutional-Holders.xls
Uploaded by : rharmelink <rharmelink@gmail.com>
Description : A template that use the RCHGetTableCell() function to retrieve the distribution of institutional holders of a stock from the NASDAQ website.

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-NASDAQ-Institutional-Holders.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

rharmelink <rharmelink@gmail.com>