Selasa, 26 Juli 2016

[smf_addin] Digest Number 3754

6 Messages

Digest #3754
1c
Re: Yahoo and Verizon (or whoever) by "Randy Harmelink" rharmelink
1d
Re: Yahoo and Verizon (or whoever) by "Abraham Thomas" qatenary
2a
Ibd Stock Lists by "Scott Hutchens" shhutchens6
2b
Re: Ibd Stock Lists by "Randy Harmelink" rharmelink

Messages

Mon Jul 25, 2016 6:57 am (PDT) . Posted by:

john_hoel

You can get everything Yahoo provides except opening price and adjusted close from marketwatch. I use this for the closing price:

=IF(K44,RCHGetTableCell("http://bigcharts.marketwatch.com/historical/default.asp?symb=ADP&closeDate="&TEXT(B44,"mm/dd/yyyy"),1,"Closing Price:"),0)

Mon Jul 25, 2016 1:08 pm (PDT) . Posted by:

eadamy

I failed to mention adjusted close in my post; however adjusted close information is critical to any kind of modeling or backtesting and that is what I use.

I've been doing more research on Quandl Quandl Financial and Economic Data https://www.quandl.com/browse

Quandl Financial and Economic Data https://www.quandl.com/browse


View on www.quandl.com https://www.quandl.com/browse
Preview by Yahoo



this morning since that is the only source I know of which provides long term historical adjusted close. Access to the WIKI quote database is free, includes adjusted close, but is limited to 3000 company stocks. The Quote Media database, which also includes adjusted close and historical data back to 1998 is $49/month or $440/year, includes all listed stocks including ETFs but does not include mutual funds.



Quandl has an Excel API via a downloadable XLAM file. The ribbon style interface is clean and it can handle and date align multiple symbols in a single call. There is no VBA interface; however I have corresponded with Tammer Kamel, the founder in years past and he is very amenable to improvements which make the data more widely available. Have you/would you consider interfacing the SMF modules to Quandl?


Mon Jul 25, 2016 1:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The easiest way to allow easier access to any data is the use of
customizable CSV files. Not only is it easier for the person accessing the
data, but it should allow a more efficient way for the provider to convey
the data.

For example, look at the Yahoo current quotes CSV files, or the previously
free FinViz CSV files. MorningStar has done some things, but could have
allowed for more customized access.

On Mon, Jul 25, 2016 at 1:08 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I failed to mention adjusted close in my post; however adjusted close
> information is critical to any kind of modeling or backtesting and that is
> what I use.
>
> I've been doing more research on Quandl Quandl Financial and Economic Data
> <https://www.quandl.com/browse>
> Quandl Financial and Economic Data <https://www.quandl.com/browse>
> View on www.quandl.com <https://www.quandl.com/browse>
> Preview by Yahoo
>
>
> this morning since that is the only source I know of which provides long
> term historical adjusted close. Access to the WIKI quote database is free,
> includes adjusted close, but is limited to 3000 company stocks. The Quote
> Media database, which also includes adjusted close and historical data back
> to 1998 is $49/month or $440/year, includes all listed stocks including
> ETFs but does not include mutual funds.
>
> Quandl has an Excel API via a downloadable XLAM file. The ribbon style
> interface is clean and it can handle and date align multiple symbols in a
> single call. There is no VBA interface; however I have corresponded with
> Tammer Kamel, the founder in years past and he is very amenable to
> improvements which make the data more widely available. Have you/would you
> consider interfacing the SMF modules to Quandl?
>
>

Mon Jul 25, 2016 2:03 pm (PDT) . Posted by:

"Abraham Thomas" qatenary

For what it's worth, Quandl offers customizable CSV file downloads. For
example, to get monthly closing prices for Facebook in 2014:

https://www.quandl.com/api/v3/datasets/WIKI/FB.csv?column_index=4&start_date=2014-01-01&end_date=2014-12-31&collapse=monthly

More customization and download options are documented here:
https://www.quandl.com/docs/api?csv

