15 Messages
Digest #4312
Messages
Wed Mar 7, 2018 12:05 am (PST) . Posted by:
johnross999
I closed Excel, flushed the DNS, restarted the PC - still the same problem. On other stocks like MSFT, AMZN is fine. The problem is only with AAPL. Weird!
Wed Mar 7, 2018 2:09 am (PST) . Posted by:
"John Ross" johnross999
Randy,
Same thing:
Dates are converted using this formula =IFERROR(smfUNIX2Date(G63),"")
and formatted using AU dates.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, 7 March 2018 5:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Option Expiration Table AAPL problem
Is the problem persisting? If so, how about after running the smfForceRecalculation macro? If still not working, what do you get with:
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL","expirationDates")
On Wed, Mar 7, 2018 at 12:18 AM, johnrr9@
....
wrote:
I don't know - it is just a formatting for Australian date. I don't think it is the cause of the problems.
Same thing:
Dates are converted using this formula =IFERROR(smfUNIX2Date(G63),"")
and formatted using AU dates.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, 7 March 2018 5:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Option Expiration Table AAPL problem
Is the problem persisting? If so, how about after running the smfForceRecalculation macro? If still not working, what do you get with:
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL","
On Wed, Mar 7, 2018 at 12:18 AM, johnrr9@
....
wrote:
I don't know - it is just a formatting for Australian date. I don't think it is the cause of the problems.
Wed Mar 7, 2018 2:16 am (PST) . Posted by:
"John Ross" johnross999
MSFT is fine while AAPL is not:
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, 7 March 2018 5:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Option Expiration Table AAPL problem
Is the problem persisting? If so, how about after running the smfForceRecalculation macro? If still not working, what do you get with:
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL","expirationDates")
On Wed, Mar 7, 2018 at 12:18 AM, johnrr9@
....
wrote:
I don't know - it is just a formatting for Australian date. I don't think it is the cause of the problems.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, 7 March 2018 5:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Option Expiration Table AAPL problem
Is the problem persisting? If so, how about after running the smfForceRecalculation macro? If still not working, what do you get with:
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL","
On Wed, Mar 7, 2018 at 12:18 AM, johnrr9@
....
wrote:
I don't know - it is just a formatting for Australian date. I don't think it is the cause of the problems.
Wed Mar 7, 2018 2:52 am (PST) . Posted by:
johnross999
Looks like messages posted through Outlook are not showing pictures...
Randy,
Same thing:
Dates are converted using this formula =IFERROR(smfUNIX2Date(G63),"")
and formatted using AU dates.
MSFT is fine while AAPL is not:
Randy,
Same thing:
Dates are converted using this formula =IFERROR(smfUNIX2Da
and formatted using AU dates.
MSFT is fine while AAPL is not:
Wed Mar 7, 2018 3:04 am (PST) . Posted by:
johnross999
...and then I discovered this using a browser:the March expiry is missing...
https://finance.yahoo.com/quote/AAPL/options?p=AAPL https://finance.yahoo..com/quote/AAPL/options?p=AAPL
https://finance.yahoo.com/quote/AAPL/options?p=AAPL https://finance.yahoo..com/quote/AAPL/options?p=AAPL
Wed Mar 7, 2018 1:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Next time the market is open, try this:
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL
","expirationDates",100)
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL
","regularMarketTime",100)
Note the "expirationDates" and "regularMarketTime" return and then after a
few minutes run the smfForceRecalculation macro and see if they change..
The market times should change, but not the expiration dates.
On Wed, Mar 7, 2018 at 3:16 AM, 'John Ross' johnrr9@
....
wrote:
>
> MSFT is fine while AAPL is not:
>
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL
","expirationDates",100)
=RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/options/AAPL
","
Note the "expirationDat
few minutes run the smfForceRecalculati
The market times should change, but not the expiration dates.
On Wed, Mar 7, 2018 at 3:16 AM, 'John Ross' johnrr9@
....
wrote:
>
> MSFT is fine while AAPL is not:
>
Wed Mar 7, 2018 1:43 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Which browser? Have you tried multiple browsers? Did you try a Ctrl+F5
refresh?
On Wed, Mar 7, 2018 at 4:04 AM, johnrr9@
...
wrote:
>
> ....and then I discovered this using a browser:the March expiry is
> missing...
> https://finance.yahoo.com/quote/AAPL/options?p=AAPL
>
refresh?
On Wed, Mar 7, 2018 at 4:04 AM, johnrr9@
...
wrote:
>
> ....and then I discovered this using a browser:the March expiry is
> missing...
> https://finance.yahoo.com/quote/AAPL/options?p=AAPL
>
Wed Mar 7, 2018 1:49 pm (PST) . Posted by:
johnross999
Yes I tried it on few different browsers on my PC - IE, Edge, Firefox.
I also deleted all the cookies before trying it on IE and Edge.
Then on my iPhone with Safari and Firefox connected directly on carrier without WI-FI. Both returned the same results!
I also deleted all the cookies before trying it on IE and Edge.
Then on my iPhone with Safari and Firefox connected directly on carrier without WI-FI. Both returned the same results!
Sun Mar 11, 2018 1:21 am (PST) . Posted by:
nik_rizzi
Hi Randy,
I everytime be grateful for fantastic add-in. It solved all my problems everytime.
Now I'm moving to a MAC and I've excel for Mac installed.
I'm not a full functionalities user, I only use RCHGetTableCell.
If you want have a tester for MAC add-in, I can propose me.
Thanks a lot!
I everytime be grateful for fantastic add-in. It solved all my problems everytime.
Now I'm moving to a MAC and I've excel for Mac installed.
I'm not a full functionalities user, I only use RCHGetTableCell.
If you want have a tester for MAC add-in, I can propose me.
Thanks a lot!
Mon Mar 12, 2018 11:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can see if the instructions in this thread work for you, but otherwise,
there are no ongoing developments for the Mac. I don't have one, and have
no experience with them.
On Sun, Mar 11, 2018 at 2:01 AM, nicola_rizzi@
...
wrote:
> I everytime be grateful for fantastic add-in. It solved all my problems
> everytime.
>
> Now I'm moving to a MAC and I've excel for Mac installed.
>
> I'm not a full functionalities user, I only use RCHGetTableCell.
>
> If you want have a tester for MAC add-in, I can propose me.
>
>
>
there are no ongoing developments for the Mac. I don't have one, and have
no experience with them.
On Sun, Mar 11, 2018 at 2:01 AM, nicola_rizzi@
...
wrote:
> I everytime be grateful for fantastic add-in. It solved all my problems
> everytime.
>
> Now I'm moving to a MAC and I've excel for Mac installed.
>
> I'm not a full functionalities user, I only use RCHGetTableCell.
>
> If you want have a tester for MAC add-in, I can propose me.
>
>
>
Mon Mar 12, 2018 10:57 am (PDT) . Posted by:
"Leo Bueno" leobueno
First, a big thanks to Randy for his work on the add-in and the extensive support he provides to us. I appreciate his generosity, but suggest that perhaps he consider creating a membership system, where we can pay anywhere between a modest to a reasonable annual fee for his work. Hey, we are not humanitarian charities and neither should he be! Now on to the technical issue.
I am back to using the add-in since *before* the Yahoo change on 2 November 2017, so my worksheet no longer works. My needs are simple; I only require a current price and the company name (to confirm the price matches the ticker, as a verification check).
I realize I need to use the smfGetYahooPortfolioView function.
I have attached a sample worksheet with three tickers to illustrate my problem.
Say I place a ticker, e.g., IBM, in cell A2.
This formula, =smfGetYahooPortfolioView(A2,"15"), should produce the value of the price, right?
However, no matter what I do, I get #NAME? as the result
I am using Excel 2010 under Windows 7.
Help please. Thanks.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, November 02, 2017 5:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo quotes
If you only do a few, you can do:
=smfGetYahooPortfolioView("MMM","15")
Otherwise, if you do a number of different fields and/or tickers, please do the array-entered version. Otherwise, it just encourages Yahoo to shut the process down, because they get inundated with requests.
On Thu, Nov 2, 2017 at 2:13 PM, smmarder@
...
wrote:
I also appreciate all of your fine work. I have relied on the Yahoo quotes simply to pull down a stock quote into a singe cell in my spreadsheet and then use that to calculate a number of other cells. Is there any other way to pull down a quote into a excel cell? or are we out of luck?
I am back to using the add-in since *before* the Yahoo change on 2 November 2017, so my worksheet no longer works. My needs are simple; I only require a current price and the company name (to confirm the price matches the ticker, as a verification check).
I realize I need to use the smfGetYahooPortfolioView function.
I have attached a sample worksheet with three tickers to illustrate my problem.
Say I place a ticker, e.g., IBM, in cell A2.
This formula, =smfGetYahooPortfolioView(A2,"15"), should produce the value of the price, right?
However, no matter what I do, I get #NAME? as the result
I am using Excel 2010 under Windows 7.
Help please. Thanks.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, November 02, 2017 5:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo quotes
If you only do a few, you can do:
=smfGetYahooPortfol
Otherwise, if you do a number of different fields and/or tickers, please do the array-entered version. Otherwise, it just encourages Yahoo to shut the process down, because they get inundated with requests.
On Thu, Nov 2, 2017 at 2:13 PM, smmarder@
...
wrote:
I also appreciate all of your fine work. I have relied on the Yahoo quotes simply to pull down a stock quote into a singe cell in my spreadsheet and then use that to calculate a number of other cells. Is there any other way to pull down a quote into a excel cell? or are we out of luck?
Mon Mar 12, 2018 11:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
#NAME? means EXCEL can't find the function (or a defined name), so if
you're getting it when you enter a new formula, the most likely reason is
that the add-in isn't activated within the add-in manager.
To verify that, open up a new worksheet and see what happens with:
=RCHGetElementNumber("Version")
On Mon, Mar 12, 2018 at 10:57 AM, Leo Bueno Leo@
...
wrote:
>
>
> I am back to using the add-in since *before* the Yahoo change on 2
> November 2017, so my worksheet no longer works. My needs are simple; I only
> require a current price and the company name (to confirm the price matches
> the ticker, as a verification check).
>
>
>
> I realize I need to use the smfGetYahooPortfolioView function.
>
>
>
> I have attached a sample worksheet with three tickers to illustrate my
> problem.
>
>
>
> Say I place a ticker, e.g., IBM, in cell A2.
>
>
>
> This formula, =smfGetYahooPortfolioView(A2,"15"), should produce the
> value of the price, right?
>
>
>
> However, no matter what I do, I get #NAME? as the result
>
>
>
> I am using Excel 2010 under Windows 7.
>
>
>
> Help please. Thanks.
>
you're getting it when you enter a new formula, the most likely reason is
that the add-in isn't activated within the add-in manager.
To verify that, open up a new worksheet and see what happens with:
=RCHGetElementNumbe
On Mon, Mar 12, 2018 at 10:57 AM, Leo Bueno Leo@
...
wrote:
>
>
> I am back to using the add-in since *before* the Yahoo change on 2
> November 2017, so my worksheet no longer works. My needs are simple; I only
> require a current price and the company name (to confirm the price matches
> the ticker, as a verification check).
>
>
>
> I realize I need to use the smfGetYahooPortfoli
>
>
>
> I have attached a sample worksheet with three tickers to illustrate my
> problem.
>
>
>
> Say I place a ticker, e.g., IBM, in cell A2.
>
>
>
> This formula, =smfGetYahooPortfol
> value of the price, right?
>
>
>
> However, no matter what I do, I get #NAME? as the result
>
>
>
> I am using Excel 2010 under Windows 7.
>
>
>
> Help please. Thanks.
>
Mon Mar 12, 2018 11:41 am (PDT) . Posted by:
"Leo Bueno" leobueno
Using =RCHGetElementNumber("Version") sometimes gets me
Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; ; 1)
and others the cell returns
#NAME?
I can't figure out why =RCHGetElementNumber("Version") sometimes works and sometimes does not.
Related question, for when the add-in decides to work, where is the files with the parameters for the fields? For example, 15 is the price, what number is the company name, etc.
Thanks again.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, March 12, 2018 2:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] No matter how I do it, I get a #NAME?
#NAME? means EXCEL can't find the function (or a defined name), so if you're getting it when you enter a new formula, the most likely reason is that the add-in isn't activated within the add-in manager.
To verify that, open up a new worksheet and see what happens with:
=RCHGetElementNumber("Version")
On Mon, Mar 12, 2018 at 10:57 AM, Leo Bueno Leo@
...
wrote:
I am back to using the add-in since *before* the Yahoo change on 2 November 2017, so my worksheet no longer works. My needs are simple; I only require a current price and the company name (to confirm the price matches the ticker, as a verification check).
I realize I need to use the smfGetYahooPortfolioView function.
I have attached a sample worksheet with three tickers to illustrate my problem.
Say I place a ticker, e.g., IBM, in cell A2.
This formula, =smfGetYahooPortfolioView(A2,"15"), should produce the value of the price, right?
However, no matter what I do, I get #NAME? as the result
I am using Excel 2010 under Windows 7.
Help please. Thanks.
Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; ; 1)
and others the cell returns
#NAME?
I can't figure out why =RCHGetElementNumber("Version") sometimes works and sometimes does not.
Related question, for when the add-in decides to work, where is the files with the parameters for the fields? For example, 15 is the price, what number is the company name, etc.
Thanks again.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, March 12, 2018 2:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] No matter how I do it, I get a #NAME?
#NAME? means EXCEL can't find the function (or a defined name), so if you're getting it when you enter a new formula, the most likely reason is that the add-in isn't activated within the add-in manager.
To verify that, open up a new worksheet and see what happens with:
=RCHGetElementNumbe
On Mon, Mar 12, 2018 at 10:57 AM, Leo Bueno Leo@
...
wrote:
I am back to using the add-in since *before* the Yahoo change on 2 November 2017, so my worksheet no longer works. My needs are simple; I only require a current price and the company name (to confirm the price matches the ticker, as a verification check).
I realize I need to use the smfGetYahooPortfoli
I have attached a sample worksheet with three tickers to illustrate my problem.
Say I place a ticker, e.g., IBM, in cell A2.
This formula, =smfGetYahooPortfol
However, no matter what I do, I get #NAME? as the result
I am using Excel 2010 under Windows 7.
Help please. Thanks.
Mon Mar 12, 2018 12:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you have something that isn't allowing the add-in to be loaded.
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
The documentation of the fields for smfGetYahooPortfolioView() is in the
template. When using that function, please do an array-entered function to
get all of your data with a single request. Don't do individual functions
for each individual price or data item. I don't want Yahoo to unplug the
capability. I toyed with the idea of keeping this new function private so
it didn't get overused.
On Mon, Mar 12, 2018 at 11:41 AM, Leo Bueno Leo@
...
wrote:
>
> Using =RCHGetElementNumber("Version") sometimes gets me
>
> Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 14.0; ; ; 1)
>
>
>
> and others the cell returns
>
> #NAME?
>
>
>
> I can't figure out why =RCHGetElementNumber("Version") sometimes works
> and sometimes does not.
>
>
>
> Related question, for when the add-in decides to work, where is the files
> with the parameters for the fields? For example, 15 is the price, what
> number is the company name, etc.
>
>
>
> Thanks again.
>
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
The documentation of the fields for smfGetYahooPortfoli
template. When using that function, please do an array-entered function to
get all of your data with a single request. Don't do individual functions
for each individual price or data item. I don't want Yahoo to unplug the
capability. I toyed with the idea of keeping this new function private so
it didn't get overused.
On Mon, Mar 12, 2018 at 11:41 AM, Leo Bueno Leo@
...
wrote:
>
> Using =RCHGetElementNumbe
>
> Stock Market Functions add-in, Version 2.1.2018.01.
> Windows (32-bit) NT 6.01; 14.0; ; ; 1)
>
>
>
> and others the cell returns
>
> #NAME?
>
>
>
> I can't figure out why =RCHGetElementNumbe
> and sometimes does not.
>
>
>
> Related question, for when the add-in decides to work, where is the files
> with the parameters for the fields? For example, 15 is the price, what
> number is the company name, etc.
>
>
>
> Thanks again.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar