Jumat, 21 Juli 2017

[smf_addin] Digest Number 4098

8 Messages

Digest #4098

Messages

Fri Jul 21, 2017 1:43 am (PDT) . Posted by:

patrickvb

Other source of historical data: Wall Street Journal: last 5 year and  5 quarter 
http://quotes.wsj.com/MMM/financials/annual/income-statement

De : Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
À : smf_addin@yahoogroups.com
Objet : Re: [smf_addin] Historical Data
Date : 19/07/2017 03:15:57 CEST

 

Data can be retrieved from a number of sources. For example, financials:

http://www.advfn.com/stock-market/NYSE/MMM/financials?btn=annual_reports&mode=company_data

http://financials.morningstar.com/income-statement/is.html?t=MMM®ion=USA&culture=en_US

https://finance.yahoo.com/quote/MMM/financials?p=MMM

https://www.gurufocus.com/financials/MMM

https://www.barchart.com/stocks/quotes/MMM/income-statement/annual

For dividends and earnings:

https://www.zacks.com/stock/research/MMM/earnings-announcements#earnings_announcements_dividends

https://www.gurufocus.com/dividend/MMM

https://www.barchart.com/stocks/quotes/MMM/price-history/corporate-actions

http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=MMM®ion=usa&culture=en-US

How many periods of data for Morningstar and GuruFocus will depend on if you are a member or not.

Easiest is probably to grab one or more of the CSV files from Morningstar:

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

On Tue, Jul 18, 2017 at 4:48 PM, jefferychristman@
​...​
 wrote:

I grazed the read me, but didn't see anything that looked like this API could retrieve Historical Company Financial Data?  ie.  EPS, Dividends, Dividend date etc.  (for historical searches).  

I've found dozens of websites that have the current Corp Financial data for free, but I need historical.  

Fri Jul 21, 2017 8:57 am (PDT) . Posted by:

"Joe" jtassielli2003

Hi Randy
How can I extract Morningstar 10 yr eps history.
I used as a base for 10 yr stock price.  It's an exported spreadsheet with 10 yr price history.
http://performance. morningstar.com/Performance/ stock/exportStockPrice.action? pd=10y&freq=a&t=PM

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 26, 2017 4:27 PM
Subject: Re: [smf_addin] Extract a cell from web based excel file, morning star #28540

  Try:

=smfConvertData(smfWord(RCHGetWebData("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM","12/30/2016,",100),5,","))

Or, if you know where it will be on the returned file:

=INDEX(smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM",,4,5),4,5)

On Fri, May 26, 2017 at 1:01 PM, jtassielli2003@​...wrote:

I just wish to extract a single cell, E4: 91.49.
I used
http://performance. morningstar.com/Performance/ stock/exportStockPrice.action? pd=10y&freq=a&t=PM
thanks

| Date | Open | High | Low | Close | Volume |
| 5/25/2017 | 91.49 | 119.78 | 89.97 | 119.48 | 4,226,889 |
| 12/30/2016 | 87.91 | 104.2 | 84.46 | 91.49 | 4,470,395 |

#yiv8855019619 #yiv8855019619 -- #yiv8855019619ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8855019619 #yiv8855019619ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8855019619 #yiv8855019619ygrp-mkp #yiv8855019619hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8855019619 #yiv8855019619ygrp-mkp #yiv8855019619ads {margin-bottom:10px;}#yiv8855019619 #yiv8855019619ygrp-mkp .yiv8855019619ad {padding:0 0;}#yiv8855019619 #yiv8855019619ygrp-mkp .yiv8855019619ad p {margin:0;}#yiv8855019619 #yiv8855019619ygrp-mkp .yiv8855019619ad a {color:#0000ff;text-decoration:none;}#yiv8855019619 #yiv8855019619ygrp-sponsor #yiv8855019619ygrp-lc {font-family:Arial;}#yiv8855019619 #yiv8855019619ygrp-sponsor #yiv8855019619ygrp-lc #yiv8855019619hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8855019619 #yiv8855019619ygrp-sponsor #yiv8855019619ygrp-lc .yiv8855019619ad {margin-bottom:10px;padding:0 0;}#yiv8855019619 #yiv8855019619actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8855019619 #yiv8855019619activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8855019619 #yiv8855019619activity span {font-weight:700;}#yiv8855019619 #yiv8855019619activity span:first-child {text-transform:uppercase;}#yiv8855019619 #yiv8855019619activity span a {color:#5085b6;text-decoration:none;}#yiv8855019619 #yiv8855019619activity span span {color:#ff7900;}#yiv8855019619 #yiv8855019619activity span .yiv8855019619underline {text-decoration:underline;}#yiv8855019619 .yiv8855019619attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8855019619 .yiv8855019619attach div a {text-decoration:none;}#yiv8855019619 .yiv8855019619attach img {border:none;padding-right:5px;}#yiv8855019619 .yiv8855019619attach label {display:block;margin-bottom:5px;}#yiv8855019619 .yiv8855019619attach label a {text-decoration:none;}#yiv8855019619 blockquote {margin:0 0 0 4px;}#yiv8855019619 .yiv8855019619bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8855019619 .yiv8855019619bold a {text-decoration:none;}#yiv8855019619 dd.yiv8855019619last p a {font-family:Verdana;font-weight:700;}#yiv8855019619 dd.yiv8855019619last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8855019619 dd.yiv8855019619last p span.yiv8855019619yshortcuts {margin-right:0;}#yiv8855019619 div.yiv8855019619attach-table div div a {text-decoration:none;}#yiv8855019619 div.yiv8855019619attach-table {width:400px;}#yiv8855019619 div.yiv8855019619file-title a, #yiv8855019619 div.yiv8855019619file-title a:active, #yiv8855019619 div.yiv8855019619file-title a:hover, #yiv8855019619 div.yiv8855019619file-title a:visited {text-decoration:none;}#yiv8855019619 div.yiv8855019619photo-title a, #yiv8855019619 div.yiv8855019619photo-title a:active, #yiv8855019619 div.yiv8855019619photo-title a:hover, #yiv8855019619 div.yiv8855019619photo-title a:visited {text-decoration:none;}#yiv8855019619 div#yiv8855019619ygrp-mlmsg #yiv8855019619ygrp-msg p a span.yiv8855019619yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8855019619 .yiv8855019619green {color:#628c2a;}#yiv8855019619 .yiv8855019619MsoNormal {margin:0 0 0 0;}#yiv8855019619 o {font-size:0;}#yiv8855019619 #yiv8855019619photos div {float:left;width:72px;}#yiv8855019619 #yiv8855019619photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8855019619 #yiv8855019619photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8855019619 #yiv8855019619reco-category {font-size:77%;}#yiv8855019619 #yiv8855019619reco-desc {font-size:77%;}#yiv8855019619 .yiv8855019619replbq {margin:4px;}#yiv8855019619 #yiv8855019619ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8855019619 #yiv8855019619ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8855019619 #yiv8855019619ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8855019619 #yiv8855019619ygrp-mlmsg select, #yiv8855019619 input, #yiv8855019619 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8855019619 #yiv8855019619ygrp-mlmsg pre, #yiv8855019619 code {font:115% monospace;}#yiv8855019619 #yiv8855019619ygrp-mlmsg * {line-height:1.22em;}#yiv8855019619 #yiv8855019619ygrp-mlmsg #yiv8855019619logo {padding-bottom:10px;}#yiv8855019619 #yiv8855019619ygrp-msg p a {font-family:Verdana;}#yiv8855019619 #yiv8855019619ygrp-msg p#yiv8855019619attach-count span {color:#1E66AE;font-weight:700;}#yiv8855019619 #yiv8855019619ygrp-reco #yiv8855019619reco-head {color:#ff7900;font-weight:700;}#yiv8855019619 #yiv8855019619ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8855019619 #yiv8855019619ygrp-sponsor #yiv8855019619ov li a {font-size:130%;text-decoration:none;}#yiv8855019619 #yiv8855019619ygrp-sponsor #yiv8855019619ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8855019619 #yiv8855019619ygrp-sponsor #yiv8855019619ov ul {margin:0;padding:0 0 0 8px;}#yiv8855019619 #yiv8855019619ygrp-text {font-family:Georgia;}#yiv8855019619 #yiv8855019619ygrp-text p {margin:0 0 1em 0;}#yiv8855019619 #yiv8855019619ygrp-text tt {font-size:120%;}#yiv8855019619 #yiv8855019619ygrp-vital ul li:last-child {border-right:none !important;}#yiv8855019619

Fri Jul 21, 2017 11:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:

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

On Fri, Jul 21, 2017 at 8:33 AM, Joe jtassielli2003@
​...
wrote:

>
> How can I extract Morningstar 10 yr eps history.
>
>
>

Fri Jul 21, 2017 9:04 am (PDT) . Posted by:

rebeccaestevens@gmail.com

I pull historical data for our peer companies to run an analysis every week. I have been using this function for years, but all the data looks different with the updated version. I used to take the close price and adjust for splits on my own, but now it looks like it may be doing that for me? I am trying to capture the close price adjusted for splits, but not dividends. The data that is pulling has the following columns:


Date Open High Low Close Volume Unadj


It looks like maybe I should be using the Unadj, but I wanted to double check that it is adjusting for splits and not dividends. Also is it adjusting for spin offs as well?


Any help would be appreciated!


Thank you,
Rebecca

Fri Jul 21, 2017 9:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

O/H/L/C are all now adjusted for dividends. The "Unadj" should be adjusted
for everything except for dividends.

On Fri, Jul 21, 2017 at 6:29 AM, rebeccaestevens@
​...
wrote:

> I pull historical data for our peer companies to run an analysis every
> week. I have been using this function for years, but all the data looks
> different with the updated version. I used to take the close price and
> adjust for splits on my own, but now it looks like it may be doing that for
> me? I am trying to capture the close price adjusted for splits, but not
> dividends. The data that is pulling has the following columns:
>
> Date Open High Low Close Volume Unadj
>
> It looks like maybe I should be using the Unadj, but I wanted to double
> check that it is adjusting for splits and not dividends. Also is it
> adjusting for spin offs as well?
>
> Any help would be appreciated!
>
>
>

Fri Jul 21, 2017 11:32 am (PDT) . Posted by:

gareneau

Randy,


As I recall, there is still an issue correctly retrieving weekly and monthly prices. Is that issue now resolved?


Thanks,


Gary

Fri Jul 21, 2017 11:49 am (PDT) . Posted by:

"Rebecca Stevens" rebeccaestevens@gmail.com

Thank you, thats perfect!

thanks,
Becca

On Fri, Jul 21, 2017 at 1:32 PM, gareneau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy,
>
> As I recall, there is still an issue correctly retrieving weekly and
> monthly prices. Is that issue now resolved?
>
> Thanks,
>
> Gary
>
>
>

--
Rebecca E. Stevens | Compensation Analyst | Human Resources |
Devon Energy Corporation | 333 West Sheridan | Oklahoma City, OK 73102

Fri Jul 21, 2017 2:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo is still adjusting the end-of-period close for a dividend that
occurred DURING the period.

I documented an example yesterday on another forum:

http://boards.fool.com/i-just-checked-monthly-historical-prices-for-ibm-32784376.aspx

On Fri, Jul 21, 2017 at 11:32 AM, gareneau@
​...
wrote:

>
>
> As I recall, there is still an issue correctly retrieving weekly and
> monthly prices. Is that issue now resolved?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)