Minggu, 25 Juni 2017

[smf_addin] Digest Number 4070

11 Messages

Digest #4070

Messages

Sat Jun 24, 2017 7:26 pm (PDT) . Posted by:

dfl10

I'm trying to ex-dividend dates using the smfGetYahooJSONField function. They're all coming back, but some of the data is incorrect meaning that some of the dividend dates are wrong. Not sure if others have experienced this issue since Yahoo changed the api, but thought I'd raise it here.

Sat Jun 24, 2017 7:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

​Can you give me a couple of examples?​

On Sat, Jun 24, 2017 at 5:42 PM, dloewith@
​...
wrote:

> I'm trying to ex-dividend dates using the smfGetYahooJSONField function.
> They're all coming back, but some of the data is incorrect meaning that
> some of the dividend dates are wrong. Not sure if others have experienced
> this issue since Yahoo changed the api, but thought I'd raise it here.
>

Sun Jun 25, 2017 11:53 am (PDT) . Posted by:

dfl10

Never mind. The problem was on my end.

The data looks OK (at least so far).


Sun Jun 25, 2017 6:32 am (PDT) . Posted by:

a.bereziuk

Thanks, but there is an en error in arguments and I spent 1 hour to find it, but didn't find it. ((

Sun Jun 25, 2017 7:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. I just cut and pasted it from the Yahoo group and it worked fine
here. What ticker did you use? Can you access the FinViz web site where you
are?

On Sun, Jun 25, 2017 at 6:32 AM, a.bereziuk@
​...
wrote:

>
> Thanks, but there is an en error in arguments and I spent 1 hour to find
> it, but didn't find it. ((
>
>
>

Sun Jun 25, 2017 7:00 am (PDT) . Posted by:

bioeterp



I am trying to create a table (small example below) that pulls closing prices for specific dates of a list of companies using an array-entered formula. I cannot get it to work - I do not think I am using the right format. Any help would be much appreciated.

I have tried making an array in single columns and get #VALUE! using: {=smfGetYahooHistory(A2:A20,B1,B1,"d","u",0)}


I have tried making an array across single rows and get Error using: {=smfGetYahooHistory(A2,C1:E1,C1:E1,"d","u",0)}




6/16/2017 5/24/2017 3/25/2017 12/25/2016 Tick1 #VALUE! Error Error Error Tick2 #VALUE! Error Error Error




Sun Jun 25, 2017 7:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can't specify ranges for any of the smfGetYahooHistory() parameters...

If you want multiple dates for each ticker, you could use the
smfPricesByDates() function, but it only returns adjusted prices. It
doesn't make sense to compare unadjusted prices from multiple dates.

On Sun, Jun 25, 2017 at 6:47 AM, zack.fink8@
​...
wrote:
​​

> I am trying to create a table (small example below) that pulls closing
> prices for specific dates of a list of companies using an array-entered
> formula. I cannot get it to work - I do not think I am using the right
> format. Any help would be much appreciated.
>
> I have tried making an array in single columns and get #VALUE! using:
> {=smfGetYahooHistory(A2:A20,B1,B1,"d","u",0)}
>
> I have tried making an array across single rows and get Error using:
> {=smfGetYahooHistory(A2,C1:E1,C1:E1,"d","u",0)}
>
>
>
> 6/16/2017 5/24/2017 3/25/2017 12/25/2016
> Tick1 #VALUE! Error Error Error
> Tick2 #VALUE! Error Error Error
>
>

Sun Jun 25, 2017 8:09 am (PDT) . Posted by:

unphazedf

Gotcha - thanks.

I have the smfPricesByDates() working in an array for a single ticker with multiple specified dates, however, I am having trouble extending this array vertically. I want to be able to do a single smf call for multiple dates with multiple tickers. Using the above example:


Works fine: {=smfPricesByDates(A2,B1:E1)}




Doesn't work (#VALUE!): {=smfPricesByDates(A2:A3,B1:E1)}


Thanks in advance.




Sun Jun 25, 2017 8:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There is no add-in formula with multiple tickers and multiple dates,
because there is no data source that I'm aware of that provides data that
way. There would be no advantage to array-entering smfPricesByDates() for
multiple ticker symbols, as it would still need to grab data from the
Internet for each individual ticker symbol.

Just copy the formula down, row by row, for each ticker symbol.

On Sun, Jun 25, 2017 at 8:09 AM, unphazedf@
​...
wrote:

>
> I have the smfPricesByDates() working in an array for a single ticker with
> multiple specified dates, however, I am having trouble extending this array
> vertically. I want to be able to do a single smf call for multiple dates
> with multiple tickers. Using the above example:
>
> Works fine: {=smfPricesByDates(A2,B1:E1)}
>
> Doesn't work (#VALUE!): {=smfPricesByDates(A2:A3,B1:E1)}
>
>
>

Sun Jun 25, 2017 3:17 pm (PDT) . Posted by:

for30sqn

I am having trouble getting my Excel spreadsheet which calculates Chandelier Stops running again. I think calculations stopped early May.
The array function I previously used with success was "=RCHGetYahooHistory(A2,,,,,,,,"DHLC")" over a 4 by 20 array.
I have Windows 10, 64 bit installed and use Excel 2007. The latest Add-in file in use is Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in;Windows(32-bit) NT6.02; 12.0;;;1)
I previously placed the SMF directory in C:\Program files, but have now have it in C:\
After updating the Add-in, when I load a file, I initially see data up to early May when the problem with Yahoo arose, but when I clean up the SMF function to show the current location of the SMF Add-in, I get blank information in the array. Other SMF functions in the page such as last trade value, stock price daily increase/decrease value, or stock name all display properly.
I've been watching all the traffic on the SMF Add-in Group and must admit that I'm a bit overwhelmed by all I read. I'm looking for help to get my Yahoo History array working properly once again.
Thanks in advance; I appreciate all your help. Allen Sundvall

Sun Jun 25, 2017 3:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Last month, Yahoo dropped their old historical CSV files, so I had to write
a new function to extract the data from their new JSON feed. It's currently
in *beta* mode. See:

2017-05-18 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
smfGetYahooHistory() parameters:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
2017-05-21 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
2017-05-25 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
2017-06-09 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537

On Sun, Jun 25, 2017 at 3:17 PM, for30sqn@
​...
wrote:

>
> I am having trouble getting my Excel spreadsheet which calculates
> Chandelier Stops running again. I think calculations stopped early May.
> The array function I previously used with success was
> "=RCHGetYahooHistory(A2,,,,,,,,"DHLC")" over a 4 by 20 array.
> I have Windows 10, 64 bit installed and use Excel 2007. The latest Add-in
> file in use is Stock Market Functions add-in, Version 2.1.2017.05.03
> (C:\SMF Add-in;Windows(32-bit) NT6.02; 12.0;;;1)
> I previously placed the SMF directory in C:\Program files, but have
> now have it in C:\
> After updating the Add-in, when I load a file, I initially see data up to
> early May when the problem with Yahoo arose, but when I clean up the SMF
> function to show the current location of the SMF Add-in, I get blank
> information in the array. Other SMF functions in the page such as last
> trade value, stock price daily increase/decrease value, or stock name all
> display properly.
> I've been watching all the traffic on the SMF Add-in Group and must admit
> that I'm a bit overwhelmed by all I read. I'm looking for help to get my
> Yahoo History array working properly once again.
> Thanks in advance; I appreciate all your help. Allen Sundvall
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.01

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)