10 New Messages
Digest #2738
Messages
Sun Aug 18, 2013 7:32 am (PDT) . Posted by:
"pragaon" pragaon
I just want to extract title from a web page from google.
e.g. https://www.google.com/finance?q=ford%20motor
title page info is:
<title>Ford Motor Company: NYSE:F quotes & news - Google Finance</title>
which function is best to extract that title?
Thanks,
Prakash
e.g. https://www.
title page info is:
<title>
which function is best to extract that title?
Thanks,
Prakash
Sun Aug 18, 2013 7:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://www.google.com/finance?q=ford%20motor ","title")
On Sun, Aug 18, 2013 at 7:32 AM, pragaon <pragaon@yahoo.com > wrote:
> I just want to extract title from a web page from google.
> e.g. https://www.google.com/finance?q=ford%20motor
>
> title page info is:
> <title>Ford Motor Company: NYSE:F quotes & news - Google Finance</title>
>
> which function is best to extract that title?
>
=smfGetTagContent(
On Sun, Aug 18, 2013 at 7:32 AM, pragaon <pragaon@yahoo.
> I just want to extract title from a web page from google.
> e.g. https://www.
>
> title page info is:
> <title>
>
> which function is best to extract that title?
>
Sun Aug 18, 2013 7:48 am (PDT) . Posted by:
"pragaon" pragaon
Thanks. It worked.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =smfGetTagContent("https://www.google.com/finance?q=ford%20motor ","title")
>
> On Sun, Aug 18, 2013 at 7:32 AM, pragaon <pragaon@...> wrote:
>
> > I just want to extract title from a web page from google.
> > e.g. https://www.google.com/finance?q=ford%20motor
> >
> > title page info is:
> > <title>Ford Motor Company: NYSE:F quotes & news - Google Finance</title>
> >
> > which function is best to extract that title?
> >
>
--- In smf_addin@yahoogrou
>
> Try:
>
> =smfGetTagContent(
>
> On Sun, Aug 18, 2013 at 7:32 AM, pragaon <pragaon@
>
> > I just want to extract title from a web page from google.
> > e.g. https://www.
> >
> > title page info is:
> > <title>
> >
> > which function is best to extract that title?
> >
>
Sun Aug 18, 2013 7:45 am (PDT) . Posted by:
"indinvestor111" indinvestor111
Hi,
Was wondering if anybody's heard anything about AdvFN not providing the latest quarter's results on US tickers.
I noticed the issue was raised a month ago, where the folks at the site mentioned a fix was in the offing and likely to be out in a week or two. Am I missing something?
Thanks
Was wondering if anybody'
I noticed the issue was raised a month ago, where the folks at the site mentioned a fix was in the offing and likely to be out in a week or two. Am I missing something?
Thanks
Sun Aug 18, 2013 9:34 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
Using smfGetOptionStrikes() as an array function works well. the only problem is that data cannot be sorted (cannot change part of an array). so how can I build a list of 6 strikes (3 itm and 3 otm) without using the array version? in other words, which parameters do I have to specify in the function to make sure i get these 6 different strikes (i need the complete ticker, not just the strike)...
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Well, first thing I would do is to find the expiration date:
>
> B2: =smfGetOptionExpiry(2013,7,"M")
>
> Then, I would use the smfGetOptionStrikes() function to get the strike
> prices. It's more reliable than using the OTM1 and ITM1 parameters, because
> weekly options now mean the near-team months can have multiple expiration
> dates on a Yahoo web page.
>
> B4: =smfGetOptionStrikes("SPY";,B2,"C","Y",1)
>
> Or, to get the first ITM price only:
>
> =smfGetOptionStrikes("SPY";,B2,"C","Y",1,2,1)
>
> Note that if you array-entered the above over a 1-column by 4-row range,
> you would get the 2 ITM and 2 OTM strike prices. The last "1" parameter
> tells it to make option ticker symbols for the smfGetOptionQuotes()
> function, instead of just returning the strike price.
>
> So, you could either have:
>
> 2013-07-20 SPY 7/20 2013 $164.00 Call
> ...or:
>
> 2013-07-20 SPY 7/20 2013 $162.00 Call SPY 7/20 2013
> $163.00 Call SPY 7/20 2013 $164.00 Call SPY 7/20 2013 $165.00 Call
> For info on more option functions, take a look at:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/17234
>
> On Thu, Jun 20, 2013 at 6:29 AM, Rich <rlmacduff@...> wrote:
>
> > Could you provide the syntax for pulling the next month's first OTM strike
> > price based on knowing the stock ticker symbol and the current trading
> > price? For example … I would like to populate the July strike price for
> > stocks I am monitoring. I think it has to do with using OTM1, I'm just at a
> > loss as to how to create the correct code.
> > Thanks in advance …. Rich
> >
>
thanks
--- In smf_addin@yahoogrou
>
> Well, first thing I would do is to find the expiration date:
>
> B2: =smfGetOptionExpiry
>
> Then, I would use the smfGetOptionStrikes
> prices. It's more reliable than using the OTM1 and ITM1 parameters, because
> weekly options now mean the near-team months can have multiple expiration
> dates on a Yahoo web page.
>
> B4: =smfGetOptionStrike
>
> Or, to get the first ITM price only:
>
> =smfGetOptionStrike
>
> Note that if you array-entered the above over a 1-column by 4-row range,
> you would get the 2 ITM and 2 OTM strike prices. The last "1" parameter
> tells it to make option ticker symbols for the smfGetOptionQuotes(
> function, instead of just returning the strike price.
>
> So, you could either have:
>
> 2013-07-20 SPY 7/20 2013 $164.00 Call
> ...or:
>
> 2013-07-20 SPY 7/20 2013 $162.00 Call SPY 7/20 2013
> $163.00 Call SPY 7/20 2013 $164.00 Call SPY 7/20 2013 $165.00 Call
> For info on more option functions, take a look at:
>
> http://finance.
>
> On Thu, Jun 20, 2013 at 6:29 AM, Rich <rlmacduff@
>
> > Could you provide the syntax for pulling the next month's first OTM strike
> > price based on knowing the stock ticker symbol and the current trading
> > price? For example … I would like to populate the July strike price for
> > stocks I am monitoring. I think it has to do with using OTM1, I'm just at a
> > loss as to how to create the correct code.
> > Thanks in advance …. Rich
> >
>
Sun Aug 18, 2013 10:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Getting the individual strike prices would be VERY slow, because each
invocation of the function has to go out to the Internet to get the data.
But you could do it with something like:
=INDEX(smfGetOptionStrikes("SPY",$B$2,"C","Y",1,14,1),D4)
...where the "14,1" says to get the 14 strike prices, but D4 can vary from
1 to 14, depending on which one you want.
Instead, what I would suggest is:
B2: =smfGetOptionExpiry(2013,9,"M")
B4:B7: =smfGetOptionStrikes("SPY";,B2,"C","Y",1)
D4: 1
E4: =INDEX($B$4:$B$7,D4)
D5: 2
E5: =INDEX($B$4:$B$7,D5)
D6: 3
E6: =INDEX($B$4:$B$7,D6)
D7: 4
E7: =INDEX($B$4:$B$18,D7)
Now columns D thru whatever can be sorted any way you want.
2013-09-21 Item Ticker SPY 9/21 2013 $164.00 Call 1 SPY 9/21
2013 $164.00 Call SPY 9/21 2013 $165.00 Call 2 SPY 9/21 2013
$165.00 Call SPY
9/21 2013 $166.00 Call 3 SPY 9/21 2013 $166.00 Call SPY 9/21 2013
$167.00 Call 4 SPY 9/21 2013 $167.00 Call
For example, I'll add a sort column and sort columns D thru F:
2013-09-21 Item Ticker Sort SPY 9/21 2013 $164.00
Call 2 SPY 9/21 2013 $165.00 Call 1 SPY 9/21 2013 $165.00 Call 1 SPY
9/21 2013 $164.00 Call 2 SPY 9/21 2013 $166.00 Call 4 SPY 9/21 2013
$167.00 Call 3 SPY 9/21 2013 $167.00 Call 3 SPY 9/21 2013 $166.00 Call 4
Note that column B remains fixed. So the array is untouched. However, note
that this will NOT allow you to delete any of those rows. If you want to do
that, then your column B should be on a different worksheet.
On Sun, Aug 18, 2013 at 9:34 AM, john.kalkanis <john.kalkanis@yahoo.com >wrote:
> Using smfGetOptionStrikes() as an array function works well. the only
> problem is that data cannot be sorted (cannot change part of an array). so
> how can I build a list of 6 strikes (3 itm and 3 otm) without using the
> array version? in other words, which parameters do I have to specify in the
> function to make sure i get these 6 different strikes (i need the complete
> ticker, not just the strike)...
>
invocation of the function has to go out to the Internet to get the data.
But you could do it with something like:
=INDEX(smfGetOption
...where the "14,1" says to get the 14 strike prices, but D4 can vary from
1 to 14, depending on which one you want.
Instead, what I would suggest is:
B2: =smfGetOptionExpiry
B4:B7: =smfGetOptionStrike
D4: 1
E4: =INDEX($B$4:
D5: 2
E5: =INDEX($B$4:
D6: 3
E6: =INDEX($B$4:
D7: 4
E7: =INDEX($B$4:
Now columns D thru whatever can be sorted any way you want.
2013-09-21 Item Ticker SPY 9/21 2013 $164.00 Call 1 SPY 9/21
2013 $164.00 Call SPY 9/21 2013 $165.00 Call 2 SPY 9/21 2013
$165.00 Call SPY
9/21 2013 $166.00 Call 3 SPY 9/21 2013 $166.00 Call SPY 9/21 2013
$167.00 Call 4 SPY 9/21 2013 $167.00 Call
For example, I'll add a sort column and sort columns D thru F:
2013-09-21 Item Ticker Sort SPY 9/21 2013 $164.00
Call 2 SPY 9/21 2013 $165.00 Call 1 SPY 9/21 2013 $165.00 Call 1 SPY
9/21 2013 $164.00 Call 2 SPY 9/21 2013 $166.00 Call 4 SPY 9/21 2013
$167.00 Call 3 SPY 9/21 2013 $167.00 Call 3 SPY 9/21 2013 $166.00 Call 4
Note that column B remains fixed. So the array is untouched. However, note
that this will NOT allow you to delete any of those rows. If you want to do
that, then your column B should be on a different worksheet.
On Sun, Aug 18, 2013 at 9:34 AM, john.kalkanis <john.kalkanis@
> Using smfGetOptionStrikes
> problem is that data cannot be sorted (cannot change part of an array). so
> how can I build a list of 6 strikes (3 itm and 3 otm) without using the
> array version? in other words, which parameters do I have to specify in the
> function to make sure i get these 6 different strikes (i need the complete
> ticker, not just the strike)...
>
Sun Aug 18, 2013 7:39 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Sorry to bother you again with this, but I am perplexed with this new issue
that just popped up.
Everything was working just fine with my spreadsheet pulling data from
gurufocus.com, shut down the computer, came back, did some driver updates
and opened Excel and it stopped working.
When I click on any cell that had the RCHGetTableCell function it now has:
='C:\Program Files\SMF
Add-In\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus
.com/financials/"&$A2,1,">Market Cap")
Why would it stick the location of the add-in file in all the cells? And
more importantly stop working altogether?
It did ask me to update links when I opened the file. I'm guessing that did
it, but why would it need to do that either? Do you tell it not to update
links?
Secondarily to this problem and coincident, a different spreadsheet using
DDE functions from thinkorswim's platform also are no longer working and
hanging the program.
Any advice on how to prevent this would be greatly appreciated.
Thanks,
Jim
Sorry to bother you again with this, but I am perplexed with this new issue
that just popped up.
Everything was working just fine with my spreadsheet pulling data from
gurufocus.com, shut down the computer, came back, did some driver updates
and opened Excel and it stopped working.
When I click on any cell that had the RCHGetTableCell function it now has:
='C:\
Add-In\RCH_
.com/financials/
Why would it stick the location of the add-in file in all the cells? And
more importantly stop working altogether?
It did ask me to update links when I opened the file. I'm guessing that did
it, but why would it need to do that either? Do you tell it not to update
links?
Secondarily to this problem and coincident, a different spreadsheet using
DDE functions from thinkorswim&#
hanging the program.
Any advice on how to prevent this would be greatly appreciated.
Thanks,
Jim
Sun Aug 18, 2013 7:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Every time you save a file that uses add-in functions, it hard-codes the
location of the add-in with that function. When it opens the workbook, it
looks for the add-in using that hard-coded location. If it finds it as an
active add-in, it "resolves"; the link to the add-in and removes the
hard-coded location. If it can't find the add-in, or the add-in isn't
active, it leaves the hard-coded location in the formula and calls it
"unresolved" -- which is the error message you received. I often get these,
because people have the add-in located in different places. So any time
those workbooks are shared, the problem arises. The add-in does have a
macro that manually fixes link errors -- smfFixLinks. I have it on my EXCEL
toolbar so it's easily accessible. Otherwise, you can do it manually as
well -- check out the "Location Errors" entry in the LINKS area of the
Yahoo group.
But first thing I would check is to make sure the add-in is still listed in
the add-in manager.
Can't help with the DDE stuff. Sorry.
On Sun, Aug 18, 2013 at 7:39 PM, Jim Ranum <amt2100@gmail.com > wrote:
>
>
> Sorry to bother you again with this, but I am perplexed with this new
> issue that just popped up.****
>
> Everything was working just fine with my spreadsheet pulling data from
> gurufocus.com, shut down the computer, came back, did some driver updates
> and opened Excel and it stopped working.****
>
> ** **
>
> When I click on any cell that had the RCHGetTableCell function it now has:
> ****
>
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
> http://www.gurufocus.com/financials/ "&$A2,1,">Market Cap")****
>
> ** **
>
> Why would it stick the location of the add-in file in all the cells? And
> more importantly stop working altogether?****
>
> It did ask me to update links when I opened the file. I’m guessing that
> did it, but why would it need to do that either? Do you tell it not to
> update links?****
>
> ** **
>
> Secondarily to this problem and coincident, a different spreadsheet using
> DDE functions from thinkorswim’s platform also are no longer working and
> hanging the program.****
>
> Any advice on how to prevent this would be greatly appreciated.****
>
>
>
location of the add-in with that function. When it opens the workbook, it
looks for the add-in using that hard-coded location. If it finds it as an
active add-in, it "resolves"
hard-coded location. If it can't find the add-in, or the add-in isn't
active, it leaves the hard-coded location in the formula and calls it
"unresolved&qu
because people have the add-in located in different places. So any time
those workbooks are shared, the problem arises. The add-in does have a
macro that manually fixes link errors -- smfFixLinks. I have it on my EXCEL
toolbar so it's easily accessible. Otherwise, you can do it manually as
well -- check out the "Location Errors" entry in the LINKS area of the
Yahoo group.
But first thing I would check is to make sure the add-in is still listed in
the add-in manager.
Can't help with the DDE stuff. Sorry.
On Sun, Aug 18, 2013 at 7:39 PM, Jim Ranum <amt2100@gmail.
>
>
> Sorry to bother you again with this, but I am perplexed with this new
> issue that just popped up.****
>
> Everything was working just fine with my spreadsheet pulling data from
> gurufocus.com, shut down the computer, came back, did some driver updates
> and opened Excel and it stopped working.****
>
> ** **
>
> When I click on any cell that had the RCHGetTableCell function it now has:
> ****
>
> ='C:\
> Add-In\RCH_
> http://www.gurufocu
>
> ** **
>
> Why would it stick the location of the add-in file in all the cells? And
> more importantly stop working altogether?*
>
> It did ask me to update links when I opened the file. I’m guessing that
> did it, but why would it need to do that either? Do you tell it not to
> update links?****
>
> ** **
>
> Secondarily to this problem and coincident, a different spreadsheet using
> DDE functions from thinkorswim’s platform also are no longer working and
> hanging the program.****
>
> Any advice on how to prevent this would be greatly appreciated.
>
>
>
Sun Aug 18, 2013 8:32 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks Randy. Yes, I wondered about the add-in still being in the list of active add-in’s and it wasn’t. I only shut the computer down and reopened it. The add-in should remain installed and active, correct? What made it drop out?
I found your message 11346, talking about the smfFixLinks. Couldn’t find it anywhere else. It says you created a macro for it. How would you keep that on your toolbar?
Thanks very much.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, August 18, 2013 10:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Excel hanging and add-in instructions changing by themselves
Every time you save a file that uses add-in functions, it hard-codes the location of the add-in with that function. When it opens the workbook, it looks for the add-in using that hard-coded location. If it finds it as an active add-in, it "resolves"; the link to the add-in and removes the hard-coded location. If it can't find the add-in, or the add-in isn't active, it leaves the hard-coded location in the formula and calls it "unresolved" -- which is the error message you received. I often get these, because people have the add-in located in different places. So any time those workbooks are shared, the problem arises. The add-in does have a macro that manually fixes link errors -- smfFixLinks. I have it on my EXCEL toolbar so it's easily accessible. Otherwise, you can do it manually as well -- check out the "Location Errors" entry in the LINKS area of the Yahoo group.
But first thing I would check is to make sure the add-in is still listed in the add-in manager.
Can't help with the DDE stuff. Sorry.
On Sun, Aug 18, 2013 at 7:39 PM, Jim Ranum <amt2100@gmail.com > wrote:
Sorry to bother you again with this, but I am perplexed with this new issue that just popped up.
Everything was working just fine with my spreadsheet pulling data from gurufocus.com, shut down the computer, came back, did some driver updates and opened Excel and it stopped working.
When I click on any cell that had the RCHGetTableCell function it now has:
='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/ "&$A2,1,">Market Cap")
Why would it stick the location of the add-in file in all the cells? And more importantly stop working altogether?
It did ask me to update links when I opened the file. I’m guessing that did it, but why would it need to do that either? Do you tell it not to update links?
Secondarily to this problem and coincident, a different spreadsheet using DDE functions from thinkorswim’s platform also are no longer working and hanging the program.
Any advice on how to prevent this would be greatly appreciated.
I found your message 11346, talking about the smfFixLinks. Couldn’t find it anywhere else. It says you created a macro for it. How would you keep that on your toolbar?
Thanks very much.
Jim
From: smf_addin@yahoogrou
Sent: Sunday, August 18, 2013 10:59 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Excel hanging and add-in instructions changing by themselves
Every time you save a file that uses add-in functions, it hard-codes the location of the add-in with that function. When it opens the workbook, it looks for the add-in using that hard-coded location. If it finds it as an active add-in, it "resolves"
But first thing I would check is to make sure the add-in is still listed in the add-in manager.
Can't help with the DDE stuff. Sorry.
On Sun, Aug 18, 2013 at 7:39 PM, Jim Ranum <amt2100@gmail.
Sorry to bother you again with this, but I am perplexed with this new issue that just popped up.
Everything was working just fine with my spreadsheet pulling data from gurufocus.com, shut down the computer, came back, did some driver updates and opened Excel and it stopped working.
When I click on any cell that had the RCHGetTableCell function it now has:
='C:\
Why would it stick the location of the add-in file in all the cells? And more importantly stop working altogether?
It did ask me to update links when I opened the file. I’m guessing that did it, but why would it need to do that either? Do you tell it not to update links?
Secondarily to this problem and coincident, a different spreadsheet using DDE functions from thinkorswim’s platform also are no longer working and hanging the program.
Any advice on how to prevent this would be greatly appreciated.
Sun Aug 18, 2013 8:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I would have thought it would have remained. But if you were installing
driver updates and other things, it may have "reset" some things with
EXCEL. The Devil is in the details. That might be what happened to your DDE
process as well?
As far as keeping smfFixLinks on the toolbar, just create the button and
assign the macro to it. In EXCEL 2007, it's called the QAT (Quick Access
Toolbar).
On Sun, Aug 18, 2013 at 8:31 PM, Jim Ranum <amt2100@gmail.com > wrote:
>
> Thanks Randy. Yes, I wondered about the add-in still being in the list of
> active add-in’s and it wasn’t. I only shut the computer down and reopened
> it. The add-in should remain installed and active, correct? What made it
> drop out?****
>
> ** **
>
> I found your message 11346, talking about the smfFixLinks. Couldn’t find
> it anywhere else. It says you created a macro for it. How would you keep
> that on your toolbar?****
>
>
>
driver updates and other things, it may have "reset" some things with
EXCEL. The Devil is in the details. That might be what happened to your DDE
process as well?
As far as keeping smfFixLinks on the toolbar, just create the button and
assign the macro to it. In EXCEL 2007, it's called the QAT (Quick Access
Toolbar).
On Sun, Aug 18, 2013 at 8:31 PM, Jim Ranum <amt2100@gmail.
>
> Thanks Randy. Yes, I wondered about the add-in still being in the list of
> active add-in’s and it wasn’t. I only shut the computer down and reopened
> it. The add-in should remain installed and active, correct? What made it
> drop out?****
>
> ** **
>
> I found your message 11346, talking about the smfFixLinks. Couldn’t find
> it anywhere else. It says you created a macro for it. How would you keep
> that on your toolbar?****
>
>
>
Tidak ada komentar:
Posting Komentar