6 Messages
Digest #4601
Messages
Thu Aug 15, 2019 8:33 am (PDT) . Posted by:
coffeesandbox
I may have missed this in other posts but I am getting an "Error" only in the last column of Yahoo Key Stats using excel 2007, 2016 and 2019. Columns 1 & 2 work fine.
I've tried adding 972 from RCHGetElementNumber(Ticker,972) into a working column cell unsuccessfully.
I'm not sure if Microsoft's choke-hold "Permissions" on everything has anything to do with it, or perhaps Yahoo made some changes to the Stats page, but any suggestions would be appreciated?
The key information I need is Beta.
TRADING INFORMATION Stock Price History Beta: Error 52-Week Change: Error S&P500 52-Week Change: Error 52-Week High: $124.79 Date of 52-Week High: Obsolete 52-Week Low: $76.62 Date of 52-Week Low: Obsolete 50-Day Moving Average: Error 200-Day Moving Average: Error Share Statistics Average Volume (3 month): Error Average Volume (10 day): Error Shares Outstanding: Error Float: Error % Held by Insiders: Error % Held by Institutions: Error Shares Short: Error Short Ratio: Error Short % of Float: Error Shares Short (prior month): Error Dividends & Splits Forward Annual Dividend Rate: Error Forward Annual Dividend Yield: Error Trailing Annual Dividend Rate: Error Trailing Annual Dividend Yield: Error 5 Year Average Dividend Yield: Error Payout Ratio: Error Dividend Date: Error Ex-Dividend Date: Error Last Split Factor (new per old): Error Last Split Date: Mar 16, 2000
I've tried adding 972 from RCHGetElementNumber
I'm not sure if Microsoft'
The key information I need is Beta.
TRADING INFORMATION Stock Price History Beta: Error 52-Week Change: Error S&P500 52-Week Change: Error 52-Week High: $124.79 Date of 52-Week High: Obsolete 52-Week Low: $76.62 Date of 52-Week Low: Obsolete 50-Day Moving Average: Error 200-Day Moving Average: Error Share Statistics Average Volume (3 month): Error Average Volume (10 day): Error Shares Outstanding: Error Float: Error % Held by Insiders: Error % Held by Institutions: Error Shares Short: Error Short Ratio: Error Short % of Float: Error Shares Short (prior month): Error Dividends & Splits Forward Annual Dividend Rate: Error Forward Annual Dividend Yield: Error Trailing Annual Dividend Rate: Error Trailing Annual Dividend Yield: Error 5 Year Average Dividend Yield: Error Payout Ratio: Error Dividend Date: Error Ex-Dividend Date: Error Last Split Factor (new per old): Error Last Split Date: Mar 16, 2000
Thu Aug 15, 2019 8:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The template is working for me, so I'll assume you haven't updated your
smf-elements-2.txt file, with the June updates?
https://smf-add-in.blogspot.com/2019/06/alert-some-yahoo-element-definitions.html
On Thu, Aug 15, 2019 at 8:34 AM coffeesandbox@... wrote:
>
> I may have missed this in other posts but I am getting an "Error" only in
> the last column of Yahoo Key Stats using excel 2007, 2016 and 2019. Columns
> 1 & 2 work fine.
>
> I've tried adding 972 from RCHGetElementNumber(Ticker,972) into a working
> column cell unsuccessfully.
>
> I'm not sure if Microsoft's choke-hold "Permissions" on everything has
> anything to do with it, or perhaps Yahoo made some changes to the Stats
> page, but any suggestions would be appreciated?
>
> The key information I need is Beta.
>
>
> TRADING INFORMATION Stock Price History Beta: Error 52-Week
> Change: Error S&P500 52-Week Change: Error 52-Week High:
> $124.79 Date of 52-Week High: Obsolete 52-Week Low: $76.62
> Date of 52-Week Low: Obsolete 50-Day Moving Average: Error 200-Day
> Moving Average: Error Share Statistics Average Volume (3
> month): Error Average Volume (10 day): Error Shares
> Outstanding: Error Float: Error % Held by Insiders: Error
> % Held by Institutions: Error Shares Short: Error Short
> Ratio: Error Short % of Float: Error Shares Short (prior
> month): Error Dividends & Splits Forward Annual Dividend Rate:
> Error Forward Annual Dividend Yield: Error Trailing Annual
> Dividend Rate: Error Trailing Annual Dividend Yield: Error 5
> Year Average Dividend Yield: Error Payout Ratio: Error Dividend
> Date: Error Ex-Dividend Date: Error Last Split Factor (new
> per old): Error Last Split Date: Mar 16, 2000
>
>
>
smf-elements-2.txt file, with the June updates?
https://smf-add-in.blogspot.com/2019/06/alert-some-yahoo-element-definitions.html
On Thu, Aug 15, 2019 at 8:34 AM coffeesandbox@
>
> I may have missed this in other posts but I am getting an "Error" only in
> the last column of Yahoo Key Stats using excel 2007, 2016 and 2019. Columns
> 1 & 2 work fine.
>
> I've tried adding 972 from RCHGetElementNumber
> column cell unsuccessfully.
>
> I'm not sure if Microsoft'
> anything to do with it, or perhaps Yahoo made some changes to the Stats
> page, but any suggestions would be appreciated?
>
> The key information I need is Beta.
>
>
> TRADING INFORMATION Stock Price History Beta: Error 52-Week
> Change: Error S&P500 52-Week Change: Error 52-Week High:
> $124.79 Date of 52-Week High: Obsolete 52-Week Low: $76.62
> Date of 52-Week Low: Obsolete 50-Day Moving Average: Error 200-Day
> Moving Average: Error Share Statistics Average Volume (3
> month): Error Average Volume (10 day): Error Shares
> Outstanding: Error Float: Error % Held by Insiders: Error
> % Held by Institutions: Error Shares Short: Error Short
> Ratio: Error Short % of Float: Error Shares Short (prior
> month): Error Dividends & Splits Forward Annual Dividend Rate:
> Error Forward Annual Dividend Yield: Error Trailing Annual
> Dividend Rate: Error Trailing Annual Dividend Yield: Error 5
> Year Average Dividend Yield: Error Payout Ratio: Error Dividend
> Date: Error Ex-Dividend Date: Error Last Split Factor (new
> per old): Error Last Split Date: Mar 16, 2000
>
>
>
Thu Aug 15, 2019 12:58 pm (PDT) . Posted by:
"Pieter van Leeuwen" pietertvl
I'm still using Excel 2007 (& Office 2007) WITHOUT "THE BENEFIT" of MS Support.
Happy camper.
Won't touch 365. Or Win10.
Apologies if anyone takes offense at these potentially 'political' statements. :-)
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, August 14, 2019 3:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Compatibility
It's compatible with Office 365. That's what I currently use. I have no interest in extending it to other platforms. Not even sure it would be possible.
On Wed, Aug 14, 2019 at 12:51 PM bobobfd@... wrote:
Microsoft is slowly dropping support for its standalone Office products. For example, Office 2010's extended support stops in Oct. 2020 and Office 2016 support stops in Oct 2025, I think.
I don't have hands-on knowledge with the following (using Excel 2013) but was wondering if SMF is compatible with -
1. Office 365
2. LibreOffice Calc
3. Google Sheets
I'm guessing 2 & 3 are not. If not. have you ever considered making SMF versions for these two? I'm *not* trying to add to your workload - really :~) - but I am trying to plan ahead re SMF.
Happy camper.
Won't touch 365. Or Win10.
Apologies if anyone takes offense at these potentially 'political' statements. :-)
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, August 14, 2019 3:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Compatibility
It's compatible with Office 365. That's what I currently use. I have no interest in extending it to other platforms. Not even sure it would be possible.
On Wed, Aug 14, 2019 at 12:51 PM bobobfd@... wrote:
Microsoft is slowly dropping support for its standalone Office products. For example, Office 2010's extended support stops in Oct. 2020 and Office 2016 support stops in Oct 2025, I think.
I don't have hands-on knowledge with the following (using Excel 2013) but was wondering if SMF is compatible with -
1. Office 365
2. LibreOffice Calc
3. Google Sheets
I'm guessing 2 & 3 are not. If not. have you ever considered making SMF versions for these two? I'm *not* trying to add to your workload - really :~) - but I am trying to plan ahead re SMF.
Thu Aug 15, 2019 4:21 pm (PDT) . Posted by:
mrpatmcginnis
Has anyone looked at or subscribed to AAII (American Association of Individual Investors) "Stock Investor Pro"?
I looked at Guru Focus and also felt it was pricey. AAII have a better priced 'weekly' update with 7 years of data and tons of other data fields. I was just wondering if Randy has ever came across it and can it be accessed with a subscription.
Thank you Randy.
I looked at Guru Focus and also felt it was pricey. AAII have a better priced 'weekly' update with 7 years of data and tons of other data fields. I was just wondering if Randy has ever came across it and can it be accessed with a subscription.
Thank you Randy.
Thu Aug 15, 2019 4:42 pm (PDT) . Posted by:
"Robbie Geary" rgearyiii
If you're an SI Pro subscriber, then gtr1.net/2013 essentially provides an
API for building customized spreadsheets (with no size constraints) with
AAII data and derived computations. As the developer of the backtester,
I'm aware that some automate this, with which I have no problems. As for
whether the whole process could be completely automated and encapsulated
into SMF functions, I have no idea, but you're certainly welcome to try..
The backtester is discussed at
https://boards.fool.com/Messages.asp?mid=&bid=100093
On Fri, Aug 16, 2019 at 9:22 AM mrpatmcginnis@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Has anyone looked at or subscribed to AAII (American Association of
> Individual Investors) "Stock Investor Pro"?
>
> I looked at Guru Focus and also felt it was pricey. AAII have a better
> priced 'weekly' update with 7 years of data and tons of other data fields.
> I was just wondering if Randy has ever came across it and can it be
> accessed with a subscription.
> Thank you Randy.
>
>
--
Robbie Geary
API for building customized spreadsheets (with no size constraints) with
AAII data and derived computations. As the developer of the backtester,
I'm aware that some automate this, with which I have no problems. As for
whether the whole process could be completely automated and encapsulated
into SMF functions, I have no idea, but you're certainly welcome to try..
The backtester is discussed at
https://boards.fool.com/Messages.asp?mid=&bid=100093
On Fri, Aug 16, 2019 at 9:22 AM mrpatmcginnis@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Has anyone looked at or subscribed to AAII (American Association of
> Individual Investors) "Stock Investor Pro"?
>
> I looked at Guru Focus and also felt it was pricey. AAII have a better
> priced 'weekly' update with 7 years of data and tons of other data fields.
> I was just wondering if Randy has ever came across it and can it be
> accessed with a subscription.
> Thank you Randy.
>
>
--
Robbie Geary
Thu Aug 15, 2019 6:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have a lifetime membership with AAII, since 2001. I used to have a
subscription to their Stock Investor Pro a long time ago, last used in
2009. Over 13 years, I spent about $1800 for their updates. Then I decided
I could get the information I needed from the Internet more easily. I used
to have EXCEL user-defined formulas that would extract data directly from
the SIP databases, much like how the add-in pulls in data from the
Internet. Except that the data was always available and faster to retrieve
because it was local.
In fact, I have a routine in the add-in I was initially using to create
local databases of Internet data. The RCHGetElementNumber() function even
has a parameter that would route the retrieval to the local databases
instead of retrieving it from the Internet. It made calculation a lot
faster for those data items I used often.
I also am a subscriber to Portfolio123. However, I was grandfathered in at
a lower subscription plan because I subscribed to their old Screener123
product.
On Thu, Aug 15, 2019 at 4:21 PM mrpatmcginnis@... wrote:
> Has anyone looked at or subscribed to AAII (American Association of
> Individual Investors) "Stock Investor Pro"?
>
> I looked at Guru Focus and also felt it was pricey. AAII have a better
> priced 'weekly' update with 7 years of data and tons of other data fields.
> I was just wondering if Randy has ever came across it and can it be
> accessed with a subscription.
> Thank you Randy.
>
>
>
subscription to their Stock Investor Pro a long time ago, last used in
2009. Over 13 years, I spent about $1800 for their updates. Then I decided
I could get the information I needed from the Internet more easily. I used
to have EXCEL user-defined formulas that would extract data directly from
the SIP databases, much like how the add-in pulls in data from the
Internet. Except that the data was always available and faster to retrieve
because it was local.
In fact, I have a routine in the add-in I was initially using to create
local databases of Internet data. The RCHGetElementNumber
has a parameter that would route the retrieval to the local databases
instead of retrieving it from the Internet. It made calculation a lot
faster for those data items I used often.
I also am a subscriber to Portfolio123. However, I was grandfathered in at
a lower subscription plan because I subscribed to their old Screener123
product.
On Thu, Aug 15, 2019 at 4:21 PM mrpatmcginnis@
> Has anyone looked at or subscribed to AAII (American Association of
> Individual Investors) "Stock Investor Pro"?
>
> I looked at Guru Focus and also felt it was pricey. AAII have a better
> priced 'weekly' update with 7 years of data and tons of other data fields.
> I was just wondering if Randy has ever came across it and can it be
> accessed with a subscription.
> Thank you Randy.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar