15 Messages
Digest #4311
Messages
Mon Mar 5, 2018 1:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Your security cookie may be good for the browser, but how about for the IE
object inside EXCEL (alt+d+d+w)? Did you download the file using that IE
object? It would be the one the add-in is using.
This worked for me:
=smfGetGuruFocusCSVItem("AAPL","Revenue per Share",22)
This should show you the raw data from the CSV file for AAPL:
=RCHGetWebData("
https://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
What I see from that function starts out like this:
Downloaded from http://www.GuruFocus.com on 2018-03-5 at 15:49(CST), Monday
Filename: AAPL.csv...
If you're not logged it, it should be returning the text of a web page that
indicates the file is part of the premium portion of GufuFocus.
On Mon, Mar 5, 2018 at 2:38 PM, codyklein@
...
wrote:
>
>
> I can download the CSV file so I guess that means my security cookie is
> good, the site seems to be working fine.
>
> This is what I have as an example:
> =
>
> smfGetGuruFocusCSVItem(Ticker,$B6,C$5) where Ticker is AAPL, $B6
> is Revenue per Share and C$5 is a number between 22 and 32. Data is blank,
> same for any ticker. Any ideas?
>
>
>
>
>
object inside EXCEL (alt+d+d+w)? Did you download the file using that IE
object? It would be the one the add-in is using.
This worked for me:
=smfGetGuruFocusCSVItem("AAPL","Revenue per Share",22)
This should show you the raw data from the CSV file for AAPL:
=RCHGetWebData("
https://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
What I see from that function starts out like this:
Downloaded from http://www.GuruFocus.com on 2018-03-5 at 15:49(CST), Monday
Filename: AAPL.csv...
If you're not logged it, it should be returning the text of a web page that
indicates the file is part of the premium portion of GufuFocus.
On Mon, Mar 5, 2018 at 2:38 PM, codyklein@
...
wrote:
>
>
> I can download the CSV file so I guess that means my security cookie is
> good, the site seems to be working fine.
>
> This is what I have as an example:
> =
>
> smfGetGuruFocusCSVI
> is Revenue per Share and C$5 is a number between 22 and 32. Data is blank,
> same for any ticker. Any ideas?
>
>
>
>
>
Mon Mar 5, 2018 1:56 pm (PST) . Posted by:
codyklein
Ok it works on my laptop so I'm at a loss what is going on with the desktop. Any advice on what and how to check? I logged out of Guru then logged back in with IE and that didn't work.
Mon Mar 5, 2018 2:02 pm (PST) . Posted by:
codyklein
=RCHGetWebData("https://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL https://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
yielded the following: <meta http-equiv="refresh" content="0; URL=http://www.gurufocus.com/membership/upgrade.php?redir=/download_financials_in_CSV.php?symbol=AAPL">
Not sure what it means?
yielded the following: <meta http-equiv="refresh" content="0; URL=http://www.gurufocus.com/membership/upgrade.php?redir=/download_financials_in_CSV.php?symbol=AAPL">
Not sure what it means?
Mon Mar 5, 2018 2:22 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You should log in with IE object within EXCEL (alt+d+d+w). That's the
security cookie that is needed.
On Mon, Mar 5, 2018 at 2:56 PM, codyklein@
...
wrote:
>
> Ok it works on my laptop so I'm at a loss what is going on with the
> desktop. Any advice on what and how to check? I logged out of Guru then
> logged back in with IE and that didn't work.
>
>
>
security cookie that is needed.
On Mon, Mar 5, 2018 at 2:56 PM, codyklein@
...
wrote:
>
> Ok it works on my laptop so I'm at a loss what is going on with the
> desktop. Any advice on what and how to check? I logged out of Guru then
> logged back in with IE and that didn't work.
>
>
>
Mon Mar 5, 2018 2:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It means you don't have the security cookie available for the IE object
within EXCEL. On your computer, that must be separate from the IE browser
cookies.
On Mon, Mar 5, 2018 at 3:01 PM, codyklein@
...
wrote:
>
> =RCHGetWebData("https://www.gurufocus.com/download_
> financials_in_CSV.php?symbol=AAPL")
>
> yielded the following: <meta http-equiv="refresh" content="0; URL=
> http://www.gurufocus.com/membership/upgrade.php?redir=/
> download_financials_in_CSV.php?symbol=AAPL";>
> Not sure what it means?
>
>
within EXCEL. On your computer, that must be separate from the IE browser
cookies.
On Mon, Mar 5, 2018 at 3:01 PM, codyklein@
...
wrote:
>
> =RCHGetWebData("https://www.gurufocus.com/download_
> financials_in_CSV.php?symbol=AAPL")
>
> yielded the following: <meta http-equiv="refresh" content="0; URL=
> http://www.gurufocus.com/membership/upgrade.php?redir=/
> download_financials
> Not sure what it means?
>
>
Mon Mar 5, 2018 2:36 pm (PST) . Posted by:
codyklein
I clicked no to all the script popups then yes a second time. It won't let me enter anything in the username and password boxes. I click on it but it doesn't let me in the input boxes? Any ideas how to get around this?
Mon Mar 5, 2018 2:43 pm (PST) . Posted by:
codyklein
Success, thank you Randy. I just used the task manger to close excel since it locked up and repeated this procedure until for whatever reason it let me in.
Mon Mar 5, 2018 2:02 pm (PST) . Posted by:
friedman_steve
Randy,
I have a spreadsheet with many links. Occasionally I have to run the smfForceRecalculation to have the spreadsheet work correctly again (specifically for a small part of the sheet only). It works great, but on the very busy spreadsheet, can sometimes take long time to calculate (over 1 minute). Is there a way to only force the recalculation to specific cells (as opposed to entire worksheet)?
Thanks in advance for any help. Fantastic product.
I have a spreadsheet with many links. Occasionally I have to run the smfForceRecalculati
Thanks in advance for any help. Fantastic product.
Mon Mar 5, 2018 2:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
On the context menu (right mouse click on a selected range in EXCEL), there
is an SMF menu option of "Recalculate selection", which would only
recalculate the selected range.
But it's a "dirty" recalculation, so any formulas outside the range that
refer within the selected range would not be updated.
On Mon, Mar 5, 2018 at 3:02 PM, friedman_steve@
...
wrote:
> I have a spreadsheet with many links. Occasionally I have to run the
> smfForceRecalculation to have the spreadsheet work correctly again
> (specifically for a small part of the sheet only). It works great, but on
> the very busy spreadsheet, can sometimes take long time to calculate (over
> 1 minute). Is there a way to only force the recalculation to specific
> cells (as opposed to entire worksheet)?
>
> Thanks in advance for any help. Fantastic product.
>
is an SMF menu option of "Recalculate selection"
recalculate the selected range.
But it's a "dirty" recalculation, so any formulas outside the range that
refer within the selected range would not be updated.
On Mon, Mar 5, 2018 at 3:02 PM, friedman_steve@
...
wrote:
> I have a spreadsheet with many links. Occasionally I have to run the
> smfForceRecalculati
> (specifically for a small part of the sheet only). It works great, but on
> the very busy spreadsheet, can sometimes take long time to calculate (over
> 1 minute). Is there a way to only force the recalculation to specific
> cells (as opposed to entire worksheet)?
>
> Thanks in advance for any help. Fantastic product.
>
Tue Mar 6, 2018 10:16 pm (PST) . Posted by:
johnross999
I am sending this message again - not sure it was sent last time.
Hi Randy,
I am using this formula =smfGetOptionExpirations(J3,H8) to extract the Options Expiration Table for AAPL where J3 = Y and H8 = AAPL. I am receiving all the dates but the March 2018 expiration (16032018). It is happening most days in the last month. Only once I received the March expiration date.
The extracted table is attached.
Any idea what is causing this problem?
Tx
Hi Randy,
I am using this formula =smfGetOptionExpira
The extracted table is attached.
Any idea what is causing this problem?
Tx
Tue Mar 6, 2018 10:17 pm (PST) . Posted by:
johnross999
Hi Randy,
I am using this formula =smfGetOptionExpirations(J3,H8) table to extract the Options Expiration Table for AAPL where J3 is Y and H8 is AAPL. I am receiving all the dates but the March 2018 expiration (16032018). It is happening for most of the days in the last month. Only once I received the March date. This is happening ONLY with Apple options. I am using the latest RCH_Stock_Market_Functions-2.1.2018.01.24 version.
The extracted table is attached.
Any idea why this is happening?
Tx
I am using this formula =smfGetOptionExpira
The extracted table is attached.
Any idea why this is happening?
Tx
Tue Mar 6, 2018 11:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It appears to be working fine here. This:
=smfGetOptionExpirations("AAPL","Y")
....is returning this:
2018-03-09
2018-03-23
2018-03-29
2018-04-06
2018-04-13
2018-04-20
2018-05-18
2018-06-15
2018-08-17
2018-09-21
2018-10-19
2018-11-16
2019-01-18
2019-06-21
2020-01-17
2020-06-19
Hopefully a temporary Yahoo glitch? I know they were missing a few
expiration dates last week. However, your date formatting concerns me. I'm
hoping a difference in system date usage that isn't causing issues.
On Tue, Mar 6, 2018 at 10:58 PM, johnrr9@
...
wrote:
> I am using this formula =smfGetOptionExpirations(J3,H8) table to extract
> the Options Expiration Table for AAPL where J3 is Y and H8 is AAPL. I am
> receiving all the dates but the March 2018 expiration (16032018). It is
> happening for most of the days in the last month. Only once I received the
> March date. This is happening ONLY with Apple options. I am using the
> latest RCH_Stock_Market_Functions-2.1.2018.01.24 version.
> The extracted table is attached.
>
> Any idea why this is happening?
>
>
>
=smfGetOptionExpira
....is returning this:
2018-03-09
2018-03-23
2018-03-29
2018-04-06
2018-04-13
2018-04-20
2018-05-18
2018-06-15
2018-08-17
2018-09-21
2018-10-19
2018-11-16
2019-01-18
2019-06-21
2020-01-17
2020-06-19
Hopefully a temporary Yahoo glitch? I know they were missing a few
expiration dates last week. However, your date formatting concerns me. I'm
hoping a difference in system date usage that isn't causing issues.
On Tue, Mar 6, 2018 at 10:58 PM, johnrr9@
...
wrote:
> I am using this formula =smfGetOptionExpira
> the Options Expiration Table for AAPL where J3 is Y and H8 is AAPL. I am
> receiving all the dates but the March 2018 expiration (16032018). It is
> happening for most of the days in the last month. Only once I received the
> March date. This is happening ONLY with Apple options. I am using the
> latest RCH_Stock_Market_
> The extracted table is attached.
>
> Any idea why this is happening?
>
>
>
Tue Mar 6, 2018 11:19 pm (PST) . Posted by:
johnross999
I don't know - it is just a formatting for Australian date.. I don't think it is the cause of the problems.
Tue Mar 6, 2018 11:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
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.
>
>
>
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.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar