2 Messages

Digest #4381

SMF pricing download problem since March 2018 by thomas91112

Re: SMF pricing download problem since March 2018 by "Randy Harmelink" rharmelink

Messages

1a

SMF pricing download problem since March 2018

Fri Aug 10, 2018 12:13 pm (PDT) . Posted by:

thomas91112

Have noticed that monthly adjusted close pricing data for SPY, EWA and TLT are erroneous or missing since March 2018. Have compared SMF results to both downloaded and website presented Yahoo data.

Am using smfGetYahooHistory(GE$1,GE$4,$B2,"m","C",0,1) for all items which works well up until 3/18.

SMF DOWNLOAD FOR SPY (S&P 500 ETF)

Aug-18 No data Jul-18 No data Jun-18 No data May-18 282.525 Apr-18 261.804 Mar-18 260.929

YAHOO FINANCE WEBSITE & DOWNLOAD VALUES
Date Open High Low Close* Adj Close** Volume Aug 10, 2018 283.45 284.05 282.39 282.80 282.80 48,463,868 Aug 01, 2018 281.56 286.01 279.16 285.07 285.07 331,579,600 Jul 01, 2018 269.51 284.37 269.24 281.33 281.33 1,266,892,500 Jun 15, 2018 1.246 Dividend Jun 01, 2018 272.41 279.48 268.49 271.28 270.07 1,595,428,200 May 01, 2018 263.87 274.25 259.05 270.94 269.73 1,599,196,300 Apr 01, 2018 262.55 271.30 254.67 264.51 263.33 1,998,466,500 Mar 16, 2018 1.097 Dividend Mar 01, 2018 271.41 280.41 257.83 263.15 260.93 2,323,561,800

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: SMF pricing download problem since March 2018

Fri Aug 10, 2018 3:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm confused. The formula you cited says to resort it, but your sample of
returned data has current date first. I tried this formula:

=smfGetYahooHistory("SPY",,,"m","dC",0,1)

....and I get:

2018-03-01 $260.93
2018-04-01 $263.33
2018-05-01 $269.73
2018-06-01 $270.07
2018-07-01 $281.33
2018-08-01 $285.07
2018-08-10 $283.16
I added the dates so I could see where it was going bad, but it didn't go
bad. If I repeat the formula without requesting a date column, the returned
data matches the second column of the above table.

Exactly what parameters are you passing to the formula?

On Fri, Aug 10, 2018 at 12:12 PM, thomas91112@
....
wrote:

>
> Have noticed that monthly adjusted close pricing data for SPY, EWA and TLT
> are erroneous or missing since March 2018. Have compared SMF results to
> both downloaded and website presented Yahoo data.
>
> Am using smfGetYahooHistory(GE$1,GE$4,$B2,"m","C",0,1) for all items
> which works well up until 3/18.
>
> SMF DOWNLOAD FOR SPY (S&P 500 ETF)
> Aug-18 No data
> Jul-18 No data
> Jun-18 No data
> May-18 282.525
> Apr-18 261.804
> Mar-18 260.929
> YAHOO FINANCE WEBSITE & DOWNLOAD VALUES
> DateOpenHighLowClose*Adj Close**Volume
> Aug 10, 2018 283.45 284.05 282.39 282.80 282.80 48,463,868
> Aug 01, 2018 281.56 286.01 279.16 285.07 285.07 331,579,600
> Jul 01, 2018 269.51 284.37 269.24 281.33 281.33 1,266,892,500
> Jun 15, 2018 *1.246* Dividend
> Jun 01, 2018 272.41 279.48 268.49 271.28 270.07 1,595,428,200
> May 01, 2018 263.87 274.25 259.05 270.94 269.73 1,599,196,300
> Apr 01, 2018 262.55 271.30 254.67 264.51 263.33 1,998,466,500
> Mar 16, 2018 *1.097* Dividend
> Mar 01, 2018 271.41 280.41 257.83 263.15 260.93 2,323,561,800
>
>