15 Messages
Digest #3016
Messages
Sun Mar 23, 2014 2:56 am (PDT) . Posted by:
"Muhamand Wilkes" 506a0b14356aab29d46fcd963b5d7ce2
Hello,
I would like to take the ticker symbol for an option and return the current
bid to a cell. Does anyone have a working example I can use?
V/r,
Mo
I would like to take the ticker symbol for an option and return the current
bid to a cell. Does anyone have a working example I can use?
V/r,
Mo
Sun Mar 23, 2014 3:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You should use smfGetOptionQuotes(). For example:
=smfGetOptionQuotes("MMM 3/28 2014 $134 Call","b",,"Y")
Note that Yahoo is currently missing options quotes on some equities, such
as SPY.
On Sun, Mar 23, 2014 at 2:30 AM, Muhamand Wilkes
<muhamand.wilkes@gmail.com>wrote:
>
> I would like to take the ticker symbol for an option and return the
> current bid to a cell. Does anyone have a working example I can use?
>
=smfGetOptionQuotes("MMM 3/28 2014 $134 Call","b",,"Y")
Note that Yahoo is currently missing options quotes on some equities, such
as SPY.
On Sun, Mar 23, 2014 at 2:30 AM, Muhamand Wilkes
<muhamand.wilkes@gmail.com>wrote:
>
> I would like to take the ticker symbol for an option and return the
> current bid to a cell. Does anyone have a working example I can use?
>
Sun Mar 23, 2014 3:12 am (PDT) . Posted by:
"Muhamand Wilkes" 506a0b14356aab29d46fcd963b5d7ce2
Thanks Randy,
I am trying to get the bid for ARO Jan 16 7.00 Call. When I modify it to
your format (ARO 1/22 2016 $7 Call) but no success.. Am I doing something
wrong?
On Sun, Mar 23, 2014 at 6:00 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>
> You should use smfGetOptionQuotes(). For example:
>
> =smfGetOptionQuotes("MMM 3/28 2014 $134 Call","b",,"Y")
>
> Note that Yahoo is currently missing options quotes on some equities, such
> as SPY.
>
>
> On Sun, Mar 23, 2014 at 2:30 AM, Muhamand Wilkes <
> muhamand.wilkes@gmail.com> wrote:
>
>>
>> I would like to take the ticker symbol for an option and return the
>> current bid to a cell. Does anyone have a working example I can use?
>>
>
>
>
I am trying to get the bid for ARO Jan 16 7.00 Call. When I modify it to
your format (ARO 1/22 2016 $7 Call) but no success.. Am I doing something
wrong?
On Sun, Mar 23, 2014 at 6:00 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>
> You should use smfGetOptionQuotes(). For example:
>
> =smfGetOptionQuotes("MMM 3/28 2014 $134 Call","b",,"Y")
>
> Note that Yahoo is currently missing options quotes on some equities, such
> as SPY.
>
>
> On Sun, Mar 23, 2014 at 2:30 AM, Muhamand Wilkes <
> muhamand.wilkes@gmail.com> wrote:
>
>>
>> I would like to take the ticker symbol for an option and return the
>> current bid to a cell. Does anyone have a working example I can use?
>>
>
>
>
Sun Mar 23, 2014 3:28 am (PDT) . Posted by:
"Muhamand Wilkes" 506a0b14356aab29d46fcd963b5d7ce2
Randy,
My mistake, my dates are wrong. I have it working now, thanks for the
support!
Mo
On Sun, Mar 23, 2014 at 6:12 AM, Muhamand Wilkes
<muhamand.wilkes@gmail.com>wrote:
> Thanks Randy,
>
> I am trying to get the bid for ARO Jan 16 7.00 Call. When I modify it to
> your format (ARO 1/22 2016 $7 Call) but no success.. Am I doing something
> wrong?
>
>
> On Sun, Mar 23, 2014 at 6:00 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>>
>>
>> You should use smfGetOptionQuotes(). For example:
>>
>> =smfGetOptionQuotes("MMM 3/28 2014 $134 Call","b",,"Y")
>>
>> Note that Yahoo is currently missing options quotes on some equities,
>> such as SPY.
>>
>>
>> On Sun, Mar 23, 2014 at 2:30 AM, Muhamand Wilkes <
>> muhamand.wilkes@gmail.com> wrote:
>>
>>>
>>> I would like to take the ticker symbol for an option and return the
>>> current bid to a cell. Does anyone have a working example I can use?
>>>
>>
>>
>>
>
>
My mistake, my dates are wrong. I have it working now, thanks for the
support!
Mo
On Sun, Mar 23, 2014 at 6:12 AM, Muhamand Wilkes
<muhamand.wilkes@gmail.com>wrote:
> Thanks Randy,
>
> I am trying to get the bid for ARO Jan 16 7.00 Call. When I modify it to
> your format (ARO 1/22 2016 $7 Call) but no success.. Am I doing something
> wrong?
>
>
> On Sun, Mar 23, 2014 at 6:00 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>>
>>
>> You should use smfGetOptionQuotes(). For example:
>>
>> =smfGetOptionQuotes("MMM 3/28 2014 $134 Call","b",,"Y")
>>
>> Note that Yahoo is currently missing options quotes on some equities,
>> such as SPY.
>>
>>
>> On Sun, Mar 23, 2014 at 2:30 AM, Muhamand Wilkes <
>> muhamand.wilkes@gmail.com> wrote:
>>
>>>
>>> I would like to take the ticker symbol for an option and return the
>>> current bid to a cell. Does anyone have a working example I can use?
>>>
>>
>>
>>
>
>
Sun Mar 23, 2014 8:04 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Thank you very much, That was indeed my problem.
I forgot to put the "Friendly Name" in quotes that's why that part did not work.
Thanks again,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of mikemcq802@yahoo.com
Sent: Saturday, March 22, 2014 5:58 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: How do I get the exact webpage link created in a cell?
Your second example =HYPERLINK(B10,A1) is wrong. It should be B10&A1 (concatenation, no comma). Using a comma supplies 2 parameters. The second parameter to hyperlink is a "Friendly name".
The example I provided worked for me. Are you sure you used it correctly?
I forgot to put the "Friendly Name" in quotes that's why that part did not work.
Thanks again,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of mikemcq802@yahoo.com
Sent: Saturday, March 22, 2014 5:58 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: How do I get the exact webpage link created in a cell?
Your second example =HYPERLINK(B10,
The example I provided worked for me. Are you sure you used it correctly?
Sun Mar 23, 2014 10:35 am (PDT) . Posted by:
hamishthedenizen
advertise78,
It sounds like you may have been using the spreadsheet that I posted. It appears to be working fine at the moment. If it was my model, the formula looks like an older version. Are you using the latest version? (I've updated for some GuruFocus website tweaks and minor errors that I discovered). If you are still having issues, please let me know and I'll see if I can do anything.
It sounds like you may have been using the spreadsheet that I posted. It appears to be working fine at the moment. If it was my model, the formula looks like an older version. Are you using the latest version? (I've updated for some GuruFocus website tweaks and minor errors that I discovered). If you are still having issues, please let me know and I'll see if I can do anything.
Sun Mar 23, 2014 9:05 pm (PDT) . Posted by:
advertise78
hamishthedenizen,
I'll check it out and see if I have an older version. It just started having problems though. I didn't have time to play with it this weekend, since i had to leave town. Thank you for speaking up. I'll let you know how I resolve the issue, if I'm able to do so.
V/R
advertise78
I'll check it out and see if I have an older version. It just started having problems though. I didn't have time to play with it this weekend, since i had to leave town. Thank you for speaking up. I'll let you know how I resolve the issue, if I'm able to do so.
V/R
advertise78
Sun Mar 23, 2014 4:24 pm (PDT) . Posted by:
ojalee1
So I figured out what my problem is, its not web query issue but a url issue, which leads to my next question. How do I get the url for the csv file?
Sun Mar 23, 2014 4:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can comb the JavaScript code. Or use an HTTP sniffer of some kind.
In FireFox, I used to use the "Download" menu option. Now I use HTTPFox, a
FireFox add-in that can monitor web pages that are accessed.
On Sun, Mar 23, 2014 at 4:24 PM, <ojalee1@yahoo.com> wrote:
>
> So I figured out what my problem is, its not web query issue but a url
> issue, which leads to my next question. How do I get the url for the csv
> file?
>
In FireFox, I used to use the "Download" menu option. Now I use HTTPFox, a
FireFox add-in that can monitor web pages that are accessed.
On Sun, Mar 23, 2014 at 4:24 PM, <ojalee1@yahoo.com> wrote:
>
> So I figured out what my problem is, its not web query issue but a url
> issue, which leads to my next question. How do I get the url for the csv
> file?
>
Sun Mar 23, 2014 8:26 pm (PDT) . Posted by:
"Steve Ikenaga" saibernaut
Hi,
Hoping someone can please help me. Beginning sometime last week, the
Finviz ATR value has been messing up my row height. I don't recall ever
experiencing this issue after using SMF_addin for years now.
My worksheet is set up so that I enter a stock symbol in the first column,
and SMF populates cells in the corresponding row with various Finviz data
parameters. I've been (successfully) using the following formula to
retrieve ATR data from Finviz:
=RCHGetTableCell("http://finviz.com/quote.ashx?t=" &$A4,1,">ATR")
Normally, the "blank" cells display "Error" until I enter in a symbol.
Last week, however, the ATR (average true range) column began acting up,
such that even *before* I enter in any symbol, the ATR cell displays: "Exa
Corporation Application Software |USA| 186.77M] offsetx=[-300]
offsety=[-240] delay=[250]">EX" (Note: I can't recall if this same symbol
data has been showing up or not.)
I also tried pulling up the same worksheet on my iMac/Fusion (OS X/Excel
2003) virtual machine, and here the cell is literally blank -- it doesn't
even display the normal "Error" text that normally shows, nor does it show
all that "Exa Corporation" text (per the above).
In both cases, however, this messes up all of my row (auto-)heights by
causing them to be extra large. On the PC, the rows are already expanded
in the "blank" worksheet to fit all that junk text. On the Fusion machine,
each row height over expands as soon as I type in a symbol, even if only
the actual ATR value is displayed.
The row heights can subsequently be fixed (shrunken back down) by
reformatting them via "auto-height" all over again, but that's a hassle. I
can also "pre-empt"; this all from occurring by pre-populating my "blank"
worksheet template with any dummy symbol, fixing the row heights, and
saving the template in this form, but this means my "blank" worksheet will
always be pre-filled with unwanted data.
Can anyone provide me with any help, suggestions, fixes? SMF has been such
a valuable tool for me in my trading! (Thanks, Randy!)
P.S. I tried downloading the latest SMF version on the PC, while the Mac
is still running the Oct. 2013 version.
Hoping someone can please help me. Beginning sometime last week, the
Finviz ATR value has been messing up my row height. I don't recall ever
experiencing this issue after using SMF_addin for years now.
My worksheet is set up so that I enter a stock symbol in the first column,
and SMF populates cells in the corresponding row with various Finviz data
parameters. I've been (successfully) using the following formula to
retrieve ATR data from Finviz:
=RCHGetTableCell("http://finviz.com/quote.ashx?t=" &$A4,1,"
Normally, the "blank" cells display "Error" until I enter in a symbol.
Last week, however, the ATR (average true range) column began acting up,
such that even *before* I enter in any symbol, the ATR cell displays: "Exa
Corporation Application Software |USA| 186.77M] offsetx=[-300]
offsety=[-240] delay=[250]"
data has been showing up or not.)
I also tried pulling up the same worksheet on my iMac/Fusion (OS X/Excel
2003) virtual machine, and here the cell is literally blank -- it doesn't
even display the normal "Error" text that normally shows, nor does it show
all that "Exa Corporation" text (per the above).
In both cases, however, this messes up all of my row (auto-)heights by
causing them to be extra large. On the PC, the rows are already expanded
in the "blank" worksheet to fit all that junk text. On the Fusion machine,
each row height over expands as soon as I type in a symbol, even if only
the actual ATR value is displayed.
The row heights can subsequently be fixed (shrunken back down) by
reformatting them via "auto-height&q
can also "pre-empt"
worksheet template with any dummy symbol, fixing the row heights, and
saving the template in this form, but this means my "blank" worksheet will
always be pre-filled with unwanted data.
Can anyone provide me with any help, suggestions, fixes? SMF has been such
a valuable tool for me in my trading! (Thanks, Randy!)
P.S. I tried downloading the latest SMF version on the PC, while the Mac
is still running the Oct. 2013 version.
Sun Mar 23, 2014 8:38 pm (PDT) . Posted by:
mikemcq802
Just do this:
=IF(A4>" ",RCHGetTableCell("http://finviz.com/quote.ashx?t=" &$A4,1,">ATR"),"")
The problem is that the RCHGetTableCell does a lookup immediately upon opening the spreadsheet - just that the value for A4 is blank. In this case, finfiz returns a web page that happens to have the >ATR string in it and returns that data you see. Qualifying the RCH lookup with an IF statement will ensure no lookup until you enter a value. I"m guessing Finviz didn't used to return the same sort of page when it wasn't given a symbol to lookup which has caused your changed behavior.
=IF(A4>" ",RCHGetTableCell("http://finviz.com/quote.ashx?t=" &$A4,1,"
The problem is that the RCHGetTableCell does a lookup immediately upon opening the spreadsheet - just that the value for A4 is blank. In this case, finfiz returns a web page that happens to have the >ATR string in it and returns that data you see. Qualifying the RCH lookup with an IF statement will ensure no lookup until you enter a value. I"m guessing Finviz didn't used to return the same sort of page when it wasn't given a symbol to lookup which has caused your changed behavior.
Sun Mar 23, 2014 8:41 pm (PDT) . Posted by:
saibernaut
P.S. P.S. Sorry for the poor formatting in my original post. All of my paragraphs/spacing got messed up somehow.
Sun Mar 23, 2014 8:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The "Exa Corporation Application Software |USA| 186.77M] offsetx=[-300]
offsety=[-240] delay=[250]">EXA" is easy to explain -- if you go to this
URL, which is what you're telling the function to do when no ticker symbols
exists):
http://finviz.com/quote.ashx?t=
...you get redirected to their home page. Right now, "ATRI" is a ticker
symbol on that web page, for upcoming earnings announcements. That would
match your ">ATR" search, which used to return error before that ticker
symbol showed up on the home page. The data you are seeing is the contents
of the next table cell.
I was going to suggest a workaround, for an empty ticker symbol, but I see
Mike beat me to the punch. :)
If you're getting data for a number of ticker symbols, you may want to look
at the process of getting the CSV file with the necessary data (from the
Tips and FAQS web page). It would be quicker, since you would just need one
Internet access.
On Sun, Mar 23, 2014 at 8:21 PM, Steve Ikenaga <888hitrader@gmail.com>wrote:
> Hoping someone can please help me. Beginning sometime last week, the
> Finviz ATR value has been messing up my row height. I don't recall ever
> experiencing this issue after using SMF_addin for years now.
>
> My worksheet is set up so that I enter a stock symbol in the first column,
> and SMF populates cells in the corresponding row with various Finviz data
> parameters. I've been (successfully) using the following formula to
> retrieve ATR data from Finviz:
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=" &$A4,1,">ATR")
>
> Normally, the "blank" cells display "Error" until I enter in a symbol.
> Last week, however, the ATR (average true range) column began acting up,
> such that even *before* I enter in any symbol, the ATR cell displays: "Exa
> Corporation Application Software |USA| 186.77M] offsetx=[-300]
> offsety=[-240] delay=[250]">EX" (Note: I can't recall if this same symbol
> data has been showing up or not.)
>
> I also tried pulling up the same worksheet on my iMac/Fusion (OS X/Excel
> 2003) virtual machine, and here the cell is literally blank -- it doesn't
> even display the normal "Error" text that normally shows, nor does it show
> all that "Exa Corporation" text (per the above).
>
> In both cases, however, this messes up all of my row (auto-)heights by
> causing them to be extra large. On the PC, the rows are already expanded
> in the "blank" worksheet to fit all that junk text. On the Fusion machine,
> each row height over expands as soon as I type in a symbol, even if only
> the actual ATR value is displayed.
>
> The row heights can subsequently be fixed (shrunken back down) by
> reformatting them via "auto-height" all over again, but that's a hassle. I
> can also "pre-empt"; this all from occurring by pre-populating my "blank"
> worksheet template with any dummy symbol, fixing the row heights, and
> saving the template in this form, but this means my "blank" worksheet will
> always be pre-filled with unwanted data.
>
> Can anyone provide me with any help, suggestions, fixes? SMF has been
> such a valuable tool for me in my trading! (Thanks, Randy!)
>
> P.S. I tried downloading the latest SMF version on the PC, while the Mac
> is still running the Oct. 2013 version.
>
offsety=[-240] delay=[250]">EXA" is easy to explain -- if you go to this
URL, which is what you're telling the function to do when no ticker symbols
exists):
http://finviz.com/quote.ashx?t=
...you get redirected to their home page. Right now, "ATRI" is a ticker
symbol on that web page, for upcoming earnings announcements. That would
match your ">ATR" search, which used to return error before that ticker
symbol showed up on the home page. The data you are seeing is the contents
of the next table cell.
I was going to suggest a workaround, for an empty ticker symbol, but I see
Mike beat me to the punch. :)
If you're getting data for a number of ticker symbols, you may want to look
at the process of getting the CSV file with the necessary data (from the
Tips and FAQS web page). It would be quicker, since you would just need one
Internet access.
On Sun, Mar 23, 2014 at 8:21 PM, Steve Ikenaga <888hitrader@gmail.com>wrote:
> Hoping someone can please help me. Beginning sometime last week, the
> Finviz ATR value has been messing up my row height. I don't recall ever
> experiencing this issue after using SMF_addin for years now.
>
> My worksheet is set up so that I enter a stock symbol in the first column,
> and SMF populates cells in the corresponding row with various Finviz data
> parameters. I've been (successfully) using the following formula to
> retrieve ATR data from Finviz:
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=" &$A4,1,"
>
> Normally, the "blank" cells display "Error" until I enter in a symbol.
> Last week, however, the ATR (average true range) column began acting up,
> such that even *before* I enter in any symbol, the ATR cell displays: "Exa
> Corporation Application Software |USA| 186.77M] offsetx=[-300]
> offsety=[-240] delay=[250]"
> data has been showing up or not.)
>
> I also tried pulling up the same worksheet on my iMac/Fusion (OS X/Excel
> 2003) virtual machine, and here the cell is literally blank -- it doesn't
> even display the normal "Error" text that normally shows, nor does it show
> all that "Exa Corporation" text (per the above).
>
> In both cases, however, this messes up all of my row (auto-)heights by
> causing them to be extra large. On the PC, the rows are already expanded
> in the "blank" worksheet to fit all that junk text. On the Fusion machine,
> each row height over expands as soon as I type in a symbol, even if only
> the actual ATR value is displayed.
>
> The row heights can subsequently be fixed (shrunken back down) by
> reformatting them via "auto-height&q
> can also "pre-empt"
> worksheet template with any dummy symbol, fixing the row heights, and
> saving the template in this form, but this means my "blank" worksheet will
> always be pre-filled with unwanted data.
>
> Can anyone provide me with any help, suggestions, fixes? SMF has been
> such a valuable tool for me in my trading! (Thanks, Randy!)
>
> P.S. I tried downloading the latest SMF version on the PC, while the Mac
> is still running the Oct. 2013 version.
>
Sun Mar 23, 2014 9:41 pm (PDT) . Posted by:
"Nikola Ganev" ganevniko
Sorry I couldnt access my computer these last days, thank you Randy, you solved both of my problems.
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 19, 2014 5:35 PM
Subject: Re: [smf_addin] Errors with Rchgetelementnumber function
It looks like those are still text items, possibly because of your regional settings. I assume you don't express numbers with commas and periods like that? If so, they were never converted into numbers, and left as text, because the VBA functions that convert text into numbers are based on your regional setting and won't recognize such data.
On Wed, Mar 19, 2014 at 11:07 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>For the item two, I use
>
>rchgetelementnumber("KO",9446) = 13,070.0 in C5
>rchgetelementnumber("KO",9447) = 13,070.0 in D5
>rchgetelementnumber("KO",9448) = 6,196.0 in E5
>
>Then sum(D5:E5) gives me 0
>
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 19, 2014 5:35 PM
Subject: Re: [smf_addin] Errors with Rchgetelementnumber function
It looks like those are still text items, possibly because of your regional settings. I assume you don't express numbers with commas and periods like that? If so, they were never converted into numbers, and left as text, because the VBA functions that convert text into numbers are based on your regional setting and won't recognize such data.
On Wed, Mar 19, 2014 at 11:07 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>For the item two, I use
>
>rchgetelementnu
>rchgetelementnu
>rchgetelementnu
>
>Then sum(D5:E5) gives me 0
>
Tidak ada komentar:
Posting Komentar