Messages In This Digest (10 Messages)
- 1a.
- Re: RCHGetElement Number 13629;ReutersRat;Comparison Ratios From: bleushin19
- 3a.
- Re: Use page that requires login? From: Craig
- 3b.
- Re: Use page that requires login? From: Randy Harmelink
- 3c.
- Re: Use page that requires login? From: Martin Topper
- 4a.
- Quotes for ^VIX options From: n808
- 4b.
- Re: Quotes for ^VIX options From: Randy Harmelink
- 5a.
- Historical quotes from google finance From: fdtseng
- 5b.
- Re: Historical quotes from google finance From: Randy Harmelink
Messages
- 1a.
-
Re: RCHGetElement Number 13629;ReutersRat;Comparison Ratios
Posted by: "bleushin19" bleushin19@yahoo.com bleushin19
Wed Mar 14, 2012 2:41 am (PDT)
Thanks..Found it..
Kinda get blinded by too many letters though.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It appears Reuters no longer carries them. MSN seems to -- check out this
> template:
>
> SMF-Template-MSN-Key-Ratio- Comparisons. xls
>
> On Wed, Mar 14, 2012 at 1:19 AM, bleushin19 <bleushin19@...> wrote:
>
> > Is there any update on reuters.com for their S&P 500? or are there any
> > sites that have these functions too..Please tell me.
> >
>
- 2a.
-
Mac?
Posted by: "Jerry Peters" jerrytpeters@gmail.com smthbrk206
Wed Mar 14, 2012 8:08 am (PDT)
Hello,
Is there any way to make the add-in work in Excel on a Mac? I believe the
answer is no, but thought I would ask in case I have missed it in the notes.
Thank you in advance,
Jerry
- 2b.
-
Re: Mac?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Mar 14, 2012 12:24 pm (PDT)
I know nothing about the Mac. But, as I understand it, you'd need to run it
in under a Windows emulation environment on the Mac.
On Wed, Mar 14, 2012 at 8:04 AM, Jerry Peters <jerrytpeters@gmail.com >wrote:
>
> Is there any way to make the add-in work in Excel on a Mac? I believe the
> answer is no, but thought I would ask in case I have missed it in the notes.
>
>
- 3a.
-
Re: Use page that requires login?
Posted by: "Craig" craig.sander@comcast.net c1sander
Wed Mar 14, 2012 9:42 am (PDT)
Randy,
I haven't been able to get real-time quotes from Etrade, even when I try smfforcerecalculation. It just doesn't seem to want to recalculate. However, I do have another clue as to what is going on. Even when I don't sign in and just try to get delayed quotes, they don't update. Here is the formula that I am using for a test:
=RCHGetTableCell("https://us.etrade. com/e/t/investin ",3,"Underlying Quote",,,,2)gandtrading/ optionsnapshot_ p?content= 3&ochain= 1&prod=AAPL- -120519P00560000 :CINC:OPTN
This gives the price of the underlying stock for the option, which changes frequently so you can tell if it is being updated. It seems that it only gives me new (delayed) information the first time I enter the formula. When I force the recalculation it doesn't change. I can even open a new spreadsheet (without closing down Excel) and copy in the formula and it still gives me the same answer. If I close Excel, reopen it, and then enter the formula in a new sheet I do get updated information.
Any ideas?
Thanks,
Craig
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Did you run the smfForceRecalculation macro? It would still be extracting
> data from the originally retrieved web page (i.e. PRE-log in) unless you
> told the add-in to get a new copy of the web page AFTER the log in.
>
> Also, you might need to change your Internet Options, to make sure IE is
> always getting new content. See the new smfForceRecalculation items in the
> "Links" area of the group for more information.
>
> On Tue, Mar 13, 2012 at 1:10 PM, Craig <craig.sander@...> wrote:
>
> > I tried logging in from IE. This didn't work. It still gave me delayed
> > quotes.
> >
>
- 3b.
-
Re: Use page that requires login?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Mar 14, 2012 12:23 pm (PDT)
Did you read the two smfForceRecalculation items in the "Links" area of the
group, as I suggested? They discuss the possible situations you're running
into.
When I use this formula to get the last traded time of the underlying
equity:
=smfGetTagContent("
https://us.etrade.com/e/t/investin ","div",-1,"gandtrading/ optionsnapshot_ p?content= 3&ochain= 1&prod=AAPL- -120519P00560000 :CINC:OPTN
as of "," as of ")
...it does update when I use smfForceRecalculation. From what I see,
though, I suspect the delayed quote on the underlying isn't changed
continuously. On the delayed quotes, it may only be updated once per minute
or so.
The other thing to do is use the URL from the function in the EXCEL Web
Query dialog, to see if you are getting real-time or delayed quotes there.
That will tell you whether you are logged in properly for the add-in to get
real-time quotes. The keyboard shortcut is alt+d+d+w
Putting the formula in a new workbook won't change anything -- you're still
dealing with the same copy of the add-in, and its same saved copy of the
web page. Closing EXCEL and restarting EXCEL should have the same result as
smfForceRecalculation -- the add-in saved area is reset, and a new copy of
the web page is retrieved.
On Wed, Mar 14, 2012 at 9:42 AM, Craig <craig.sander@comcast.net > wrote:
>
> I haven't been able to get real-time quotes from Etrade, even when I try
> smfforcerecalculation. It just doesn't seem to want to recalculate.
> However, I do have another clue as to what is going on. Even when I don't
> sign in and just try to get delayed quotes, they don't update. Here is the
> formula that I am using for a test:
>
> =RCHGetTableCell("
> https://us.etrade.com/e/t/investin ",3,"Underlyinggandtrading/ optionsnapshot_ p?content= 3&ochain= 1&prod=AAPL- -120519P00560000 :CINC:OPTN
> Quote",,,,2)
>
> This gives the price of the underlying stock for the option, which changes
> frequently so you can tell if it is being updated. It seems that it only
> gives me new (delayed) information the first time I enter the formula.
> When I force the recalculation it doesn't change. I can even open a new
> spreadsheet (without closing down Excel) and copy in the formula and it
> still gives me the same answer. If I close Excel, reopen it, and then
> enter the formula in a new sheet I do get updated information.
>
> Any ideas?
>
- 3c.
-
Re: Use page that requires login?
Posted by: "Martin Topper" mtopper@yahoo.com mtopper
Wed Mar 14, 2012 12:25 pm (PDT)
=RCHGetTableCell("https://us.etrade. com/e/t/investin ",3,"Underlying Quote",,,,2)gandtrading/ optionsnapshot_ p?content= 3&ochain= 1&prod=AAPL- -120519P00560000 :CINC:OPTN
your formula refreshes every time i invoke the smfforcerecalc
I have the macro attached to a button so i can refresh VERY quickly. and it changes the value each time.
Marty
_____________________ _________ __
From: Craig <craig.sander@comcast.net >
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 14, 2012 12:42 PM
Subject: [smf_addin] Re: Use page that requires login?
Randy,
I haven't been able to get real-time quotes from Etrade, even when I try smfforcerecalculation. It just doesn't seem to want to recalculate. However, I do have another clue as to what is going on. Even when I don't sign in and just try to get delayed quotes, they don't update. Here is the formula that I am using for a test:
=RCHGetTableCell("https://us.etrade. com/e/t/investin ",3,"Underlying Quote",,,,2)gandtrading/ optionsnapshot_ p?content= 3&ochain= 1&prod=AAPL- -120519P00560000 :CINC:OPTN
This gives the price of the underlying stock for the option, which changes frequently so you can tell if it is being updated. It seems that it only gives me new (delayed) information the first time I enter the formula. When I force the recalculation it doesn't change. I can even open a new spreadsheet (without closing down Excel) and copy in the formula and it still gives me the same answer. If I close Excel, reopen it, and then enter the formula in a new sheet I do get updated information.
Any ideas?
Thanks,
Craig
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Did you run the smfForceRecalculation macro? It would still be extracting
> data from the originally retrieved web page (i.e. PRE-log in) unless you
> told the add-in to get a new copy of the web page AFTER the log in.
>
> Also, you might need to change your Internet Options, to make sure IE is
> always getting new content. See the new smfForceRecalculation items in the
> "Links" area of the group for more information.
>
> On Tue, Mar 13, 2012 at 1:10 PM, Craig <craig.sander@...> wrote:
>
> > I tried logging in from IE. This didn't work. It still gave me delayed
> > quotes.
> >
>
- 4a.
-
Quotes for ^VIX options
Posted by: "n808" karl.lillevold@gmail.com n808
Wed Mar 14, 2012 12:39 pm (PDT)
Hi, I am using SMF Addins to get quotes for an OptionsTracker spreadsheet. I don't know much about how smf_addins actually works, but the spreadsheet uses its functions. Usually I enter the underlying stock quote, and the macros do their job.
However, I traded options for VIX, or ^VIX on Yahoo. There is no actual underlying stock, only the options, and if I enter VIX, smf_addins finds nothing. If I enter ^VIX it finds the index price, but no option prices, even though they are listed on Yahoo:
http://finance.yahoo.com/ q/op?s=%5EVIX+ Options
Any suggestions?
- 4b.
-
Re: Quotes for ^VIX options
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Mar 14, 2012 12:46 pm (PDT)
You can't use the smfGetOptionQuotes() function, because Yahoo doesn't
follow the standard of using the underlying ticker symbol as the start of
their option symbol. However, you could use RCHGetTableCell() functions or
RCHGetHTMLTable() functions to grab the data.
I decided not to handle the options on indexes, because each was different.
For example, ^GSPC is the ticker symbol for the S&P 500 index, but options
on the index are prefixed with "SPX".
On Wed, Mar 14, 2012 at 12:39 PM, n808 <karl.lillevold@gmail.com > wrote:
> Hi, I am using SMF Addins to get quotes for an OptionsTracker spreadsheet.
> I don't know much about how smf_addins actually works, but the spreadsheet
> uses its functions. Usually I enter the underlying stock quote, and the
> macros do their job.
>
> However, I traded options for VIX, or ^VIX on Yahoo. There is no actual
> underlying stock, only the options, and if I enter VIX, smf_addins finds
> nothing. If I enter ^VIX it finds the index price, but no option prices,
> even though they are listed on Yahoo:
>
> http://finance.yahoo.com/ q/op?s=%5EVIX+ Options
>
> Any suggestions?
>
- 5a.
-
Historical quotes from google finance
Posted by: "fdtseng" e11years@gmail.com fdtseng
Wed Mar 14, 2012 9:47 pm (PDT)
Yahoo doesn't have historical data for some Hong Kong tickers while Google Finance has. However there is no option to download historical data in google for HK stocks, the data is provided in separate tables with a maximum of 30 entries each (can be increased to 200 by directly changing the url).
Is there something similar to RCHGetYahooHistory for google?
The data..
http://www.google.com/finance/ historical? cid=674153& startdate= Mar+17%2C+ 2001&enddate= Mar+15%2C+ 2012&num= 30
Thanks
- 5b.
-
Re: Historical quotes from google finance
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Mar 14, 2012 10:15 pm (PDT)
Since Google doesn't offer a CSV file for that stock, your only option of
getting their data would be to grab it displayed page by displayed page.
For those stocks that Google does offer a CSV file of historical quotes,
the smfGetCSVFile() function can be used to grab all of the data -- see the
message archives of the group for examples.
On Wed, Mar 14, 2012 at 9:47 PM, fdtseng <e11years@gmail.com > wrote:
> Yahoo doesn't have historical data for some Hong Kong tickers while Google
> Finance has. However there is no option to download historical data in
> google for HK stocks, the data is provided in separate tables with a
> maximum of 30 entries each (can be increased to 200 by directly changing
> the url).
>
> Is there something similar to RCHGetYahooHistory for google?
>
> The data..
>
>
> http://www.google.com/finance/ historical? cid=674153& startdate= Mar+17%2C+ 2001&enddate= Mar+15%2C+ 2012&num= 30
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar