Rabu, 13 Juli 2016

[smf_addin] Digest Number 3742

15 Messages

Digest #3742
1a
Valueline by davidjosephchapman
2b
Re: Options quotes stopped working by "Randy Harmelink" rharmelink
2c
Re: Options quotes stopped working by "Tony Grimes" raul_the_pool_boy
2d
Re: Options quotes stopped working by "Randy Harmelink" rharmelink
2f
Re: Options quotes stopped working by "Randy Harmelink" rharmelink
3b
Re: Using smfGetOptionStrikes Function in VBA by "Randy Harmelink" rharmelink

Messages

Wed Jul 13, 2016 7:18 am (PDT) . Posted by:

davidjosephchapman

Has anyone done any Valueline functions/elements?


Wed Jul 13, 2016 10:28 am (PDT) . Posted by:

jimexstock


Hi,
seems that this week my options quotes stopped working. Just return "error" from the calls. smfGetYahooOptionQuote was what I was using, but have tried MSN, and others. Nothing seems to work anymore. GetYahooQuotes has continued to work fine.


Anyone else having issues? Any suggestions on what to try would be welcome. Jim

Wed Jul 13, 2016 12:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sigh. Massive Yahoo Finance web page changes. I've uploaded
RCH_Stock_Market_Functions-2.1.2016.07.13.zip to the web site, which has a
quick and dirty fix to get quotes from the new web pages. When I get more
time, I'm going to have to review all of the Yahoo extractions. On a
worried note -- I don't see anything on the new Yahoo quotes pages that
allow the export of data to a CSV file (which is what feeds
RCHGetYahooQuotes()).

http://ogres-crypt.com/SMF/

It can grab these data items:

*Code* *Description*
% % Change
A Ask Price
B Bid Price
C $ Change
I Open Interest
L Last Price
O Open Price
P Previous Close
S Strike Price
V Volume
X Expiry Date
Z Ticker Symbol
​P.S.: Google and OptionsXPress were still working.​ MSN is now obsolete.

On Wed, Jul 13, 2016 at 10:28 AM, jim_w_baker@
​...wrote:

> seems that this week my options quotes stopped working. Just return
> "error" from the calls. smfGetYahooOptionQuote was what I was using, but
> have tried MSN, and others. Nothing seems to work anymore.
> GetYahooQuotes has continued to work fine.
>
> Anyone else having issues? Any suggestions on what to try would be
> welcome. Jim
>

Wed Jul 13, 2016 5:19 pm (PDT) . Posted by:

"Tony Grimes" raul_the_pool_boy

For MMM this hyperlink (Download Data) is under the Apply button on the
historical tab.

http://chart.finance.yahoo.com/table.csv?s=MMM&a=5&b=13&c=2016&d=6&e=13&f=2016&g=d&ignore=.csv

On Wed, Jul 13, 2016 at 3:57 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Sigh. Massive Yahoo Finance web page changes. I've uploaded
> RCH_Stock_Market_Functions-2.1.2016.07.13.zip to the web site, which has a
> quick and dirty fix to get quotes from the new web pages. When I get more
> time, I'm going to have to review all of the Yahoo extractions. On a
> worried note -- I don't see anything on the new Yahoo quotes pages that
> allow the export of data to a CSV file (which is what feeds
> RCHGetYahooQuotes()).
>
> http://ogres-crypt.com/SMF/
>
> It can grab these data items:
>
> *Code* *Description*
> % % Change
> A Ask Price
> B Bid Price
> C $ Change
> I Open Interest
> L Last Price
> O Open Price
> P Previous Close
> S Strike Price
> V Volume
> X Expiry Date
> Z Ticker Symbol
> ​P.S.: Google and OptionsXPress were still working.​ MSN is now obsolete.
>
> On Wed, Jul 13, 2016 at 10:28 AM, jim_w_baker@
> ​...wrote:
>
>> seems that this week my options quotes stopped working. Just return
>> "error" from the calls. smfGetYahooOptionQuote was what I was using, but
>> have tried MSN, and others. Nothing seems to work anymore.
>> GetYahooQuotes has continued to work fine.
>>
>> Anyone else having issues? Any suggestions on what to try would be
>> welcome. Jim
>>
>
>
>

Wed Jul 13, 2016 5:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops. Yeah. I saw that one. But it's for historical quotes.

The one I can't find is the one for current quotes. I should have been more
specific. I suppose the fact that RCHGetYahooQuotes() is working means
things are OK. But I'm worried it could suddenly disappear. OTOH, I think
they do use it for their portfolios feature. And that still exists. The
download link is still on the portfolios page.

On Wed, Jul 13, 2016 at 5:18 PM, Tony Grimes Tonez.Email@Gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> For MMM this hyperlink (Download Data) is under the Apply button on the
> historical tab.
>
>
> http://chart.finance.yahoo.com/table.csv?s=MMM&a=5&b=13&c=2016&d=6&e=13&f=2016&g=d&ignore=.csv
>
> On Wed, Jul 13, 2016 at 3:57 PM, Randy Harmelink rharmelink@
> <rharmelink@gmail.com>
> ​...​
> wrote:
>
>> On a worried note -- I don't see anything on the new Yahoo quotes pages
>> that allow the export of data to a CSV file (which is what feeds
>> RCHGetYahooQuotes()).
>>
>

Wed Jul 13, 2016 7:27 pm (PDT) . Posted by:

dr_henning

My excel files downloading historical stock data using RCHGetYahooHistory stopped working this morning when Yahoo changed yahoo finance. Is you fix just
for options or for stocks as well?

Wed Jul 13, 2016 7:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I tried a few examples of RCHGetYahooHistory() and they're working fine for
me. I made no changes to the add-in for it.

What specifically is not working for you?

On Wed, Jul 13, 2016 at 6:54 PM, dr_henning@
​...wrote:

>
> My excel files downloading historical stock data using RCHGetYahooHistory
> stopped working this morning when Yahoo changed yahoo finance. Is you fix
> just
> for options or for stocks as well?
>
>

Wed Jul 13, 2016 1:04 pm (PDT) . Posted by:

raig002

Hi Randy:
I want to use the smfGetOptionStrikes function to get Strike prices for a specific Stock,
in a range of cells and mimic the Shift+Ctrl+Enter programmatically in VBA.
My code in VBA works but I get just one value strike price in cell A51, but I need at least the 15 strike prices, please help.


Sub Test()
Cells(51, 1).Value = "=smfGetOptionStrikes(F5, L6, ""P"",""Y"")"
Set RngX = ActiveSheet.Range("A51:A66")
RngX.Select
RngX.Calculate
End Sub



Note: F5 cell contains the stock symbol like AAPL,
L6 cell contains the expiration date like 07/22/2016


Thanks a lot.
Tony

Wed Jul 13, 2016 1:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For what you're trying to do, you need to use the FormulaArray property of
the range to array-enter the formula. Also, the SELECT and CALCULATE don't
do anything for you. So all you really need is:

Sub Test()
ActiveSheet.Range("A51:A66").FormulaArray = "=smfGetOptionStrikes(F5,
L6, ""P"",""Y"")"
End Sub

However, I'm curious why you want to enter the formula using VBA instead of
just manually entering it? You could just plop values into those cells with
something like:

Sub Test2()
vTicker = ActiveSheet.Range("F5").Value
vDate = ActiveSheet.Range("L6").Value
ActiveSheet.Range("H11:H26").Select
Selection.Value = smfGetOptionStrikes(vTicker, vDate, "P", "Y")
End Sub

On Wed, Jul 13, 2016 at 12:21 PM, raig002@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi Randy:
>
> I want to use the smfGetOptionStrikes function to get Strike prices for a
> specific Stock,
>
> in a range of cells and mimic the Shift+Ctrl+Enter programmatically in
> VBA.
>
> My code in VBA works but I get just one value strike price in cell A51,
> but I need at least the 15 strike prices, please help.
>
>
> Sub Test()
>
> Cells(51, 1).Value = "=smfGetOptionStrikes(F5, L6, ""P"",""Y"")"
>
> Set RngX = ActiveSheet.Range("A51:A66")
>
> RngX.Select
>
> RngX.Calculate
>
> End Sub
>
>
> Note: F5 cell contains the stock symbol like AAPL,
>
> L6 cell contains the expiration date like 07/22/2016
>
>

Wed Jul 13, 2016 4:23 pm (PDT) . Posted by:

raig002

Randy, you provided me great solutions, I will use the second part Test2 code, It is the best for me. Thanks a lot. I appreciated your help.


Tony.


Wed Jul 13, 2016 2:26 pm (PDT) . Posted by:

"Ron Spruell" hashky

Randy -

How would I download this table into a spreadsheet. I know it is doable, but I can find the secret.

http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=IIM

Ron Spruell

Wed Jul 13, 2016 4:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Easiest:

=RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=IIM
","Yield")

Or, transposed:

=TRANSPOSE(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=IIM
","Yield",,,,,10,100))

On Wed, Jul 13, 2016 at 2:23 PM, Ron Spruell hashky@
​...wrote:

>
> How would I download this table into a spreadsheet. I know it is doable,
> but I can find the secret.
>
>
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=IIM
>
>

Wed Jul 13, 2016 6:55 pm (PDT) . Posted by:

mokwit

Randy many thanks for what must have been a very late evening reply - The Morningstar string nailed it and with your reply was able to immediately proceed with what I was doing in a timezone ~12 hours different.

For the record: can't get AdvFN to work after creating the Txt file containing "UK" (no"" in file) - my add in is dated 2015-03-05 01:04 PM and thus should incorporate the necessary AdvFN URL changes (?) - also tried the IE changes.

There is some data I would like to pull in from AdFN so if there is anything else I should do please advise.

Wed Jul 13, 2016 7:05 pm (PDT) . Posted by:

mokwit

Randy,
I have noted over the years that smf add in has dropped some data points and sources and had problems with others.

What I suggest may be a detailed source of data that probably won't be moved around/changed is the Financial Times data. The original source is Reuters and it is pretty detailed and covers stocks globally.

Just throwing it out there and hope I don't comea cross as ungrateful - due to constant changes by e.g. AdvFN and others if Financial Times web pages arrangement is not changed much it may save work in the long run. Don't know about copyright etc issues.

Here is their screener page so you can get an idea of what is available:
Global equity screener - FT.com http://markets.ft.com/screener/customScreen.asp

Global equity screener - FT.com http://markets.ft.com/screener/customScreen.asp Filter over 58,000 global equities in all sectors, using more than 50 customisable screening criteria to discover investment opportunities.



View on markets.ft.com http://markets.ft.com/screener/customScreen.asp
Preview by Yahoo


Here is a balance sheet example for a NASDAQ stock
United Therapeutics Corp, UTHR:NSQ financials - FT.com http://markets.ft.com/research/Markets/Tearsheets/Financials?s=UTHR:NSQ&subview=BalanceSheet


United Therapeutics Corp, UTHR:NSQ financials - FT.com http://markets.ft.com/research/Markets/Tearsheets/Financials?s=UTHR:NSQ&subview=BalanceSheet United Therapeutics Corp (UTHR:NSQ) financials, including income statements, growth rates, balance sheets and cash flow information.



View on markets.ft.com http://markets.ft.com/research/Markets/Tearsheets/Financials?s=UTHR:NSQ&subview=BalanceSheet
Preview by Yahoo




Here is a a summary page for a Hong Kong stock.
Boer Power Holdings Ltd, 1685:HKG summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=1685:HKG



Boer Power Holdings Ltd, 1685:HKG summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=1685:HKG Latest Boer Power Holdings Ltd (1685:HKG) share price with interactive charts, historical prices, comparative analysis, forecasts, business profile and more.



View on markets.ft.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=1685:HKG
Preview by Yahoo







Wed Jul 13, 2016 7:43 pm (PDT) . Posted by:

dr_henning

My Excel files that use RCHGetYahooHistory to get daily historical data stopped working for me
this morning, same day Yahoo changed yahoo finance. When I open one of my excel files it prompts "This workbook contains links to other data sources ......... Then box to Update or Don't Update. Click on update and new days data not loaded.
I've been using these excel files for years no problem. Thanks Yahoo!

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

Tidak ada komentar:

Poskan Komentar