15 Messages
Digest #4104
5b
Re: alternative to Forecast earnings element # 559 which no longer w by "Randy Harmelink" rharmelink
Messages
Fri Jul 28, 2017 10:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hopefully a temporary glitch by Yahoo. This worked for me just now when I
tried it:
=RCHGetYahooQuotes("MMM","l1")
If the error persists, what do you get with:
=RCHGetElementNumber("Version")
=RCHGetWebData("
https://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore")
Does that URL above work in your browser? How about in Internet Explorer?
On Fri, Jul 28, 2017 at 1:24 PM, peterscottcook@
...
wrote:
>
> Suddenly, all of my fields that use RCHGetYahooQuotes are returning
> errors. Yesterday everything was fine. I just downloaded the latest release
> and still no change. Any ideas?
>
> (smfGetOptionQuotes fields work fine.)
>
tried it:
=RCHGetYahooQuotes("MMM","l1")
If the error persists, what do you get with:
=RCHGetElementNumber("Version")
=RCHGetWebData("
https://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore")
Does that URL above work in your browser? How about in Internet Explorer?
On Fri, Jul 28, 2017 at 1:24 PM, peterscottcook@
...
wrote:
>
> Suddenly, all of my fields that use RCHGetYahooQuotes are returning
> errors. Yesterday everything was fine. I just downloaded the latest release
> and still no change. Any ideas?
>
> (smfGetOptionQuotes fields work fine.)
>
Sat Jul 29, 2017 5:54 am (PDT) . Posted by:
bob_15861586
The following is not working for me:
=smfGetBarChartOptionQuote("AMD","Call";,DATE(2018,1,19),20,"a")
Also, the following is not working for me either:
=smfGetYahooOptionQuote("AMD","Call";,DATE(2018,1,19),20,"a")
Is somebody down?
Bob
=smfGetBarChartOpti
Also, the following is not working for me either:
=smfGetYahooOptionQ
Is somebody down?
Bob
Sat Jul 29, 2017 8:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm currently getting "N/A" from BarChart and 0.71 from Yahoo...
On Sat, Jul 29, 2017 at 5:54 AM, bob_15861586@
...
wrote:
> The following is not working for me:
>
> =smfGetBarChartOptionQuote("AMD","Call";,DATE(2018,1,19),20,"a")
>
> Also, the following is not working for me either:
>
> =smfGetYahooOptionQuote("AMD","Call";,DATE(2018,1,19),20,"a")
>
> Is somebody down?
>
>
>
On Sat, Jul 29, 2017 at 5:54 AM, bob_15861586@
...
wrote:
> The following is not working for me:
>
> =smfGetBarChartOpti
>
> Also, the following is not working for me either:
>
> =smfGetYahooOptionQ
>
> Is somebody down?
>
>
>
Sat Jul 29, 2017 3:06 pm (PDT) . Posted by:
bob_15861586
Randy,
When I try this:
=smfGetYahooOptionQuote("AMD", "Call", DATE(2018,1,19), 20, "a")
I get: Error .
Bob
When I try this:
=smfGetYahooOptionQ
I get: Error .
Bob
Sat Jul 29, 2017 3:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just cut and pasted the formula and got 0.71.
Have you tried the smfForceRecalculation macro? Or exiting and restarting
EXCEL?
The add-in extracts the data from a saved copy of the web page. Only those
two processes will purge that saved copy and get a fresh copy. Without
doing one of those two things, you'll continue getting "Error" if you do
the same extraction from the same saved copy of the web page.
What version of the add-in are you using?
=RCHGetElementNumber("Version")
On Sat, Jul 29, 2017 at 3:06 PM, bob_15861586@
...
wrote:
>
> Randy,
>
> When I try this:
> =smfGetYahooOptionQuote("AMD", "Call", DATE(2018,1,19), 20, "a")
> I get: Error .
>
>
>
Have you tried the smfForceRecalculati
EXCEL?
The add-in extracts the data from a saved copy of the web page. Only those
two processes will purge that saved copy and get a fresh copy. Without
doing one of those two things, you'll continue getting "Error" if you do
the same extraction from the same saved copy of the web page.
What version of the add-in are you using?
=RCHGetElementNumbe
On Sat, Jul 29, 2017 at 3:06 PM, bob_15861586@
...
wrote:
>
> Randy,
>
> When I try this:
> =smfGetYahooOptionQ
> I get: Error .
>
>
>
Sat Jul 29, 2017 3:52 pm (PDT) . Posted by:
bob_15861586
Randy,
I have tired restarting Excel but that does not help. The version of SMF that I am using is:
Stock Market Functions add-in, Version 2.1.2017.03.15 (C:\SMF Add-In; Windows (32-bit) NT :.00; 15.0; ; ; 1)
That string is from the function RCHGetElementNumber. I am thinking that is the current version
or at least close to it.
Bob
I have tired restarting Excel but that does not help. The version of SMF that I am using is:
Stock Market Functions add-in, Version 2.1.2017.03.
That string is from the function RCHGetElementNumber
or at least close to it.
Bob
Sat Jul 29, 2017 3:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to update to a newer version of the add-in. I had to update all
Yahoo URLs from "http:" to "https:" back in April:
2017-04-26 smfGetOptionQuotes
smfGetYahooOptionQuotes
RCHGetElementNumber Updated all remaining Yahoo usage of protocol "http://"
to "https://", both in element definitions and in the XLA file.
On Sat, Jul 29, 2017 at 3:52 PM, bob_15861586@
...
wrote:
>
> I have tired restarting Excel but that does not help. The version of SMF
> that I am using is:
>
> Stock Market Functions add-in, Version 2.1.2017.03.15 (C:\SMF Add-In;
> Windows (32-bit) NT :.00; 15.0; ; ; 1)
>
> That string is from the function RCHGetElementNumber. I am thinking that
> is the current version
> or at least close to it.
>
>
Yahoo URLs from "http:" to "https:
2017-04-26 smfGetOptionQuotes
smfGetYahooOptionQu
RCHGetElementNumber Updated all remaining Yahoo usage of protocol "http:/
to "https:
On Sat, Jul 29, 2017 at 3:52 PM, bob_15861586@
...
wrote:
>
> I have tired restarting Excel but that does not help. The version of SMF
> that I am using is:
>
> Stock Market Functions add-in, Version 2.1.2017.03.
> Windows (32-bit) NT :.00; 15.0; ; ; 1)
>
> That string is from the function RCHGetElementNumber
> is the current version
> or at least close to it.
>
>
Sat Jul 29, 2017 3:58 pm (PDT) . Posted by:
bob_15861586
Randy,
Thanks. The procedure I posted for updating SMF. Is it right?
Bob
Thanks. The procedure I posted for updating SMF. Is it right?
Bob
Sat Jul 29, 2017 7:23 am (PDT) . Posted by:
dcharlotte99
I'm also not pulling in Adjusted Close on using the new Beta. Using RCHGetYahooHistory in an array with data character strings DOHLCVA. Everything pulls in except 'A' adjusted close which is blank. Is there a new format for the character strings? Searched the conversations couldn't find. Thank you
Sat Jul 29, 2017 12:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
"C" is now the adjusted close, so when you specify both "C" and "A", you
only get one of them. If you want both adjusted and unadjusted, you'll need
to use DOHLCVU.
On Sat, Jul 29, 2017 at 7:23 AM, dcharlotte99@
...
wrote:
>
> I'm also not pulling in Adjusted Close on using the new Beta. Using
> RCHGetYahooHistory in an array with data character strings DOHLCVA.
> Everything pulls in except 'A' adjusted close which is blank. Is there a
> new format for the character strings? Searched the conversations couldn't
> find. Thank you
>
only get one of them. If you want both adjusted and unadjusted, you'll need
to use DOHLCVU.
On Sat, Jul 29, 2017 at 7:23 AM, dcharlotte99@
...
wrote:
>
> I'm also not pulling in Adjusted Close on using the new Beta. Using
> RCHGetYahooHistory in an array with data character strings DOHLCVA.
> Everything pulls in except 'A' adjusted close which is blank. Is there a
> new format for the character strings? Searched the conversations couldn't
> find. Thank you
>
Sat Jul 29, 2017 10:12 am (PDT) . Posted by:
pete_cook2001
Do you know which of the sources have the most up-to-date (regardless of speed)?
Sat Jul 29, 2017 12:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The usual standard is 15 minutes delayed, which is why I was very surprised
to see the longer delay at barchart. The biggest issue for me on the
barchart delay is that the first update isn't done until 10:30 am EST. The
opening can cause some big changes. Usually, during the day, I prefer the
quick response.
On Sat, Jul 29, 2017 at 10:12 AM, peterscottcook@
...
wrote:
>
> Do you know which of the sources have the most up-to-date (regardless of
> speed)?
>
to see the longer delay at barchart. The biggest issue for me on the
barchart delay is that the first update isn't done until 10:30 am EST. The
opening can cause some big changes. Usually, during the day, I prefer the
quick response.
On Sat, Jul 29, 2017 at 10:12 AM, peterscottcook@
...
wrote:
>
> Do you know which of the sources have the most up-to-date (regardless of
> speed)?
>
Sat Jul 29, 2017 3:38 pm (PDT) . Posted by:
mokwit
Is there an alternative to Forecast earnings element # 559 which no longer works?
Also 'Adjustments to Net Income' which I was using as a dirty proxy for option expense via
=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & N2 & "&annual",1,"Period Ending","Adjustments To Net Income",,,,"Add to Portfolio")
either a replacement for this or better the actual Option Expense line item
Also Net Income 961 - I have found 3428 but wonder if that is directly comparable
Also 'Adjustments to Net Income' which I was using as a dirty proxy for option expense via
=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & N2 & "&annual"
either a replacement for this or better the actual Option Expense line item
Also Net Income 961 - I have found 3428 but wonder if that is directly comparable
Sat Jul 29, 2017 3:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample ticker please. I tried to view a few Canadian companies and all had
no data showing on the cash flow web pages. Also, make sure you can see
data on the URL in the formula for the sample ticker.
On Sat, Jul 29, 2017 at 3:38 PM, pmanz@
...
wrote:
>
> Is there an alternative to Forecast earnings element # 559 which no longer
> works?
>
> Also 'Adjustments to Net Income' which I was using as a dirty proxy for
> option expense via
>
> =RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & N2 &
> "&annual",1,"Period Ending","Adjustments To Net Income",,,,"Add to
> Portfolio")
>
> either a replacement for this or better the actual Option Expense line item
>
> Also Net Income 961 - I have found 3428 but wonder if that is directly
> comparable
>
>
>
no data showing on the cash flow web pages. Also, make sure you can see
data on the URL in the formula for the sample ticker.
On Sat, Jul 29, 2017 at 3:38 PM, pmanz@
...
wrote:
>
> Is there an alternative to Forecast earnings element # 559 which no longer
> works?
>
> Also 'Adjustments to Net Income' which I was using as a dirty proxy for
> option expense via
>
> =RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & N2 &
> "&annual"
> Portfolio"
>
> either a replacement for this or better the actual Option Expense line item
>
> Also Net Income 961 - I have found 3428 but wonder if that is directly
> comparable
>
>
>
Sat Jul 29, 2017 3:57 pm (PDT) . Posted by:
bob_15861586
If I want to update to he latest version of SMF, will the following procedure work?
1) Download the latest version of SMF
2) Extract the files into the directory "SMF Add-In"
3) Start Excel again.
It seems very simple but some how, I am thinking to update SMF is going to be a several our job. I am hoping that somebody could comment.
Bob
1) Download the latest version of SMF
2) Extract the files into the directory "SMF Add-In"
3) Start Excel again.
It seems very simple but some how, I am thinking to update SMF is going to be a several our job. I am hoping that somebody could comment.
Bob
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar