Jumat, 22 Maret 2013

[smf_addin] Digest Number 2556

13 New Messages

Digest #2556
1b
1e
2a
Re: smfGetTagContent standalone file by "Jovica Bozic" jovica.bozic
4b
Re: smfGetOptionQuotes returning "N/A" by "Randy Harmelink" rharmelink
4d
Re: smfGetOptionQuotes returning "N/A" by "Randy Harmelink" rharmelink

Messages

Thu Mar 21, 2013 8:22 am (PDT) . Posted by:

"rr76012" rr76012

Hello Randy,

I am getting an "Error" message for these element numbers.

= RCHGetElementNumber(A2, 41)

= RCHGetElementNumber(A2, 44)

= RCHGetElementNumber(A2, 45)

Is there anything that I can do?
I really hope you have a solution?
Pls tell me I just need to update something???

Thank you, have a great day.

Thu Mar 21, 2013 8:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They're working fine here -- what do you get with:

=RCHGetElementNumber("Version")
=smfGetAParms(41)

On Thu, Mar 21, 2013 at 8:22 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> I am getting an "Error" message for these element numbers.
>
> = RCHGetElementNumber(A2, 41)
>
> = RCHGetElementNumber(A2, 44)
>
> = RCHGetElementNumber(A2, 45)
>
> Is there anything that I can do?
> I really hope you have a solution?
> Pls tell me I just need to update something???
>
>

Thu Mar 21, 2013 8:34 am (PDT) . Posted by:

"Randy H" rharmelink

You should definitely get the latest version of the add-in. A lot has
changed in 3 years.

On Thu, Mar 21, 2013 at 8:28 AM, xxxx <...@...
<mailto:shiv032@gmail.com> > wrote:

I am also facing similar kind of issue

i get "" for "=RCHGetElementNumber("Version")"

stockMarketfunction 2.0 k

and nothing is displaying for "=smfGetAParms(41)"

Thu Mar 21, 2013 9:06 am (PDT) . Posted by:

"rr76012" rr76012

Hello Randy, I plugged your formulas into the spreadsheet, here are the answers I got.

1. Stock Market Functions add-in, Version 2.1.2012.01.30 (C:\Program Files\SMF Add-In; 1)

2. MSN;Financial Highlights -- Return on Equity;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIAL HIGHLIGHTS;RETURN ON EQUITY; ; ;0;0;0;0

3. MSN;Financial Highlights -- Earnings/Share;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIAL HIGHLIGHTS;EARNINGS/SHARE; ; ;0;0;0;0

4. MSN;Financial Highlights -- Book Value/Share;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIAL HIGHLIGHTS;BOOK VALUE/SHARE; ; ;0;0;0;0

thank you,
Rene

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> They're working fine here -- what do you get with:
>
> =RCHGetElementNumber("Version&quot;)
> =smfGetAParms(41)
>
> On Thu, Mar 21, 2013 at 8:22 AM, rr76012 <rr76012@...> wrote:
>
> >
> > I am getting an "Error" message for these element numbers.
> >
> > = RCHGetElementNumber(A2, 41)
> >
> > = RCHGetElementNumber(A2, 44)
> >
> > = RCHGetElementNumber(A2, 45)
> >
> > Is there anything that I can do?
> > I really hope you have a solution?
> > Pls tell me I just need to update something???
> >
> >
>

Thu Mar 21, 2013 1:06 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not the most recent version of the add-in, but the element definitions look
correct.

What ticker symbols are returning "Error"?

If you exit and restart EXCEL, do you still get "Error" on those elements?
How about with ticker "MMM"?

Do you see a reasonable web page, filled with data, when you visit this URL
with the EXCEL Web Query dialog:

http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM

On Thu, Mar 21, 2013 at 9:06 AM, rr76012 <rr76012@yahoo.com> wrote:

> Hello Randy, I plugged your formulas into the spreadsheet, here are the
> answers I got.
>
> 1. Stock Market Functions add-in, Version 2.1.2012.01.30 (C:\Program
> Files\SMF Add-In; 1)
>
> 2. MSN;Financial Highlights -- Return on Equity;
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIALHIGHLIGHTS;RETURN ON EQUITY; ; ;0;0;0;0
>
> 3. MSN;Financial Highlights -- Earnings/Share;
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIALHIGHLIGHTS;EARNINGS/SHARE; ; ;0;0;0;0
>
> 4. MSN;Financial Highlights -- Book Value/Share;
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIALHIGHLIGHTS;BOOK VALUE/SHARE; ; ;0;0;0;0
>
>
>

Thu Mar 21, 2013 9:42 am (PDT) . Posted by:

"Jovica Bozic" jovica.bozic

Thank you so much for your time, there was a macro called "Replace". It's all sorted out now.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Ahhh. My email client is resolving the text differently than what you
> posted...see below.
>
> Doing a Google search, it seems to imply this would happen if you had your
> a duplicate REPLACE() function...? It should be coming from the Visual
> Basic for Applications DLL.
>
> On Mon, Mar 18, 2013 at 11:04 PM, Jovica Bozic <jovica.bozic@...>wrote:
>
> > Public Function smfGetWebPage(ByVal pURL As String, _
> > Optional ByVal pUseIE As Integer = 0, _
> > Optional ByVal pConvType As Integer = 0) As String
> >
> > '----------------------------------------------------------*
> > ' 2011.02.16 -- Add routine
> > ' 2011.04.27 -- Add HTML codes 0 thru 9
> >
> > '----------------------------------------------------------*
> > For iData = 1 To kPages
> > Select Case True
> > Case aData(iData, 1) = ""
> > s2 = RCHGetURLData(pURL, pUseIE)
> > Select Case pConvType
> > Case 0
> > this line-----> s2 = Replace(s2, "&", "&")
> > s2 = Replace(s2, " <b>", "<b> ")
> > s2 = Replace(s2, " ", " ")
> > s2 = Replace(s2, Chr(9), " ")
> > s2 = Replace(s2, Chr(10), "")
> > s2 = Replace(s2, Chr(13), "")
> >
> >
>

Thu Mar 21, 2013 11:09 am (PDT) . Posted by:

"rr76012" rr76012

Randy,

to update smf addin files, do we first need to delete all files here; c:\program files\smf addin\

or, do we just go to:

http://finance.groups.yahoo.com/group/smf_addin/files/Add-In%20Files/

and update?

I do not want to mess up your addin.

thanks

Thu Mar 21, 2013 1:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

No need to delete all the files, but it shouldn't hurt anything unless you
have added/changed files there. I wouldn't bother.

When you extract the new ZIP file, it will ask you if you want to replace
duplicate files. Just answer yes to all.

You should exit EXCEL first though.

On Thu, Mar 21, 2013 at 11:09 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> to update smf addin files, do we first need to delete all files here;
> c:\program files\smf addin\
>
> or, do we just go to:
>
> http://finance.groups.yahoo.com/group/smf_addin/files/Add-In%20Files/
>
> and update?
>
> I do not want to mess up your addin.
>

Thu Mar 21, 2013 12:23 pm (PDT) . Posted by:

"ds5ec" ds5ec

Hello
I'm using RCH_Stock_Market_Functions-2.1.2012.12.29 and trying to get the bid price using smfGetOptionQuotes in VBA. I first get the various strikes using smfGetOptionStrikes and then choose the one At The Money. I plug this into smfGetOptionQuotes as below but get "N/A". I can see that AAP has a valid bid price for this strike and expiration on Yahoo if I get the quote via the web page. I just can't see where I going wrong.
Thanks for your help
David

OptString = "AAP 4/20 2013 $80.00 Call"

BidPriceArr = smfGetOptionQuotes(pTickers:=OptString, _
pItems:="B", _
pSource:="Y", _
pDim1:=1, _
pDim2:=1)

Thu Mar 21, 2013 1:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That ticker symbol works fine here.

Do you have your Internet Options set up to always get a fresh copy of a
web page? Otherwise, the Internet retrieval process the add-in uses could
be picking up an old, cached copy of the web page.

On Thu, Mar 21, 2013 at 12:23 PM, ds5ec <ds5ec@yahoo.com> wrote:

> Hello
> I'm using RCH_Stock_Market_Functions-2.1.2012.12.29 and trying to get the
> bid price using smfGetOptionQuotes in VBA. I first get the various strikes
> using smfGetOptionStrikes and then choose the one At The Money. I plug this
> into smfGetOptionQuotes as below but get "N/A". I can see that AAP has a
> valid bid price for this strike and expiration on Yahoo if I get the quote
> via the web page. I just can't see where I going wrong.
> Thanks for your help
> David
>
> OptString = "AAP 4/20 2013 $80.00 Call"
>
> BidPriceArr = smfGetOptionQuotes(pTickers:=OptString, _
> pItems:="B", _
> pSource:="Y", _
> pDim1:=1, _
> pDim2:=1)
>

Fri Mar 22, 2013 2:03 am (PDT) . Posted by:

"ds5ec" ds5ec

I changed Internet options from 'Automatically&#39; to 'Every time I visit the page' but still get the "N/A" response to smfGetOptionQuotes. Other functions, such as smfGetOptionStrikes and smfGetOptionExpiry() are working. I've tried running the code on another PC (Windows 7, Excel 2007) with the Internet options set correctly and get the same result.

Is there anything else I can try?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That ticker symbol works fine here.
>
> Do you have your Internet Options set up to always get a fresh copy of a
> web page? Otherwise, the Internet retrieval process the add-in uses could
> be picking up an old, cached copy of the web page.
>
> On Thu, Mar 21, 2013 at 12:23 PM, ds5ec <ds5ec@...> wrote:
>
> > Hello
> > I'm using RCH_Stock_Market_Functions-2.1.2012.12.29 and trying to get the
> > bid price using smfGetOptionQuotes in VBA. I first get the various strikes
> > using smfGetOptionStrikes and then choose the one At The Money. I plug this
> > into smfGetOptionQuotes as below but get "N/A". I can see that AAP has a
> > valid bid price for this strike and expiration on Yahoo if I get the quote
> > via the web page. I just can't see where I going wrong.
> > Thanks for your help
> > David
> >
> > OptString = "AAP 4/20 2013 $80.00 Call"
> >
> > BidPriceArr = smfGetOptionQuotes(pTickers:=OptString, _
> > pItems:="B", _
> > pSource:="Y", _
> > pDim1:=1, _
> > pDim2:=1)
> >
>

Fri Mar 22, 2013 2:08 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Well, you would get "N/A" right now, because the market is closed...

Otherwise, did you try running the smfForceRecalculation macro? The add-in
also stores copies of web pages, so that if multiple items are needed from
the same web page, it only needs to retrieve the web page once. See the
LINKS area of the group for more info on the macro. You may still have an
old copy of the web page in the add-in, that needs to be purged and
refreshed.

On Fri, Mar 22, 2013 at 2:03 AM, ds5ec <ds5ec@yahoo.com> wrote:

> I changed Internet options from 'Automatically&#39; to 'Every time I visit the
> page' but still get the "N/A" response to smfGetOptionQuotes. Other
> functions, such as smfGetOptionStrikes and smfGetOptionExpiry() are
> working. I've tried running the code on another PC (Windows 7, Excel 2007)
> with the Internet options set correctly and get the same result.
>
> Is there anything else I can try?
>

Thu Mar 21, 2013 4:28 pm (PDT) . Posted by:

"T" thomas777crown

Thanks I did that and the numbers make more sense.
T.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Because the nature of an EMA is to build from the previous day's value, you
> need to give it more than 51 days to build a "true" 50-day EMA, to a point
> where the oldest data is no longer a factor. Try something like:
>
> =INDEX(smfTech(RCHGetYahooHistory("GRO",,,,,,,,,,1,1,300,6),"EMA",50),300)
>
> For 100, I'd do something like:
>
> =INDEX(smfTech(RCHGetYahooHistory("GRO",,,,,,,,,,1,1,500,6),"EMA",100),500)
>
> On Tue, Mar 19, 2013 at 9:52 PM, T <thomas777crown@...> wrote:
>
> > =INDEX(smfTech(RCHGetYahooHistory("GRO",,,,,,,,,,1,1,51,6),"EMA",50),51)
> >
> > I keep on getting the wrong value for the moving average for 50 days. Is
> > this the right formula to get an Exponential moving average for the last 50
> > days. Also what would be the right formula for 100 days as well.
> >
>

Diposting oleh EXCEL FEED LEARNING di 02.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)