On Mon, Jul 25, 2016 at 4:43 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> The easiest way to allow easier access to any data is the use of
> customizable CSV files. Not only is it easier for the person accessing the
> data, but it should allow a more efficient way for the provider to convey
> the data.
>
> For example, look at the Yahoo current quotes CSV files, or the previously
> free FinViz CSV files. MorningStar has done some things, but could have
> allowed for more customized access.
>
> On Mon, Jul 25, 2016 at 1:08 PM, earladamy@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> I failed to mention adjusted close in my post; however adjusted close
>> information is critical to any kind of modeling or backtesting and that is
>> what I use.
>>
>> I've been doing more research on Quandl Quandl Financial and Economic
>> Data <https://www.quandl.com/browse>
>> Quandl Financial and Economic Data <https://www.quandl.com/browse>
>> View on www.quandl.com <https://www.quandl.com/browse>
>> Preview by Yahoo
>>
>>
>> this morning since that is the only source I know of which provides long
>> term historical adjusted close. Access to the WIKI quote database is free,
>> includes adjusted close, but is limited to 3000 company stocks. The Quote
>> Media database, which also includes adjusted close and historical data back
>> to 1998 is $49/month or $440/year, includes all listed stocks including
>> ETFs but does not include mutual funds.
>>
>> Quandl has an Excel API via a downloadable XLAM file. The ribbon style
>> interface is clean and it can handle and date align multiple symbols in a
>> single call. There is no VBA interface; however I have corresponded with
>> Tammer Kamel, the founder in years past and he is very amenable to
>> improvements which make the data more widely available. Have you/would you
>> consider interfacing the SMF modules to Quandl?
>>
>>
>
>
>

Mon Jul 25, 2016 1:52 pm (PDT) . Posted by:

"Scott Hutchens" shhutchens6

Hey there,I am trying to get various stock lists from IBD such at the IBD 50 and CANSLIM Select. I am a subscriber to IBD and tried the use the RCHHTMLTable and RCHGetTableCell functions but I seem to only get the same table with the same five tickers, here is the function, =RCHGetHTMLTable("http://research.investors.com/stock-lists/ibd-50/","symbol",1). I think this might be a preview of the IBD 50 that excel is pulling from IBD without being signed in. In the past I have tried to access IBD through excel and was able to create the security cookie and used the ibd Template a few times but that was a couple years ago. Recently, I haven't been able to get create the security certificate due to the dreaded script error loop and having to use the task manager to exit excel. I have researched this topic a few times in the past few weeks but haven't been able to get excel and IBD to work together. 
Basically, I want to automate and expedite my ibd experience, which entails getting the stocks lists and the composite ranking metric for 1300 stocks into excel. Any help on this subject would be greatly appreciated. And thanks again Randy for making this amazing tool I use all the time.

Mon Jul 25, 2016 5:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your supposition is correct -- the original web page they send only has a
list of 5 companies. Then, some script processing checks the security level
and dynamically adds the other 45 items if you're a subscriber. Since their
change late last year, I've had to change my eTable processing, and been
grabbing the table from the eTables print option:

=RCHGetHTMLTable("
http://research.investors.com/etables/IBD50IndexPrint.aspx?tabView=IBD100&columnsort1=ibd100rank&columnsorttype1=DESC&columnsort2=&columnsorttype2=DESC&search=&filter=
","Company")

An alternative I played with was opening the XLS version. I had a VBA
routine that would be triggered by a change in a cell, then download the
workbook from IBD, copy the worksheet to my sheet, then close the opened
workbook.

How are you planning to get the metrics for 1300 stocks? Both the add-in
and IBD have download limits less than that.

Late last year, when they changed things up, this was my path to getting
logged in:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/29668

On Mon, Jul 25, 2016 at 1:48 PM, Scott Hutchens shhutchens6@
​... ​
wrote:

>
> I am trying to get various stock lists from IBD such at the IBD 50 and
> CANSLIM Select. I am a subscriber to IBD and tried the use the RCHHTMLTable
> and RCHGetTableCell functions but I seem to only get the same table with
> the same five tickers, here is the function, =RCHGetHTMLTable("
> http://research.investors.com/stock-lists/ibd-50/","symbol",1). I think
> this might be a preview of the IBD 50 that excel is pulling from IBD
> without being signed in. In the past I have tried to access IBD through
> excel and was able to create the security cookie and used the ibd Template
> a few times but that was a couple years ago. Recently, I haven't been able
> to get create the security certificate due to the dreaded script error loop
> and having to use the task manager to exit excel. I have researched this
> topic a few times in the past few weeks but haven't been able to get excel
> and IBD to work together.
>
> Basically, I want to automate and expedite my ibd experience, which
> entails getting the stocks lists and the composite ranking metric for 1300
> stocks into excel. Any help on this subject would be greatly appreciated.
> And thanks again Randy for making this amazing tool I use all the time.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar