Rabu, 31 Mei 2017

[ExcelVBA] File - GroupInfo.txt

 


This automatic email is posted to this group each month for the benefit of new members and as a reminder to current members.

NOTICE VERSION: January, 2012

* This group is monitored by several moderators. In an effort to help weed out spammers, most posts are manually verified before they are released

to the group. Therefore, if you are new to the group or do not regularly participate, it may take a bit longer for your post to show up in the

group. This is normal. We do try to keep watch and release valid posts ASAP. Once you become a recognized/active member of the group, we try to

make sure your membership is validated so that your posts can slide through without monitoring delays.

* Although we do try to keep posts on topic, we also like to be a friendly, community group here, so the occasional chatter between members is not

a problem. If you have something important to post that is "off topic"...please start the subject with OT-, as in "Off Topic" so that it can be

filtered out by those not wishing to be bothered by off topic posts.

* PLAY NICE! Verbal bashing of any kind will NOT be tolerated! If you have a problem with someone in this group...take it outside. If a complaint

is reported about your behavior, you'll be banned from the group...NO questions asked!

* This group has a web site. To locate the URL to the group's web page, see the bottom of any post where additional information is listed. Within

the group's web site, you'll find additional information. Depending on the activity/participation of the group, you may find additional help files

and/or tutorials, as well as other helpful links.

* Sadly, due to spammers, only moderators can post files and links within our group's site. However, if you have something you'd like to

contribute, contact one of the moderators...whose names are listed on the home page of our group's web page.

* Additionally, you cannot attach files to posts...again due to spammers. But if you have a file that you'd like others to see in an attempt to

help you solve a problem, contact a moderator to post the file for you. If you have any trouble contacting a moderator, feel free to request help

by posting to the group with the subject NEED MODERATOR HELP. (By using that EXACT subject, moderators can set an alert to more quickly notice your

post.)

* To get the best help, fast, use a good subject line! Don't just post a subject saying HELP! Give a little detail about the type of help you need.

Also be sure to include some details, such as the content of any error messages, as well as the software version you are using. For more specific

info on how to get the most from your posts, see this link: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=507#info

* With the help of several wonderful moderators and terrific group participants who regularly share their knowledge, I run a handful of free

support groups. To find our other groups, as well as other groups I recommend for free support, see this link:

http://www.mousetrax.com/resources.html

* And finally, know that you can find many free tutorials linked from my TechPage here: http://www.mousetrax.com/techpage.html and also directly

through TechTrax, my very popular, free ezine (online magazine) here: http://www.techtrax.us

Dian D. Chapman (Group Owner)
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
Tech Editor for Word & Office 2007 Bibles
https://mvp.support.microsoft.com/profile/Dian.Chapman

Dian's Soldier/K9 Site
http://www.mousetrax.com/dian/angels.html

Free Computer Tutorials: http://www.techtrax.us
Dian's Free User Support Groups: http://www.mousetrax.com/resources.html
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (127)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___
READ MORE....

[smf_addin] Digest Number 4045

13 Messages

Digest #4045
4.1
Re: Update on Yahoo Historical Quotes by "Michael Thomas" thomas91112
4.2
Re: Update on Yahoo Historical Quotes by "Randy Harmelink" rharmelink
4.3
Re: Update on Yahoo Historical Quotes by "Michael Thomas" thomas91112
4.4
Re: Update on Yahoo Historical Quotes by "Randy Harmelink" rharmelink
6a
Re: Oil Prices? by spcullinane@outlook.com
6b
Re: Oil Prices? by tonyestep
7a
Re: Report Yahoo null data by spcullinane@outlook.com

Messages

Wed May 31, 2017 8:50 am (PDT) . Posted by:

richqw

I have checked some stock splits and found that the data reported by Yahoo and Google are highly inconsistent. Sometimes right and sometimes wrong.


For example, I checked SRTY and GEO.


SRTY had a 1 for 4 (reverse) split on 1/12/17.
Google's prices are the correct split adjusted prices! This was a surprise, as this group had reported that Google did not adjust for splits.
Yahoo's adjusted and unadjusted prices are completely wrong. (This was expected.) The adjusted price was the actual price and the unadjusted price had a double adjustment. Unless one assumed that Yahoo makes this mistake consistently, it would be hard to capture the correct prices. Unfortunately, they are not consistent.


GEO had a 3 for 2 split on 4/25/17
Google's prices are the split adjusted prices as if it were a 9 for 4 split (i.e. double adusted). In other words, completely wrong. However, it is surprising that they are actually attempting to make an adjustment
Yahoo's close and adjusted close prices are correct! (another surprise). The Open, Low and High prices are split adjusted.


If we use Yahoo data, we need to determine if it is correct or incorrect. If incorrect, hope they are making a consistent error.
If we use Google data, maybe we can get them to use the correct adjustment. It's encouraging that they are attempting to make an adjustment. I will attempt to contact Google about this.


Another possibility is that reverse splits are being treated differently than regular splits.

Wed May 31, 2017 9:03 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Randy -  the formulas you gave me using smfGetYahooHistory work beautifully.
It seems that the only difference in our environments is that I am using MS Windows 8.1 and EXCEL 2013. I believe you have Office 360 and Windows 10. Do you think this could be the reason RCHGetYahooHistory formulas are not working in my computer?  Regards, Jose L. Jacob

On Tuesday, May 30, 2017 9:28 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  The one to get all three at once would be:

=TRANSPOSE(INDEX(smfGetYahooHistory("MMM",,,"v",,0,,3,2),,2))

...or, as needed for individual row/column extraction:

=INDEX(smfGetYahooHistory("MMM",,,"v",,0,,3,2),3,2)
On Tue, May 30, 2017 at 5:57 PM, Jose Jacob pepecan47@​...wrote:

Randy, what would the formulas be using smgGetYahooHistory? I would like to try them. 

#yiv8791693056 #yiv8791693056 -- #yiv8791693056ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8791693056 #yiv8791693056ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8791693056 #yiv8791693056ygrp-mkp #yiv8791693056hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8791693056 #yiv8791693056ygrp-mkp #yiv8791693056ads {margin-bottom:10px;}#yiv8791693056 #yiv8791693056ygrp-mkp .yiv8791693056ad {padding:0 0;}#yiv8791693056 #yiv8791693056ygrp-mkp .yiv8791693056ad p {margin:0;}#yiv8791693056 #yiv8791693056ygrp-mkp .yiv8791693056ad a {color:#0000ff;text-decoration:none;}#yiv8791693056 #yiv8791693056ygrp-sponsor #yiv8791693056ygrp-lc {font-family:Arial;}#yiv8791693056 #yiv8791693056ygrp-sponsor #yiv8791693056ygrp-lc #yiv8791693056hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8791693056 #yiv8791693056ygrp-sponsor #yiv8791693056ygrp-lc .yiv8791693056ad {margin-bottom:10px;padding:0 0;}#yiv8791693056 #yiv8791693056actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8791693056 #yiv8791693056activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8791693056 #yiv8791693056activity span {font-weight:700;}#yiv8791693056 #yiv8791693056activity span:first-child {text-transform:uppercase;}#yiv8791693056 #yiv8791693056activity span a {color:#5085b6;text-decoration:none;}#yiv8791693056 #yiv8791693056activity span span {color:#ff7900;}#yiv8791693056 #yiv8791693056activity span .yiv8791693056underline {text-decoration:underline;}#yiv8791693056 .yiv8791693056attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8791693056 .yiv8791693056attach div a {text-decoration:none;}#yiv8791693056 .yiv8791693056attach img {border:none;padding-right:5px;}#yiv8791693056 .yiv8791693056attach label {display:block;margin-bottom:5px;}#yiv8791693056 .yiv8791693056attach label a {text-decoration:none;}#yiv8791693056 blockquote {margin:0 0 0 4px;}#yiv8791693056 .yiv8791693056bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8791693056 .yiv8791693056bold a {text-decoration:none;}#yiv8791693056 dd.yiv8791693056last p a {font-family:Verdana;font-weight:700;}#yiv8791693056 dd.yiv8791693056last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8791693056 dd.yiv8791693056last p span.yiv8791693056yshortcuts {margin-right:0;}#yiv8791693056 div.yiv8791693056attach-table div div a {text-decoration:none;}#yiv8791693056 div.yiv8791693056attach-table {width:400px;}#yiv8791693056 div.yiv8791693056file-title a, #yiv8791693056 div.yiv8791693056file-title a:active, #yiv8791693056 div.yiv8791693056file-title a:hover, #yiv8791693056 div.yiv8791693056file-title a:visited {text-decoration:none;}#yiv8791693056 div.yiv8791693056photo-title a, #yiv8791693056 div.yiv8791693056photo-title a:active, #yiv8791693056 div.yiv8791693056photo-title a:hover, #yiv8791693056 div.yiv8791693056photo-title a:visited {text-decoration:none;}#yiv8791693056 div#yiv8791693056ygrp-mlmsg #yiv8791693056ygrp-msg p a span.yiv8791693056yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8791693056 .yiv8791693056green {color:#628c2a;}#yiv8791693056 .yiv8791693056MsoNormal {margin:0 0 0 0;}#yiv8791693056 o {font-size:0;}#yiv8791693056 #yiv8791693056photos div {float:left;width:72px;}#yiv8791693056 #yiv8791693056photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8791693056 #yiv8791693056photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8791693056 #yiv8791693056reco-category {font-size:77%;}#yiv8791693056 #yiv8791693056reco-desc {font-size:77%;}#yiv8791693056 .yiv8791693056replbq {margin:4px;}#yiv8791693056 #yiv8791693056ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8791693056 #yiv8791693056ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8791693056 #yiv8791693056ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8791693056 #yiv8791693056ygrp-mlmsg select, #yiv8791693056 input, #yiv8791693056 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8791693056 #yiv8791693056ygrp-mlmsg pre, #yiv8791693056 code {font:115% monospace;}#yiv8791693056 #yiv8791693056ygrp-mlmsg * {line-height:1.22em;}#yiv8791693056 #yiv8791693056ygrp-mlmsg #yiv8791693056logo {padding-bottom:10px;}#yiv8791693056 #yiv8791693056ygrp-msg p a {font-family:Verdana;}#yiv8791693056 #yiv8791693056ygrp-msg p#yiv8791693056attach-count span {color:#1E66AE;font-weight:700;}#yiv8791693056 #yiv8791693056ygrp-reco #yiv8791693056reco-head {color:#ff7900;font-weight:700;}#yiv8791693056 #yiv8791693056ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8791693056 #yiv8791693056ygrp-sponsor #yiv8791693056ov li a {font-size:130%;text-decoration:none;}#yiv8791693056 #yiv8791693056ygrp-sponsor #yiv8791693056ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8791693056 #yiv8791693056ygrp-sponsor #yiv8791693056ov ul {margin:0;padding:0 0 0 8px;}#yiv8791693056 #yiv8791693056ygrp-text {font-family:Georgia;}#yiv8791693056 #yiv8791693056ygrp-text p {margin:0 0 1em 0;}#yiv8791693056 #yiv8791693056ygrp-text tt {font-size:120%;}#yiv8791693056 #yiv8791693056ygrp-vital ul li:last-child {border-right:none !important;}#yiv8791693056

Wed May 31, 2017 10:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would hope not...but I have no clue why yours isn't working.

On Wed, May 31, 2017 at 9:03 AM, Jose Jacob pepecan47@
​...wrote:

>
> Randy - the formulas you gave me using smfGetYahooHistory work
> beautifully.
>
> It seems that the only difference in our environments is that I am using
> MS Windows 8.1 and EXCEL 2013. I believe you have Office 360 and Windows
> 10. Do you think this could be the reason RCHGetYahooHistory formulas are
> not working in my computer?
>
>
>

Wed May 31, 2017 10:11 am (PDT) . Posted by:

garyhartling

Yes. The add-in works with 32-bit Excel under 64-bit Windows. Very few people need or use 64-bit Excel. It's very questionable whether 64-bit Excel will work with the 32-bit add-in.

--Gary H.

Wed May 31, 2017 10:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Wed, May 31, 2017 at 3:42 AM, marksimms@verizon.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Would it be possible for you to provide the BAS files for each of the
> Modules and just zip them up ? I pretty sure I can get this to work if I at
> least had the source code.
>
​Not a trivial task. There are a lot of modules.​

> Also, where are those XLL's you were referring to ? Are they one of the
> references ?
>

​All are reference libraries.​

Wed May 31, 2017 1:56 pm (PDT) . Posted by:

"Michael Thomas" thomas91112

Wish to pass along an observation when using smfGetYahooHistory.  When requesting "adjusted close price" using "c" identifier within "cohl", the open, high and low values appear to also be adjusted....which is fine.  However, when I change to "unadjusted close price" using "u", the values for open, high and low remain unchanged.  Are there different identifiers for unadjusted open, high and low prices?

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, May 18, 2017 11:08 PM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes

  Oops...for now, the parameters:

pStartDate = Start date. It can be a string (e.g. "5/18/2017") or an EXCEL serial date. Defaults to a year ago.

pEndDate = Ending date. Also can be a string or EXCEL serial date. Defaults to tomorrow. I've even used "12/31/2020".

pPeriod = Time period of data == "d" (daily), "w" (weekly, on Fridays), :"m" (monthly, at start of month), "q" (quarterly, at start of quarter), "a" (annual, at start of year), "v" = (dividends, with the ex-dividend dates), "s" (splits, with the ex-dividend dates)/. Defaults to daily. Only a single character can be sent.

pItems -- Data items desired. Defaults to "dohlcvufgxs", or Date, adjusted Open, adjusted High, adjusted Low. adjusted Close, Volume, unadjusted close, dividend adjust Factor, (g=) split adjustment factor, eX-dividend amount, Split ratio. "t" for Ticker is also valid. When pPeriod is "v" or "s", this string isn't used, EXCEPT to see if a ticker was requested -- in that case, the three fields returned -- Ticker, Date, dividend/split amount. Otherwise, you can specify as many of these as you want, in any order. For example, "dcut" would return Date, adjusted Close, Unadjusted Close, and Ticker.

pNames -- Whether a header row should be used, with field names inserted. Defaults to a value of 1, but can be set to 0.

pResort -- Defaults to 0, but setting to 1 will resort the data so oldest data is at the top.

pRows, pCols -- generally not used. They can set the size of the data range to be returned.They default to the size of the range the format was array-entered over. These are used mainly for other VBA routines  that call this function, since a worksheet range  wouldn't  apply. I may default them later.

Example:

=smfGetYahooHistory("MMM")
=smfGetYahooHistory("MMM","1/1/2000",,"v")
=smfGetYahooHistory("MMM","5/12/2017","5/12/2017","d","u",0)

The first gets the whole year's worth of everything except Ticker output. The second gets dividend payments since 1/1/2000. The third gets a single value -- the unadjusted close on 5/12/2017.

Something like this:

=AVERAGE(smfGetYahooHistory("MMM",,,,"c",0,,50,1))

...would get you the 50-day average of the adjusted close.

On Thu, May 18, 2017 at 10:13 PM, V A viewasia@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Could you please share information on the flags (data items) being passed for the data pull? I'm trying to understand if the closing price is the adjusted closing price.

Documentation Link > RCHGetYahooHistory-Function. html doesn't address the new flags

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, May 18, 2017 8:19 PM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes

  I'm done looking at things until tomorrow. The last two problems I spent time investigating turned out to be Yahoo data problems:

1. The recent 1/10 split by RNN was adjusted by Yahoo as if it were a 10-for-1 split.
2. ^GSPC errors out on data past 6/29/16 because Yahoo has "null"  values for data items on that date.

For those of you chomping at the bit, I just uploaded these files:

http://ogres-crypt.com/SMF/ Works-In-Progress/RCH_Stock_ Market_Functions.xla
http://ogres-crypt.com/SMF/ Works-In-Progress/ smfGetYahooHistory-Example-By- Parameter.xls

I have also changed the smfPricesByDates() function to use the new smfGetYahooHistory(), so it should work as well. I'm not publishing these on the website pages because I expect there will need to be updates.
I've tried so many combinations of parameters today that I'm going bug-eyed. A few fresh sets of eyes might help. I'm sure others will try things I wouldn't even think of trying. That's the problem with testing your own code -- you're really just testing your own assumptions.

It might be easiest to exit EXCEL, rename the current XLA, and grab the new one. And start up EXCEL again. That way, it's easy to reverse by just exiting EXCEL and renaming the two files. It is noticeably slower, due to the size of the files, About a half-second to a second or so longer per request. But I'm also running slower here on the new desktop, with a newer version of EXCEL and Windows.

On Thu, May 18, 2017 at 6:16 PM, marksimms@verizon.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

Sounds great. ETA on the modifications ?

#yiv3366980226 #yiv3366980226 -- #yiv3366980226ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3366980226 #yiv3366980226ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3366980226 #yiv3366980226ygrp-mkp #yiv3366980226hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3366980226 #yiv3366980226ygrp-mkp #yiv3366980226ads {margin-bottom:10px;}#yiv3366980226 #yiv3366980226ygrp-mkp .yiv3366980226ad {padding:0 0;}#yiv3366980226 #yiv3366980226ygrp-mkp .yiv3366980226ad p {margin:0;}#yiv3366980226 #yiv3366980226ygrp-mkp .yiv3366980226ad a {color:#0000ff;text-decoration:none;}#yiv3366980226 #yiv3366980226ygrp-sponsor #yiv3366980226ygrp-lc {font-family:Arial;}#yiv3366980226 #yiv3366980226ygrp-sponsor #yiv3366980226ygrp-lc #yiv3366980226hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3366980226 #yiv3366980226ygrp-sponsor #yiv3366980226ygrp-lc .yiv3366980226ad {margin-bottom:10px;padding:0 0;}#yiv3366980226 #yiv3366980226actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3366980226 #yiv3366980226activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3366980226 #yiv3366980226activity span {font-weight:700;}#yiv3366980226 #yiv3366980226activity span:first-child {text-transform:uppercase;}#yiv3366980226 #yiv3366980226activity span a {color:#5085b6;text-decoration:none;}#yiv3366980226 #yiv3366980226activity span span {color:#ff7900;}#yiv3366980226 #yiv3366980226activity span .yiv3366980226underline {text-decoration:underline;}#yiv3366980226 .yiv3366980226attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3366980226 .yiv3366980226attach div a {text-decoration:none;}#yiv3366980226 .yiv3366980226attach img {border:none;padding-right:5px;}#yiv3366980226 .yiv3366980226attach label {display:block;margin-bottom:5px;}#yiv3366980226 .yiv3366980226attach label a {text-decoration:none;}#yiv3366980226 blockquote {margin:0 0 0 4px;}#yiv3366980226 .yiv3366980226bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3366980226 .yiv3366980226bold a {text-decoration:none;}#yiv3366980226 dd.yiv3366980226last p a {font-family:Verdana;font-weight:700;}#yiv3366980226 dd.yiv3366980226last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3366980226 dd.yiv3366980226last p span.yiv3366980226yshortcuts {margin-right:0;}#yiv3366980226 div.yiv3366980226attach-table div div a {text-decoration:none;}#yiv3366980226 div.yiv3366980226attach-table {width:400px;}#yiv3366980226 div.yiv3366980226file-title a, #yiv3366980226 div.yiv3366980226file-title a:active, #yiv3366980226 div.yiv3366980226file-title a:hover, #yiv3366980226 div.yiv3366980226file-title a:visited {text-decoration:none;}#yiv3366980226 div.yiv3366980226photo-title a, #yiv3366980226 div.yiv3366980226photo-title a:active, #yiv3366980226 div.yiv3366980226photo-title a:hover, #yiv3366980226 div.yiv3366980226photo-title a:visited {text-decoration:none;}#yiv3366980226 div#yiv3366980226ygrp-mlmsg #yiv3366980226ygrp-msg p a span.yiv3366980226yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3366980226 .yiv3366980226green {color:#628c2a;}#yiv3366980226 .yiv3366980226MsoNormal {margin:0 0 0 0;}#yiv3366980226 o {font-size:0;}#yiv3366980226 #yiv3366980226photos div {float:left;width:72px;}#yiv3366980226 #yiv3366980226photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3366980226 #yiv3366980226photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3366980226 #yiv3366980226reco-category {font-size:77%;}#yiv3366980226 #yiv3366980226reco-desc {font-size:77%;}#yiv3366980226 .yiv3366980226replbq {margin:4px;}#yiv3366980226 #yiv3366980226ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3366980226 #yiv3366980226ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3366980226 #yiv3366980226ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3366980226 #yiv3366980226ygrp-mlmsg select, #yiv3366980226 input, #yiv3366980226 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3366980226 #yiv3366980226ygrp-mlmsg pre, #yiv3366980226 code {font:115% monospace;}#yiv3366980226 #yiv3366980226ygrp-mlmsg * {line-height:1.22em;}#yiv3366980226 #yiv3366980226ygrp-mlmsg #yiv3366980226logo {padding-bottom:10px;}#yiv3366980226 #yiv3366980226ygrp-msg p a {font-family:Verdana;}#yiv3366980226 #yiv3366980226ygrp-msg p#yiv3366980226attach-count span {color:#1E66AE;font-weight:700;}#yiv3366980226 #yiv3366980226ygrp-reco #yiv3366980226reco-head {color:#ff7900;font-weight:700;}#yiv3366980226 #yiv3366980226ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3366980226 #yiv3366980226ygrp-sponsor #yiv3366980226ov li a {font-size:130%;text-decoration:none;}#yiv3366980226 #yiv3366980226ygrp-sponsor #yiv3366980226ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3366980226 #yiv3366980226ygrp-sponsor #yiv3366980226ov ul {margin:0;padding:0 0 0 8px;}#yiv3366980226 #yiv3366980226ygrp-text {font-family:Georgia;}#yiv3366980226 #yiv3366980226ygrp-text p {margin:0 0 1em 0;}#yiv3366980226 #yiv3366980226ygrp-text tt {font-size:120%;}#yiv3366980226 #yiv3366980226ygrp-vital ul li:last-child {border-right:none !important;}#yiv3366980226

Wed May 31, 2017 2:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, no. Adjusted is the new norm. The unadjusted closed is there for
reference.

If you really need O/H/L at unadjusted levels, you can always do the
calculation yourself.

Unadjusted history for time periods makes NO sense to me. If you want your
prices adjusted for splits, you should also want them adjusted for
dividends.

On Wed, May 31, 2017 at 1:56 PM, Michael Thomas thomas91112@
​...
wrote:

>
> Wish to pass along an observation when using smfGetYahooHistory. When
> requesting "adjusted close price" using "c" identifier within "cohl", the
> open, high and low values appear to also be adjusted....which is fine.
> However, when I change to "unadjusted close price" using "u", the values
> for open, high and low remain unchanged. Are there different identifiers
> for unadjusted open, high and low prices?
>

Wed May 31, 2017 4:59 pm (PDT) . Posted by:

"Michael Thomas" thomas91112

To answer your broader question, there are a few reasons why you may want unadjusted Close prices but that is beyond my intent today.  Unadjusted High and Low price values are less important but come into play most often in Stop Loss analysis as they are typically set against an unadjusted Price.  I thought unadjusted prices may be available as a straight pass-through of data from the Yahoo Finance data file which is why I asked.

If we need to reverse out the price adjustment for High and Low values, what is your algorithm?  Do you envision any problems incorporating the adjustments into an SMF array using smfGetYahooHistory for the High and Low values? 

Thanks

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 31, 2017 2:57 PM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes

  Sorry, no. Adjusted is the new norm. The unadjusted closed is there for reference.
If you really need O/H/L at unadjusted levels, you can always do the calculation yourself.
Unadjusted history for time periods makes NO sense to me. If you want your prices adjusted for splits, you should also want them adjusted for dividends. 
On Wed, May 31, 2017 at 1:56 PM, Michael Thomas thomas91112@​... wrote:

