Minggu, 09 Juli 2017

[smf_addin] Digest Number 4086

4 Messages

Digest #4086

Messages

Sat Jul 8, 2017 10:38 pm (PDT) . Posted by:

rharmelink

A new source of historical quotes (and more) was mentioned on an AmiBroker forum. The documentation of its APIs is here:


https://www.alphavantage.co/documentation/ https://www.alphavantage.co/documentation/



To use the APIs, you will need to request your free API key by giving your name and an email address. They have examples on the documentation page that actually work, using "demo" as the API key. That API key only works with MSFT as the ticker symbol.


As an example, this:


=smfGetCSVFile("https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv")



...returns something that looks like this:


timestamp open high low close adjusted_close volume dividend_amount split_coefficient 2017-07-07 $68.70 $69.84 $68.70 $69.46 $69.46 15897154 0 1 2017-07-06 $68.27 $68.78 $68.12 $68.57 $68.57 20909161 0 1 2017-07-05 $68.26 $69.44 $68.22 $69.08 $69.08 21176272 0 1 2017-07-03 $69.33 $69.60 $68.02 $68.17 $68.17 16164331 0 1

Sat Jul 8, 2017 10:50 pm (PDT) . Posted by:

rharmelink

Saw a discussion of stooq.com http://stooq.com/ (a foreign web site) on another board and checked it out. Not sure of the accuracy of their data (not sure who to compare to these days). Data appears to be both split and dividend adjusted. Historical quotes are easy to get, as a CSV file:


https://stooq.com/q/d/l/?s= mmm.us&d1=20160102&d2= 20170703&i=d https://stooq.com/q/d/l/?s=mmm.us&d1=20160102&d2=20170703&i=d


-- &s= is for the ticker symbol, and US ticker symbols must have the ".us" suffix.
-- &d1= is for the starting date; &d1 and &d2 must either both be used or omitted.
-- &d2= is for the ending date; &d1 and &d2 must either both be used or omitted.
-- &i= is for the time period, and can be d/w/m/q/y.


They also have a current quotes CSV similar to Yahoo's:


https://stooq.com/q/l/?s=mmm. us+ibm.us&f=sd2t2ohlcm2vr&e= csv https://stooq.com/q/l/?s=mmm.us+ibm.us&f=sd2t2ohlcm2vr&e=csv


-- &s= is for the ticker symbol, and US ticker symbols must have the ".us" suffix. Multiple ticker symbols can be used with a "+" in between them.
-- &f= is for the data fields, with meanings of:
>> a = Ask
>> b = Bid
>> c = Close
>> d1 = Date as yyyymmdd
>> d2 = Date as m/d/yyyy
>> d4 = Date as d-mmm-yy
>> h = High
>> l = Low
>> m1 = $ Change
>> m2 = % Change
>> n = Name
>> o = Open
>> p = Previous Close
>> r = Rotation???
>> s = Symbol
>> t1 = Time as hhmmss (24 hour)
>> t2 = Time as hh:mm:ss (24 hour)
>> t3 = Time as hh:mm (24 hour)
>> t4 = Time as hh:mmPM
>> v = Volume


So, this:


=smfGetCSVFile("https://stooq.com/q/d/l/?s=mmm.us&d1=20160102&d2=20170703&i=d")



...returns something like:


Date Open High Low Close Volume 2016-01-04 $142.42 $142.67 $139.85 $141.22 3407129 2016-01-05 $141.22 $141.87 $140.05 $141.83 2792949 2016-01-06 $140.03 $140.19 $137.96 $138.98 3115959 2016-01-07 $137.08 $137.68 $135.26 $135.59 3692154 2016-01-08 $135.98 $137.06 $134.86 $135.12 2769503 2016-01-11 $135.59 $136.05 $134.09 $135.09 2885578 2016-01-12 $135.98 $136.72 $133.82 $135.48 2457327


...and this:


=smfGetCSVFile("https://stooq.com/q/l/?s=mmm.us+ibm.us&f=sd2t2ohlcm2vr&e=csv")


...returns something like:


MMM.US 2017-07-07 22:00:00 $208.50 $210.15 $208.05 $209.59 0.75% 1477830 259895497 IBM.US 2017-07-07 22:00:00 $152.62 $153.49 $152.14 $152.94 0.38% 2383896 304347109


Sun Jul 9, 2017 7:09 am (PDT) . Posted by:

dcharlotte99

Randy - could I direct-message you here or contact in another way? I'm an active user of the SMF Add-in and have a few comments/questions. (this is completely unrelated to this post or STOOQ).

I run a website and if I post my issue here publicly it could be seen as marketing, I want to respect the use of this board. This is nothing groundbreaking just a comment/question for you to consider. You could contact me at dcharlotte99 [ at ] gmail.com also.


David

Sat Jul 8, 2017 11:01 pm (PDT) . Posted by:

"Paul D Pochan" paul_d_pochan

Randy,I purchased a new laptop and add-in appears to be working correctly now and pulling the quotes. (My old one was a cheapo and I got what I paid for.....)Paul

Sent from Yahoo Mail on Android

On Fri, Jul 7, 2017 at 3:55 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

Can't help without more details. I need at least an example of the formula causing an error. Best to shut down EXCEL, create a new workbook, and try it there first. If it still gets an error, then send it along so I can try an figure out what happened to it.
Also, add-in version information would be helpful:
=RCHGetElementNumber("Version&quot;)
On Fri, Jul 7, 2017 at 11:38 AM, Paul D Pochan paul_d_pochan@​... wrote:

My issue. I have 2 options on my spreadsheet. The option quote updates for one and the other gives ERROR.

#yiv4872043854 #yiv4872043854 -- #yiv4872043854ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4872043854 #yiv4872043854ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4872043854 #yiv4872043854ygrp-mkp #yiv4872043854hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4872043854 #yiv4872043854ygrp-mkp #yiv4872043854ads {margin-bottom:10px;}#yiv4872043854 #yiv4872043854ygrp-mkp .yiv4872043854ad {padding:0 0;}#yiv4872043854 #yiv4872043854ygrp-mkp .yiv4872043854ad p {margin:0;}#yiv4872043854 #yiv4872043854ygrp-mkp .yiv4872043854ad a {color:#0000ff;text-decoration:none;}#yiv4872043854 #yiv4872043854ygrp-sponsor #yiv4872043854ygrp-lc {font-family:Arial;}#yiv4872043854 #yiv4872043854ygrp-sponsor #yiv4872043854ygrp-lc #yiv4872043854hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4872043854 #yiv4872043854ygrp-sponsor #yiv4872043854ygrp-lc .yiv4872043854ad {margin-bottom:10px;padding:0 0;}#yiv4872043854 #yiv4872043854actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4872043854 #yiv4872043854activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4872043854 #yiv4872043854activity span {font-weight:700;}#yiv4872043854 #yiv4872043854activity span:first-child {text-transform:uppercase;}#yiv4872043854 #yiv4872043854activity span a {color:#5085b6;text-decoration:none;}#yiv4872043854 #yiv4872043854activity span span {color:#ff7900;}#yiv4872043854 #yiv4872043854activity span .yiv4872043854underline {text-decoration:underline;}#yiv4872043854 .yiv4872043854attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4872043854 .yiv4872043854attach div a {text-decoration:none;}#yiv4872043854 .yiv4872043854attach img {border:none;padding-right:5px;}#yiv4872043854 .yiv4872043854attach label {display:block;margin-bottom:5px;}#yiv4872043854 .yiv4872043854attach label a {text-decoration:none;}#yiv4872043854 blockquote {margin:0 0 0 4px;}#yiv4872043854 .yiv4872043854bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4872043854 .yiv4872043854bold a {text-decoration:none;}#yiv4872043854 dd.yiv4872043854last p a {font-family:Verdana;font-weight:700;}#yiv4872043854 dd.yiv4872043854last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4872043854 dd.yiv4872043854last p span.yiv4872043854yshortcuts {margin-right:0;}#yiv4872043854 div.yiv4872043854attach-table div div a {text-decoration:none;}#yiv4872043854 div.yiv4872043854attach-table {width:400px;}#yiv4872043854 div.yiv4872043854file-title a, #yiv4872043854 div.yiv4872043854file-title a:active, #yiv4872043854 div.yiv4872043854file-title a:hover, #yiv4872043854 div.yiv4872043854file-title a:visited {text-decoration:none;}#yiv4872043854 div.yiv4872043854photo-title a, #yiv4872043854 div.yiv4872043854photo-title a:active, #yiv4872043854 div.yiv4872043854photo-title a:hover, #yiv4872043854 div.yiv4872043854photo-title a:visited {text-decoration:none;}#yiv4872043854 div#yiv4872043854ygrp-mlmsg #yiv4872043854ygrp-msg p a span.yiv4872043854yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4872043854 .yiv4872043854green {color:#628c2a;}#yiv4872043854 .yiv4872043854MsoNormal {margin:0 0 0 0;}#yiv4872043854 o {font-size:0;}#yiv4872043854 #yiv4872043854photos div {float:left;width:72px;}#yiv4872043854 #yiv4872043854photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4872043854 #yiv4872043854photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4872043854 #yiv4872043854reco-category {font-size:77%;}#yiv4872043854 #yiv4872043854reco-desc {font-size:77%;}#yiv4872043854 .yiv4872043854replbq {margin:4px;}#yiv4872043854 #yiv4872043854ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4872043854 #yiv4872043854ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4872043854 #yiv4872043854ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4872043854 #yiv4872043854ygrp-mlmsg select, #yiv4872043854 input, #yiv4872043854 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4872043854 #yiv4872043854ygrp-mlmsg pre, #yiv4872043854 code {font:115% monospace;}#yiv4872043854 #yiv4872043854ygrp-mlmsg * {line-height:1.22em;}#yiv4872043854 #yiv4872043854ygrp-mlmsg #yiv4872043854logo {padding-bottom:10px;}#yiv4872043854 #yiv4872043854ygrp-msg p a {font-family:Verdana;}#yiv4872043854 #yiv4872043854ygrp-msg p#yiv4872043854attach-count span {color:#1E66AE;font-weight:700;}#yiv4872043854 #yiv4872043854ygrp-reco #yiv4872043854reco-head {color:#ff7900;font-weight:700;}#yiv4872043854 #yiv4872043854ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4872043854 #yiv4872043854ygrp-sponsor #yiv4872043854ov li a {font-size:130%;text-decoration:none;}#yiv4872043854 #yiv4872043854ygrp-sponsor #yiv4872043854ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4872043854 #yiv4872043854ygrp-sponsor #yiv4872043854ov ul {margin:0;padding:0 0 0 8px;}#yiv4872043854 #yiv4872043854ygrp-text {font-family:Georgia;}#yiv4872043854 #yiv4872043854ygrp-text p {margin:0 0 1em 0;}#yiv4872043854 #yiv4872043854ygrp-text tt {font-size:120%;}#yiv4872043854 #yiv4872043854ygrp-vital ul li:last-child {border-right:none !important;}#yiv4872043854
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.14

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)