15 New Messages
Digest #2363
Messages
Sat Oct 6, 2012 12:50 pm (PDT) . Posted by:
"dgoyal" dgoyal
You can get data for periods other than 15 days by adding "&p1=number of days" to your URL. For example, to get 16 days, you will use following URL.
http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple&p1=16
--- In smf_addin@yahoogroups.com , bushpilote@... wrote:
>
>
> You are welcomed.
> --- In smf_addin@yahoogroups.com , "smithjhhic" <smithjhhic@> wrote:
> >
> > Thank you very much for your help.
> >
> >
> > --- In smf_addin@yahoogroups.com , "bushpilote" <bushpilote@> wrote:
> > >
> > > Hi,
> > > try this for the 14-day data:
> > >
> > > =RCHGetTableCell($C$4,C$5,"<body",,,,$B13,,,"--")
> > >
> > > where $C$4 = http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> > >
> > > C$5:J$5 = Column numbers starting with 1 ending with 8 in increments of 1 (there are 8 columns of data in the table)
> > >
> > > $B13:$B84 = row numbers starting from 8 ending with 79 in increments of one (there are 72 rows of data in the table including headings). One to seven (B6:B12) returns a combination of blanks, explanatory data and duplicate headings.
> > >
> > > Copy the formula in C5:B84.
> > >
> > > PS There's nothing sacred about starting in cells C4,C5 and B13.
> > >
> > > Can't help you with the "other than 14-day" question.
> > >
> > > Cheers.
> > >
> > > --- In smf_addin@yahoogroups.com , "smithjhhic" <smithjhhic@> wrote:
> > > >
> > > > Hello,
> > > > I am trying to return "14-day SBV" and "14-day Volume MA" for the latest date (see site link below). There were some emails post relating to this site from 2009, but I was unable to apply those to my request. Also, the site allows the user to change the bar period from 14 day to another value (ie. 16 day). Is there away to use something other than 14 day with the addin? I appreciate any help you could provide.
> > > >
> > > > http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> > > >
> > >
> >
>
http://www.marketvo
--- In smf_addin@yahoogrou
>
>
> You are welcomed.
> --- In smf_addin@yahoogrou
> >
> > Thank you very much for your help.
> >
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Hi,
> > > try this for the 14-day data:
> > >
> > > =RCHGetTableCell(
> > >
> > > where $C$4 = http://www.marketvo
> > >
> > > C$5:J$5 = Column numbers starting with 1 ending with 8 in increments of 1 (there are 8 columns of data in the table)
> > >
> > > $B13:$B84 = row numbers starting from 8 ending with 79 in increments of one (there are 72 rows of data in the table including headings). One to seven (B6:B12) returns a combination of blanks, explanatory data and duplicate headings.
> > >
> > > Copy the formula in C5:B84.
> > >
> > > PS There's nothing sacred about starting in cells C4,C5 and B13.
> > >
> > > Can't help you with the "other than 14-day" question.
> > >
> > > Cheers.
> > >
> > > --- In smf_addin@yahoogrou
> > > >
> > > > Hello,
> > > > I am trying to return "14-day SBV" and "14-day Volume MA" for the latest date (see site link below). There were some emails post relating to this site from 2009, but I was unable to apply those to my request. Also, the site allows the user to change the bar period from 14 day to another value (ie. 16 day). Is there away to use something other than 14 day with the addin? I appreciate any help you could provide.
> > > >
> > > > http://www.marketvo
> > > >
> > >
> >
>
Sat Oct 6, 2012 1:44 pm (PDT) . Posted by:
"Ron Spruell" hashky
One of the messages in the group said it worked on linux using VirtualBox.
Ron Spruell
>________________________________
> From: lamb_cal <clamb777@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, September 28, 2012 6:02 PM
>Subject: [smf_addin] Re: Using smf on a mac
>
>
>
>SAME!
>
>--- In smf_addin@yahoogroups.com , "red_rackam" <red_rackam@...> wrote:
>>
>> Hi,
>>
>> Has anyone ever tried this on a mac ? I am getting an error stating - can't find project or library
>>
>> This is what the window looks like -
>>
>> Microsoft Office 14.0 Object libray
>> MISSING: Microsoft Internet Controls
>> MISSING: Microsoft XML, v3.0
>> MISSING: Microsoft HTML Object Library
>>
>
>
>
>
>
Ron Spruell
>___________
> From: lamb_cal <clamb777@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, September 28, 2012 6:02 PM
>Subject: [smf_addin] Re: Using smf on a mac
>
>
>
>SAME!
>
>--- In smf_addin@yahoogrou
>>
>> Hi,
>>
>> Has anyone ever tried this on a mac ? I am getting an error stating - can't find project or library
>>
>> This is what the window looks like -
>>
>> Microsoft Office 14.0 Object libray
>> MISSING: Microsoft Internet Controls
>> MISSING: Microsoft XML, v3.0
>> MISSING: Microsoft HTML Object Library
>>
>
>
>
>
>
Sat Oct 6, 2012 1:50 pm (PDT) . Posted by:
"Ron Spruell" hashky
=RCHGetElementNumbe
=RCHGetElementNumbe
>___________
> From: Shrek <newsletters@
>To: smf_addin@yahoogrou
>Sent: Friday, September 21, 2012 8:54 PM
>Subject: [smf_addin] Cannot get MSN data
>
>
>
>Hi.
>
>I just learned about the data downloading. I am running into an issue similar to
>
>http://finance.
>
>I just downloaded and installed everything a few days ago so I should have the latest. I verified that the codes are the same by following the links from the above post.
>
>I am trying to get MSN Earnings Estimates Growth Rates. Specifically, my cell would look like this:
>
>=RCHGetElementNumb
>
>(I ultimately want 430, 431, 432, 433 but none of them work.)
>
>but it always returns "Error". I can get the information from Yahoo by using
>
>=RCHGetElementNumb
>
>but for many companies, they are vastly different numbers. Just saying. So we want the MSN values.
>
>What do I need to do to get the MSN values?
>
>Thanks.
>
>
>
>
>
Sat Oct 6, 2012 3:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There was a reply in that thread that probably has the answer to your
problem:
http://finance.groups.yahoo.com/group/smf_addin/message/19858
On Fri, Sep 21, 2012 at 6:54 PM, Shrek <newsletters@exactlymypoint.com >wrote:
>
> I just learned about the data downloading. I am running into an issue
> similar to
>
> http://finance.groups.yahoo.com/group/smf_addin/message/19853
>
> I just downloaded and installed everything a few days ago so I should have
> the latest. I verified that the codes are the same by following the links
> from the above post.
>
> I am trying to get MSN Earnings Estimates Growth Rates. Specifically, my
> cell would look like this:
>
> =RCHGetElementNumber("AAPL", 430)
>
> (I ultimately want 430, 431, 432, 433 but none of them work.)
>
> but it always returns "Error". I can get the information from Yahoo by
> using
>
> =RCHGetElementNumber("AAPL", 601)
>
> but for many companies, they are vastly different numbers. Just saying.
> So we want the MSN values.
>
> What do I need to do to get the MSN values?
>
problem:
http://finance.
On Fri, Sep 21, 2012 at 6:54 PM, Shrek <newsletters@
>
> I just learned about the data downloading. I am running into an issue
> similar to
>
> http://finance.
>
> I just downloaded and installed everything a few days ago so I should have
> the latest. I verified that the codes are the same by following the links
> from the above post.
>
> I am trying to get MSN Earnings Estimates Growth Rates. Specifically, my
> cell would look like this:
>
> =RCHGetElementNumbe
>
> (I ultimately want 430, 431, 432, 433 but none of them work.)
>
> but it always returns "Error". I can get the information from Yahoo by
> using
>
> =RCHGetElementNumbe
>
> but for many companies, they are vastly different numbers. Just saying.
> So we want the MSN values.
>
> What do I need to do to get the MSN values?
>
Sat Oct 6, 2012 1:53 pm (PDT) . Posted by:
"Ron Spruell" hashky
Files in the "Works-in-Progress" folder for the latest version of the addin.
>________________________________
> From: tchconsulting <tchconsulting@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Monday, September 24, 2012 5:01 PM
>Subject: [smf_addin] Excel Add-In
>
>
>
>I would like to try the Add-In
>How do I get access to it?
>
>
>
>
>
>___________
> From: tchconsulting <tchconsulting@
>To: smf_addin@yahoogrou
>Sent: Monday, September 24, 2012 5:01 PM
>Subject: [smf_addin] Excel Add-In
>
>
>
>I would like to try the Add-In
>How do I get access to it?
>
>
>
>
>
Sat Oct 6, 2012 2:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see a way to pick up the data, because the web page is generated
dynamically via JavaScript.
On Wed, Sep 19, 2012 at 6:48 PM, jhyde.oregon <jhyde@peak.org> wrote:
>
> Do you have an smf_addin template that can access the Morningstar free
> "Market Fair Value" data located at this URL?
>
> http://www.morningstar.com/market-valuation/market-fair-value-graph.aspx
>
> This data is only for the overall market and subsectors, not individual
> stocks or funds, but it doesn't require premium access.
>
dynamically via JavaScript.
On Wed, Sep 19, 2012 at 6:48 PM, jhyde.oregon <jhyde@peak.org> wrote:
>
> Do you have an smf_addin template that can access the Morningstar free
> "Market Fair Value" data located at this URL?
>
> http://www.mornings
>
> This data is only for the overall market and subsectors, not individual
> stocks or funds, but it doesn't require premium access.
>
Sat Oct 6, 2012 2:02 pm (PDT) . Posted by:
"Ron Spruell" hashky
Randy runs Excel 2007 on Vista. I don't know if it is 32 or 64 bit.
Here is a step-by-step that I wrote for 2010 on XP. It may help.
http://bribg.pbworks.com/w/file/50396066/Step-by-Step%20SMF%20Add-In.doc
http://tinyurl.com/7tkwntx
Ron Spruell
>________________________________
> From: confusciousficorp <confusciousficorp@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, September 28, 2012 7:25 PM
>Subject: [smf_addin] Installing on Win 7 (64 bit) with Excel 2007 Instructions
>
>
>
>Hi there,
>
>I am looking at this and want to install it on my machine but can't seem to find clear guidance on installing on a Win 7 (64 bit) machine running excel 2007.
>
>The Add-In Overview (that I have seen so far) refers to Excel 2002 and I see from the strings that there are some possible problems installing on my set up.
>
>Can anyone help with any kind of step by step install instruction on the setup above?
>
>
>
>
>
Here is a step-by-step that I wrote for 2010 on XP. It may help.
http://bribg.
http://tinyurl.
Ron Spruell
>___________
> From: confusciousficorp <confusciousficorp@
>To: smf_addin@yahoogrou
>Sent: Friday, September 28, 2012 7:25 PM
>Subject: [smf_addin] Installing on Win 7 (64 bit) with Excel 2007 Instructions
>
>
>
>Hi there,
>
>I am looking at this and want to install it on my machine but can't seem to find clear guidance on installing on a Win 7 (64 bit) machine running excel 2007.
>
>The Add-In Overview (that I have seen so far) refers to Excel 2002 and I see from the strings that there are some possible problems installing on my set up.
>
>Can anyone help with any kind of step by step install instruction on the setup above?
>
>
>
>
>
Sat Oct 6, 2012 2:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The defined elements are only for non-financial companies, as financial
companies have vastly different line items.
On Tue, Sep 18, 2012 at 11:13 AM, tarun_1457 <tarunparmar@gmail.com > wrote:
>
> I was working with RCHGetElementNumber() and came across a minor problem
> where Source AdvFN-A (#7096) reads "Cash End of Period -- FY1". But AdvFN
> website has a typo for Banking related companies e.g. BAC, JPM etc. read
> "Cash At End of Period".
>
> I then tried to add up "Net Change in Cash & Equivalents" and "Cash At
> Beginning of Period" to get 'Cash at End of Period'. But it does not show
> values under any of these columns.
>
> Sample: =RCHGetElementNumber("BAC",7076) or
> =RCHGetElementNumber("JPM",7086)
>
companies have vastly different line items.
On Tue, Sep 18, 2012 at 11:13 AM, tarun_1457 <tarunparmar@
>
> I was working with RCHGetElementNumber
> where Source AdvFN-A (#7096) reads "Cash End of Period -- FY1". But AdvFN
> website has a typo for Banking related companies e.g. BAC, JPM etc. read
> "Cash At End of Period".
>
> I then tried to add up "Net Change in Cash & Equivalents" and "Cash At
> Beginning of Period" to get 'Cash at End of Period'. But it does not show
> values under any of these columns.
>
> Sample: =RCHGetElementNumbe
> =RCHGetElementNumbe
>
Sat Oct 6, 2012 2:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Can you do EXCEL Web Queries?
On Fri, Sep 21, 2012 at 12:04 PM, futurehou <futurehou@hotmail.com > wrote:
> I have using the addin without problems for several years. However i have
> a new newtwork security device now and it appears to block SMF_addin.
> Tried the 'version' test and all is well. I have spent hours checking my
> firewall for problems but still the macro refuses to even return the simple
> stock price. Any ideas?
>
On Fri, Sep 21, 2012 at 12:04 PM, futurehou <futurehou@hotmail.
> I have using the addin without problems for several years. However i have
> a new newtwork security device now and it appears to block SMF_addin.
> Tried the 'version' test and all is well. I have spent hours checking my
> firewall for problems but still the macro refuses to even return the simple
> stock price. Any ideas?
>
Sat Oct 6, 2012 2:14 pm (PDT) . Posted by:
"Ron Spruell" hashky
Use a 2 row by 14 column array. The ticker symbol is the Option Ticker Symbol not the underlying Ticker Symbol. See page 14 in the documentation.
Ron Spruell
>________________________________
> From: marcossouza4955 <m_martins_souza@hotmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, September 30, 2012 8:30 PM
>Subject: [smf_addin] Problems with smfGetOptionQuotes
>
>
>
>All,
>
>I'm using Windows 7 64bits MS Office 2010 64bits. Sorry for the extra details but I just want make sure the pluggin is compatible.
>
>I'm trying the following, however, all that I get as result is a single cell where it says "Ticker Symbol". Any advice?
>
>=smfGetOptionQuotes("C","zbaefsvx123456",1, 1)
>
>Thanks, Marcos.
>
>
>
>
>
Ron Spruell
>___________
> From: marcossouza4955 <m_martins_souza@
>To: smf_addin@yahoogrou
>Sent: Sunday, September 30, 2012 8:30 PM
>Subject: [smf_addin] Problems with smfGetOptionQuotes
>
>
>
>All,
>
>I'm using Windows 7 64bits MS Office 2010 64bits. Sorry for the extra details but I just want make sure the pluggin is compatible.
>
>I'm trying the following, however, all that I get as result is a single cell where it says "Ticker Symbol". Any advice?
>
>=smfGetOptionQuote
>
>Thanks, Marcos.
>
>
>
>
>
Sat Oct 6, 2012 3:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As Ron noted, you need to array-enter the formula.
But that's not any kind of valid parameter for a ticker or ticker list, and
not a valid value for the source of the data (so it would default to Yahoo
as the data source). So all you'd get back is a row of headers for the
columns and everything else blank.
On Sun, Sep 30, 2012 at 6:30 PM, marcossouza4955 <
m_martins_souza@hotmail.com > wrote:
>
> I'm using Windows 7 64bits MS Office 2010 64bits. Sorry for the extra
> details but I just want make sure the pluggin is compatible.
>
> I'm trying the following, however, all that I get as result is a single
> cell where it says "Ticker Symbol". Any advice?
>
> =smfGetOptionQuotes("C","zbaefsvx123456",1, 1)
>
But that's not any kind of valid parameter for a ticker or ticker list, and
not a valid value for the source of the data (so it would default to Yahoo
as the data source). So all you'd get back is a row of headers for the
columns and everything else blank.
On Sun, Sep 30, 2012 at 6:30 PM, marcossouza4955 <
m_martins_souza@
>
> I'm using Windows 7 64bits MS Office 2010 64bits. Sorry for the extra
> details but I just want make sure the pluggin is compatible.
>
> I'm trying the following, however, all that I get as result is a single
> cell where it says "Ticker Symbol". Any advice?
>
> =smfGetOptionQuotes
>
Sat Oct 6, 2012 2:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but i have no access to the web page to see what's going on.
On Sun, Sep 23, 2012 at 9:57 AM, nhatnam4 <nhatnam4@yahoo.com > wrote:
> I'm trying to get this formula to work with a "Ticker" name input, but
> can't seem to make it work. I tried replacing "IBM" with "&Ticker&". But
> no luck. Please help.
>
> ="Market Edge Recommendation: "&MID(RCHGetWebData("
> https://ameritradew.marketedge.com/Weekly/Stock/S/IBM.asp?from=1&sym=IBM&r=0 ","Stock
> is"),1,(SEARCH("</td>",RCHGetWebData("
> https://ameritradew.marketedge.com/Weekly/Stock/S/IBM.asp?from=1&sym=IBM&r=0 ","Stock
> is")))-2)
>
On Sun, Sep 23, 2012 at 9:57 AM, nhatnam4 <nhatnam4@yahoo.
> I'm trying to get this formula to work with a "Ticker" name input, but
> can't seem to make it work. I tried replacing "IBM" with "&Ticker&". But
> no luck. Please help.
>
> ="Market Edge Recommendation: "&MID(RCHGetWebData
> https://ameritradew
> is"),1,(SEARCH(
> https://ameritradew
> is")))-2)
>
Sat Oct 6, 2012 2:21 pm (PDT) . Posted by:
"Ron Spruell" hashky
I didn't know how long you were going to be AWOL, so I started trying to answer some of the questions that I thought I knew the answers.
Ron Spruell
Ron Spruell
Sat Oct 6, 2012 2:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Appreciate it. I was in the hospital for 4 days and then rehab for 17 days,
because of a continuing leg/knee problem. Still not solved, and won't be
unless I lose a lot of weight, but at least I can transfer well enough to
get around.
On Sat, Oct 6, 2012 at 2:21 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I didn't know how long you were going to be AWOL, so I started trying to
> answer some of the questions that I thought I knew the answers.
>
because of a continuing leg/knee problem. Still not solved, and won't be
unless I lose a lot of weight, but at least I can transfer well enough to
get around.
On Sat, Oct 6, 2012 at 2:21 PM, Ron Spruell <hashky@yahoo.
>
> I didn't know how long you were going to be AWOL, so I started trying to
> answer some of the questions that I thought I knew the answers.
>
Sat Oct 6, 2012 2:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That formula works fine for me.
On Thu, Sep 27, 2012 at 6:53 AM, back <backmehl@yahoo.de > wrote:
>
> i tried:
>
> =RCHGetHTMLTable("
> http://product.datastream.com/navigator/HelpFiles/DatatypeDefinitions/en/0/WC08245.htm ";
> "Applies To";-1;"";1)
>
> ... but it doesn't work ...
>
On Thu, Sep 27, 2012 at 6:53 AM, back <backmehl@yahoo.
>
> i tried:
>
> =RCHGetHTMLTable(
> http://product.
> "Applies To";-1;"";1)
>
> ... but it doesn't work ...
>
Tidak ada komentar:
Posting Komentar