Wish to pass along an observation when using smfGetYahooHistory.  When requesting "adjusted close price" using "c" identifier within "cohl", the open, high and low values appear to also be adjusted....which is fine.  However, when I change to "unadjusted close price" using "u", the values for open, high and low remain unchanged.  Are there different identifiers for unadjusted open, high and low prices?
#yiv2678991562 #yiv2678991562 -- #yiv2678991562ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2678991562 #yiv2678991562ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2678991562 #yiv2678991562ygrp-mkp #yiv2678991562hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2678991562 #yiv2678991562ygrp-mkp #yiv2678991562ads {margin-bottom:10px;}#yiv2678991562 #yiv2678991562ygrp-mkp .yiv2678991562ad {padding:0 0;}#yiv2678991562 #yiv2678991562ygrp-mkp .yiv2678991562ad p {margin:0;}#yiv2678991562 #yiv2678991562ygrp-mkp .yiv2678991562ad a {color:#0000ff;text-decoration:none;}#yiv2678991562 #yiv2678991562ygrp-sponsor #yiv2678991562ygrp-lc {font-family:Arial;}#yiv2678991562 #yiv2678991562ygrp-sponsor #yiv2678991562ygrp-lc #yiv2678991562hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2678991562 #yiv2678991562ygrp-sponsor #yiv2678991562ygrp-lc .yiv2678991562ad {margin-bottom:10px;padding:0 0;}#yiv2678991562 #yiv2678991562actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2678991562 #yiv2678991562activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2678991562 #yiv2678991562activity span {font-weight:700;}#yiv2678991562 #yiv2678991562activity span:first-child {text-transform:uppercase;}#yiv2678991562 #yiv2678991562activity span a {color:#5085b6;text-decoration:none;}#yiv2678991562 #yiv2678991562activity span span {color:#ff7900;}#yiv2678991562 #yiv2678991562activity span .yiv2678991562underline {text-decoration:underline;}#yiv2678991562 .yiv2678991562attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2678991562 .yiv2678991562attach div a {text-decoration:none;}#yiv2678991562 .yiv2678991562attach img {border:none;padding-right:5px;}#yiv2678991562 .yiv2678991562attach label {display:block;margin-bottom:5px;}#yiv2678991562 .yiv2678991562attach label a {text-decoration:none;}#yiv2678991562 blockquote {margin:0 0 0 4px;}#yiv2678991562 .yiv2678991562bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2678991562 .yiv2678991562bold a {text-decoration:none;}#yiv2678991562 dd.yiv2678991562last p a {font-family:Verdana;font-weight:700;}#yiv2678991562 dd.yiv2678991562last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2678991562 dd.yiv2678991562last p span.yiv2678991562yshortcuts {margin-right:0;}#yiv2678991562 div.yiv2678991562attach-table div div a {text-decoration:none;}#yiv2678991562 div.yiv2678991562attach-table {width:400px;}#yiv2678991562 div.yiv2678991562file-title a, #yiv2678991562 div.yiv2678991562file-title a:active, #yiv2678991562 div.yiv2678991562file-title a:hover, #yiv2678991562 div.yiv2678991562file-title a:visited {text-decoration:none;}#yiv2678991562 div.yiv2678991562photo-title a, #yiv2678991562 div.yiv2678991562photo-title a:active, #yiv2678991562 div.yiv2678991562photo-title a:hover, #yiv2678991562 div.yiv2678991562photo-title a:visited {text-decoration:none;}#yiv2678991562 div#yiv2678991562ygrp-mlmsg #yiv2678991562ygrp-msg p a span.yiv2678991562yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2678991562 .yiv2678991562green {color:#628c2a;}#yiv2678991562 .yiv2678991562MsoNormal {margin:0 0 0 0;}#yiv2678991562 o {font-size:0;}#yiv2678991562 #yiv2678991562photos div {float:left;width:72px;}#yiv2678991562 #yiv2678991562photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2678991562 #yiv2678991562photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2678991562 #yiv2678991562reco-category {font-size:77%;}#yiv2678991562 #yiv2678991562reco-desc {font-size:77%;}#yiv2678991562 .yiv2678991562replbq {margin:4px;}#yiv2678991562 #yiv2678991562ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2678991562 #yiv2678991562ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2678991562 #yiv2678991562ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2678991562 #yiv2678991562ygrp-mlmsg select, #yiv2678991562 input, #yiv2678991562 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2678991562 #yiv2678991562ygrp-mlmsg pre, #yiv2678991562 code {font:115% monospace;}#yiv2678991562 #yiv2678991562ygrp-mlmsg * {line-height:1.22em;}#yiv2678991562 #yiv2678991562ygrp-mlmsg #yiv2678991562logo {padding-bottom:10px;}#yiv2678991562 #yiv2678991562ygrp-msg p a {font-family:Verdana;}#yiv2678991562 #yiv2678991562ygrp-msg p#yiv2678991562attach-count span {color:#1E66AE;font-weight:700;}#yiv2678991562 #yiv2678991562ygrp-reco #yiv2678991562reco-head {color:#ff7900;font-weight:700;}#yiv2678991562 #yiv2678991562ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2678991562 #yiv2678991562ygrp-sponsor #yiv2678991562ov li a {font-size:130%;text-decoration:none;}#yiv2678991562 #yiv2678991562ygrp-sponsor #yiv2678991562ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2678991562 #yiv2678991562ygrp-sponsor #yiv2678991562ov ul {margin:0;padding:0 0 0 8px;}#yiv2678991562 #yiv2678991562ygrp-text {font-family:Georgia;}#yiv2678991562 #yiv2678991562ygrp-text p {margin:0 0 1em 0;}#yiv2678991562 #yiv2678991562ygrp-text tt {font-size:120%;}#yiv2678991562 #yiv2678991562ygrp-vital ul li:last-child {border-right:none !important;}#yiv2678991562

Wed May 31, 2017 5:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

An unadjusted closing price *IS* available.

If you need to create unadjusted high and low prices, you'll need to back
out both the dividend adjustments that smfGetYahooHistory() applies, as
well as the splits that Yahoo applies. So get the dividend and split
adjustment columns and divide the adjusted high and low by them. Note that
dividend adjustments will only be correct if you data ends with the most
recent date. I've also seen a few cases where Yahoo missed dividends or
splits.

Yahoo no longer provides unadjusted data for anything other than the
closing price.

On Wed, May 31, 2017 at 4:59 PM, Michael Thomas thomas91112@
​...
wrote:

>
> To answer your broader question, there are a few reasons why you may want
> unadjusted Close prices but that is beyond my intent today. Unadjusted
> High and Low price values are less important but come into play most often
> in Stop Loss analysis as they are typically set against an unadjusted
> Price. I thought unadjusted prices may be available as a straight
> pass-through of data from the Yahoo Finance data file which is why I asked.
>
> If we need to reverse out the price adjustment for High and Low values,
> what is your algorithm? Do you envision any problems incorporating the
> adjustments into an SMF array using smfGetYahooHistory for the High and Low
> values?
>
>
>

Wed May 31, 2017 5:05 pm (PDT) . Posted by:

"Bruce Volkert" bcvolkert@att.net

I suspect you don't need the 64-bit Office. 64-bit Windows is needed to address memory locations beyond the limit that can be expressed with a 32-bit number — I think that happens when you have more than about 3G of memory. But, Office does not care about it because it just functions in a chunk of all that memory (i.e. <3G). When I got my first 64-bit machine, I installed the 64-bit version of Office too. There was grief involved. Stuff did not work well all the time, particularly when I was doing VBA stuff. So, I uninstalled office and reinstalled the 32-bit version (no extra purchase required). Life became predictable again (well on the computing side of it anyway).

Just uninstall Office-64 bit and install 32-bit Office. Your files will not know the difference (other than starting to work right). I suspect you won't even need to do anything with Outlook. Google the process just to make sure you understand what you need to do. Back-up, uninstall Office, and install the 32-bit version. If it does not work with the 32-bit version, there is something else wrong with your approach. But, you really do not need the 64-bit version of office. That is for people doing really advanced math or working with really huge numbers.

The only reason I can think that you would need to use 64-bit office is if you were doing calculations that demand a high level of level of accuracy (like inverting really big matrices, or determining what happened a few milliseconds into the big bang). For finance, you don't need that because the data just is not that good or predictable. But, you might just have a really, really, really, big bunch of assets. If that's the case, just buy T-bills and enjoy your life or hire somebody to worry this for you.

Good luck to you.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, May 30, 2017 9:10 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] XLA library is not being opened in Excel 2016 64 bit.....

Randy - can you create an XLAM file ?

I am unable to open the XLA file in Excel 2016 - 64 bit.

It just refuses to open and thus will not expose the VBA source.

Wed May 31, 2017 5:05 pm (PDT) . Posted by:

spcullinane@outlook.com

This site has been my go-to source. It is the US Energy Information Administration.
https://www.eia.gov/dnav/pet/pet_pri_spt_s1_d.htm https://www.eia.gov/dnav/pet/pet_pri_spt_s1_d.htm


Shaun Cullinane
Torpedo Trading
http://torpedotrading.com http://torpedotrading.com/ http://torpedotrading.com

Wed May 31, 2017 6:25 pm (PDT) . Posted by:

tonyestep

Thanks much, Shaun, that'll do it!

Wed May 31, 2017 5:10 pm (PDT) . Posted by:

spcullinane@outlook.com

Earl - thank you for this post. I have bookmarked the site you referenced. I've found "null" values in several of the historical price series I use. Quite frustrating, as I have various workbooks that automatically go to Yahoo Finance, but I had to make a special pull from Google Finance last week instead to get reliable data. If anyone can confirm if/when they see Yahoo fixing any of the errors that have been reported, please let me know.


Shaun Cullinane
Torpedo Trading
http://torpedotrading.com http://torpedotrading.com/ http://torpedotrading.com/



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....