7 Messages
Digest #3521
1b
Re: SMF page link for listing of Institutions from Nasdaq no longer by "Randy Harmelink" rharmelink
2b
Re: =RCHGetYahooQuotes("^DJI","l1"), =RCHGetYahooQuotes("^DJI","p2") by "Randy Harmelink" rharmelink
Messages
Wed Sep 23, 2015 6:42 am (PDT) . Posted by:
shoenj
No... thank you for your brilliant wor! . However, I just uploaded and linked the page and in certain cells where the current share position should be, there is a repeat of the date rather than current share position. So the coding appears to be off somewhat.
In addition, since I am no good at coding, would it be possible to extend the rows with code say to 1000, so I would be able to capture all of the filings by company..Some publicly traded companies have several hundred holders, while other do not. I think a 1000 is a good round number.
Again, thank for you brilliant work on the SMF links. It helps me immensely.
Walt S
In addition, since I am no good at coding, would it be possible to extend the rows with code say to 1000, so I would be able to capture all of the filings by company..Some publicly traded companies have several hundred holders, while other do not. I think a 1000 is a good round number.
Again, thank for you brilliant work on the SMF links. It helps me immensely.
Walt S
Wed Sep 23, 2015 9:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Oops. Sorry. I fixed the "Shares Held" extraction and just uploaded the fix.
I really don't want to extend it to 1000 rows, because NASDAQ only shows 15
entries per page. That would mean retrieving an additional 65 web pages
each time it is used. Slow.
To extend it yourself, you could:
-- Copy the 15 rows for one page
-- Highlight those 15 rows
-- Do a "Find and Replace All", changing the page parameter of the URL
(e.g. "Page=3" to "Page=4"
Alternatively, you could make the page # a cell reference, so you could
just copy down. I was trying to make things so there were "stand alone", as
is, without needing cell references other than the ticker symbol.
Is there a different source of the data that would be more friendly for
that many holders?
On Wed, Sep 23, 2015 at 6:42 AM, shoenj@... wrote:
>
> No... thank you for your brilliant wor! . However, I just uploaded and
> linked the page and in certain cells where the current share position
> should be, there is a repeat of the date rather than current share
> position. So the coding appears to be off somewhat.
>
> In addition, since I am no good at coding, would it be possible to extend
> the rows with code say to 1000, so I would be able to capture all of the
> filings by company..Some publicly traded companies have several hundred
> holders, while other do not. I think a 1000 is a good round number.
>
> Again, thank for you brilliant work on the SMF links. It helps me
> immensely.
>
I really don't want to extend it to 1000 rows, because NASDAQ only shows 15
entries per page. That would mean retrieving an additional 65 web pages
each time it is used. Slow.
To extend it yourself, you could:
-- Copy the 15 rows for one page
-- Highlight those 15 rows
-- Do a "Find and Replace All", changing the page parameter of the URL
(e.g. "Page=3" to "Page=4"
Alternatively, you could make the page # a cell reference, so you could
just copy down. I was trying to make things so there were "stand alone", as
is, without needing cell references other than the ticker symbol.
Is there a different source of the data that would be more friendly for
that many holders?
On Wed, Sep 23, 2015 at 6:42 AM, shoenj@... wrote:
>
> No... thank you for your brilliant wor! . However, I just uploaded and
> linked the page and in certain cells where the current share position
> should be, there is a repeat of the date rather than current share
> position. So the coding appears to be off somewhat.
>
> In addition, since I am no good at coding, would it be possible to extend
> the rows with code say to 1000, so I would be able to capture all of the
> filings by company..Some publicly traded companies have several hundred
> holders, while other do not. I think a 1000 is a good round number.
>
> Again, thank for you brilliant work on the SMF links. It helps me
> immensely.
>
Wed Sep 23, 2015 2:15 pm (PDT) . Posted by:
shoenj
Thanks Randy... I will give it a try. I am not aware of any other source that provides the entire listing of Institutions on their web sites...at least without a fee. If I do I will let you know.
Once again, thank you for the updated file and the information on how I can add more listings myself.
Walt S
Once again, thank you for the updated file and the information on how I can add more listings myself.
Walt S
Wed Sep 23, 2015 9:02 am (PDT) . Posted by:
trendsekr
This works fine for all the other indices (^GSPC, ^IXIC, ^NDX, ^RUT, ^RUI) but returns N/A for the ^DJI and any of it's specialty indices. Suggestions?
Wed Sep 23, 2015 9:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Dow Jones licensing doesn't allow Yahoo to provide current or historical
quotes in CSV format for any of the Dow Jones indexes. So
RCHGetYahooQuotes() and RCHGetYahooHistory(), which are based on the Yahoo
CSV files, won't work for the Dow Jones indexes.
You'd need to use other functions, like RCHGetTableCell() or
smfGetTagContent() to scrape the data off web pages.
I just use DIA instead, since most of the time I'm interested in total
return. The index wouldn't give me that correctly anyway.
On Wed, Sep 23, 2015 at 9:02 AM, trendsekr@... wrote:
> This works fine for all the other indices (^GSPC, ^IXIC, ^NDX, ^RUT, ^RUI)
> but returns N/A for the ^DJI and any of it's specialty indices. Suggestions?
>
quotes in CSV format for any of the Dow Jones indexes. So
RCHGetYahooQuotes(
CSV files, won't work for the Dow Jones indexes.
You'd need to use other functions, like RCHGetTableCell(
smfGetTagContent(
I just use DIA instead, since most of the time I'm interested in total
return. The index wouldn't give me that correctly anyway.
On Wed, Sep 23, 2015 at 9:02 AM, trendsekr@..
> This works fine for all the other indices (^GSPC, ^IXIC, ^NDX, ^RUT, ^RUI)
> but returns N/A for the ^DJI and any of it's specialty indices. Suggestions?
>
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. Fixed "Shares Held" extraction.
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>
Wed Sep 23, 2015 11:28 pm (PDT) . Posted by:
yolande_tulasse
You sir are awesome. Thanks for updating your templates so quickly
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar