Senin, 04 Februari 2013

[smf_addin] Digest Number 2495[1 Attachment]

15 New Messages

Digest #2495
1a
Re: Excel 32bit vs 64bit by "another_investor" another_investor
2b
2d
3a
Re: Overbought - Oversold data by "Stephan Moebius" spikemgm
3b
Re: Overbought - Oversold data [1 Attachment] by "Randy Harmelink" rharmelink
4b
Re: Basic user manual for newbies/idiots? by "Randy Harmelink" rharmelink
4d
Re: Basic user manual for newbies/idiots? by "Randy Harmelink" rharmelink
5a
Re: Historical Quote Auto Populate by "Hendra Raghani" hendra_raghani_2000
5b
Re: Historical Quote Auto Populate by "Randy Harmelink" rharmelink
6a
Real time quotes by "jack.baron41" jack.baron41
6b
Re: Real time quotes by "Randy Harmelink" rharmelink

Messages

Mon Feb 4, 2013 8:25 am (PST) . Posted by:

"another_investor" another_investor

Thank you very much for the replies.

--- In smf_addin@yahoogroups.com, Douglas Husemann wrote:
>
> 1). Is a matter of debate,
> 2) you can make workbooks that may be to large to open in 32 bit excel. Although I doubt that will be an issue with the data being used.
>
> 3). Been switching between 32 bit and 64 bit office 2010 &2013 (365) without any issues,
>
> Sent from my Windows Phone
> ________________________________
> From: Randy Harmelink
> Sent: ‎2/‎4/‎2013 7:05 AM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Excel 32bit vs 64bit
>
> I can't be of help there, as I have no experience in that area. Sorry.
>
> On Mon, Feb 4, 2013 at 3:54 AM, another_investor
> wrote:
>
> > Hi Randy (et al),
> > I have been using your excellent plugin on Windows 7 64-bit with Excel
> > 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig
> > and was considering making the switch to 64-bit Office 2010/2013 to take
> > advantage of the increased RAM.
> >
> > Questions that spring to mind include:
> > 1) Is this advisable please?
> > 2) Any known limitations/issues?
> > 3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel
> > machine, could I reuse the same workbook on my 32-bit Excel installation
> > (desktop excel would be 64-bit while my work laptop is 32-bit excel and I
> > would like to be able to use the same workbook on both).
> >
> > Any advise or recommendations would be great. I will always take stability
> > over performance!
> >
>

Mon Feb 4, 2013 9:45 am (PST) . Posted by:

"Jacob Jose" pepecan47

Is there a way to get annual dividends payed using the RCHGetYahooHistory() function?
 
I would like to have the total dividend payed in 2012, 2011, 2010, etc
 
I tried
 
=RCHGetYahooHistory("MCD",2012,1,1,2012,12,31,"v","c",0,1,1)
 
I get a value
 
41242
 
If I use SMF-Template-Yahoo-Historical-Quotes.xls, with same values, I get the right dates and the dividends.
 
Regards,
Jose L. Jacob

Mon Feb 4, 2013 11:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd need to array-enter the formula over a range and then compute the
annual totals yourself from the data that gets returned.

On Mon, Feb 4, 2013 at 10:45 AM, Jacob Jose pepecan47@yahoo.ca> wrote:

>
> Is there a way to get annual dividends payed using the
> RCHGetYahooHistory() function?
>
> I would like to have the total dividend payed in 2012, 2011, 2010, etc
>
> I tried
>
> =RCHGetYahooHistory("MCD",2012,1,1,2012,12,31,"v","c",0,1,1)
>
> I get a value
>
> 41242
>
> If I use SMF-Template-Yahoo-Historical-Quotes.xls, with same values, I get
> the right dates and the dividends.
>
>

Mon Feb 4, 2013 11:57 am (PST) . Posted by:

"Jacob Jose" pepecan47

Hi Randy - since I am using
 
=AVERAGE(RCHGetYahooHistory(A3,,,,,,,,"C",0,1,,50,1))
 
to compute the 50 days MA without having to array-enter the formula, I thought that something similar could be used to get the annual dividends.
 
Is it possible to use something similar?

Regards,
Jose L. Jacob

________________________________
From: Randy Harmelink rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, February 4, 2013 2:40:00 PM
Subject: Re: [smf_addin] RCHGetYahooHistory() to get annual dividends

 
You'd need to array-enter the formula over a range and then compute the annual totals yourself from the data that gets returned.

On Mon, Feb 4, 2013 at 10:45 AM, Jacob Jose pepecan47@yahoo.ca> wrote:

>
>Is there a way to get annual dividends payed using the RCHGetYahooHistory() function?

>I would like to have the total dividend payed in 2012, 2011, 2010, etc

>I tried

>=RCHGetYahooHistory("MCD",2012,1,1,2012,12,31,"v","c",0,1,1)

>I get a value

>41242

>If I use SMF-Template-Yahoo-Historical-Quotes.xls, with same values, I get the right dates and the dividends.

Mon Feb 4, 2013 12:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It might be possible, but it would not be trivial. And to do annual periods
would require multiple functions (and multiple Internet accesses). It would
be much easier to retrieve the array into the workbook and then sum the
correct pieces up.

On Mon, Feb 4, 2013 at 12:56 PM, Jacob Jose pepecan47@yahoo.ca> wrote:

>
> Hi Randy - since I am using
>
> =AVERAGE(RCHGetYahooHistory(A3,,,,,,,,"C",0,1,,50,1))
>
> to compute the 50 days MA without having to array-enter the formula, I
> thought that something similar could be used to get the annual dividends.
>
> Is it possible to use something similar?
>
>

Mon Feb 4, 2013 12:51 pm (PST) . Posted by:

"Stephan Moebius" spikemgm

Hi Randy,

Thanks for the reply, I'm trying to pull just the 14 day relative strength
number, where 1266 is the number according to temples page.

=rchgettablecell("http://www.barchart.com/technicals/etf/spy,1266")

It returns #Value!, don't know what I'm doing wrong.

Here's my sheet. using csvfile for last thru volume and yahoohistory for
10day vol lookback, there are around 50etfs

Thanks for your help.
Steve
On Sat, Feb 2, 2013 at 10:33 PM, Randy Harmelink rharmelink@gmail.com>wrote:

> **
>
>
> RSI is a pretty vague term. There are so many applications of it.
>
> But BarChart has a bunch of them -- examples are in a template in the
> FILES area of the group:
>
> http://www.barchart.com/technicals/stocks/MMM
>
>
> On Sat, Feb 2, 2013 at 11:04 PM, MoeB smoebius@gmail.com> wrote:
>
>>
>> Do you know of any site to get data for the RSI numbers, or any
>> overbought - oversold data number.
>>
>
>
>
Attachments with this message:
1 of 1 Photo(s)

Mon Feb 4, 2013 12:59 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You should be using the RCHGetElementNumber() function, with the ticker
symbol and element number:

=RCHGetElementNumber("SPY";,1266)

On Mon, Feb 4, 2013 at 1:51 PM, Stephan Moebius smoebius@gmail.com> wrote:

>
> Thanks for the reply, I'm trying to pull just the 14 day relative strength
> number, where 1266 is the number according to temples page.
>
> =rchgettablecell("http://www.barchart.com/technicals/etf/spy,1266")
>
> It returns #Value!, don't know what I'm doing wrong.
>
>

Mon Feb 4, 2013 4:57 pm (PST) . Posted by:

"bingouser" bingouser

Hi Randy,

New member here. Great add-in--thanks for making it available. But when I go to the Documentation section and click on pretty much any link, I get a "Document Not Found" page. Was the folder moved?

Also, if I try to sort a table in an array or add a row to it, I get a message saying, "You cannot change part of an array." Other than referencing the array cells on another sheet, is there a way to sort the list, add/delete rows, etc.? Or a function in the workbook to import Yahoo data without using an array?

Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I believe all of the function documentation, found in the "Documentation"
> folder of the files area have (simple) examples of that function in them.
> Think of the functions as building blocks.
>
> The RCHGetYahooQuotes() documentation also has a pointer to a step-by-step
> example of creating a current quotes table (which is also item 2 pointed to
> in the LINKS area of the Yahoo group).
>
> Since I know you also deal with options, there is also an item in the LINKS
> area of the Yahoo group that is an overview of using some of the various
> option functions.
>
> On Sat, Feb 2, 2013 at 5:57 PM, lenpetry wrote:
>
> > Hi everyone, and especially Randy.
> >
> > Is there a manual, giving step-by-step instructions for setting up a file
> > that (for my purposes) drags stock quotes automatically into an Excel
> > (2007), and other data that I might deem important?
> >
> > I look at the documents saved in the Files section, but they all seem
> > addressed to more advanced people looking to solve specific problems in
> > documents they have already set up.
> >
>

Mon Feb 4, 2013 5:02 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The "Document not found" is usually just a temporary error on Yahoo's part.
I just tried a few and they work for me now.

You can't sort or add/delete rows within an array-entered area. There are
work-arounds, but they depend on the specifics of what you want to do. I
mention one possible work-around here:

http://finance.groups.yahoo.com/group/smf_addin/message/20879

On Mon, Feb 4, 2013 at 5:31 PM, bingouser bingouser@yahoo.com> wrote:

>
> New member here. Great add-in--thanks for making it available. But when I
> go to the Documentation section and click on pretty much any link, I get a
> "Document Not Found" page. Was the folder moved?
>
> Also, if I try to sort a table in an array or add a row to it, I get a
> message saying, "You cannot change part of an array." Other than
> referencing the array cells on another sheet, is there a way to sort the
> list, add/delete rows, etc.? Or a function in the workbook to import Yahoo
> data without using an array?
>

Mon Feb 4, 2013 6:53 pm (PST) . Posted by:

"bingouser" bingouser

Thanks.

When using the Yahoo historical function, is it possible to get more than one ticker at a time (with a small range of dates)?

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> The "Document not found" is usually just a temporary error on Yahoo's part.
> I just tried a few and they work for me now.
>
> You can't sort or add/delete rows within an array-entered area. There are
> work-arounds, but they depend on the specifics of what you want to do. I
> mention one possible work-around here:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/20879
>
> On Mon, Feb 4, 2013 at 5:31 PM, bingouser wrote:
>
> >
> > New member here. Great add-in--thanks for making it available. But when I
> > go to the Documentation section and click on pretty much any link, I get a
> > "Document Not Found" page. Was the folder moved?
> >
> > Also, if I try to sort a table in an array or add a row to it, I get a
> > message saying, "You cannot change part of an array." Other than
> > referencing the array cells on another sheet, is there a way to sort the
> > list, add/delete rows, etc.? Or a function in the workbook to import Yahoo
> > data without using an array?
> >
>

Mon Feb 4, 2013 7:00 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd need to use a separate function for each ticker symbol. There'd be no
reason to do multiple ticker symbols in a single function, since each
ticker symbol would require its own Internet request for data.

Keep in mind you don't need dates if you want quotes ending with the most
recent date available.

Two other functions you may want to look at -- smfPricesByDates() and
smfPricesBetween(). Depending on what you're doing with your range of
dates, those may be easier to use than RCHGetYahooHistory()

On Mon, Feb 4, 2013 at 7:53 PM, bingouser bingouser@yahoo.com> wrote:

>
> When using the Yahoo historical function, is it possible to get more than
> one ticker at a time (with a small range of dates)?
>

Mon Feb 4, 2013 7:19 pm (PST) . Posted by:

"Hendra Raghani" hendra_raghani_2000

Hi Randy and Michael,

Thanks for the help. I've got the file, but when I wanted to change the
variables, I got an error saying I can't change part of an array. Any
idea what did I do wrongly?

Cheers,
Hendra

On 4/2/2013 11:39 PM, Michael Thomas wrote:
> Try using the "monthly" variable,
> =RCHGetYahooHistory(D$1,D$4,D$5,1,A$2,A$3,1,"m","A",0,0,1)
>
> ----------------------------------------------------------
> *From:* Randy Harmelink rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Sunday, February 3, 2013 6:02 PM
> *Subject:* Re: [smf_addin] Historical Quote Auto Populate
>
> If all you need is closing quotes once a month, you'd be best off
> using the RCHGetYahooQuotes() function at the end of the month. It can
> grab data on up to 200 stocks at a time with a single Internet access.
> Very fast.
>
> The add-in functions typically automatically recalculate when you open
> a workbook.
>
> The functions mean you don't need to do the copy and paste from the
> website.
>
> On Sun, Feb 3, 2013 at 6:53 PM, Hendra Raghani
> hendra_raghani@hotmail.com hendra_raghani@hotmail.com>> wrote:
>
>
> Thanks for your replies. I actually did find the file before
> posting the questions but am not as savvy in Excel to tinker
> withe the VBA resources. What I meant was, I wanted to know how
> did some people leave their Excel documents to auto populate as
> new information is available online - instead of hopping over to
> the website , select, copy and paste it in Excel.
>
> I took a look at the RCHGetYahooHistory(), but how do you modify
> it such that I don't get the daily updates. I only need the data
> once a month, which is the closing price.
>
>
>
>
>

Mon Feb 4, 2013 7:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd need to re-enter the entire array, over it's entire range of cells.

You can extend the range, but you can't make it smaller. If you want to
make the range smaller, you'll need to delete the original array-entered
range, and then re-enter the array over the smaller range.

On Mon, Feb 4, 2013 at 8:19 PM, Hendra Raghani
hendra_raghani@hotmail.com>wrote:

>
> Thanks for the help. I've got the file, but when I wanted to change the
> variables, I got an error saying I can't change part of an array. Any idea
> what did I do wrongly?
>

Mon Feb 4, 2013 9:49 pm (PST) . Posted by:

"jack.baron41" jack.baron41

I subscribe to Yahoo's Real Time Quotes and I would like to take advantage of the service using the SMF Add_In. I have installed SMF in Excel 2003, Windows XP pro. The Add-In works fine, and I did find mention of the ECNs in the Yahoo Codes used for column headings, but I found no mention of how to set the update frequency (1 sec, 10 sec, 30 sec, ...). I installed SMF after the market closed, so I haven't seen it in action yet, but the static condition looks okay.

Mon Feb 4, 2013 10:19 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The ECN items are obsolete, at least as far as I know.

However, it's my understanding that if you create the security cookies
using the EXCEL Web Query dialog or IE, then the RCHGetYahooQuotes()
function returns real-time quotes for the normal data code (e.g. "l1" for
last price).

On Mon, Feb 4, 2013 at 10:38 PM, jack.baron41 jack_baron@comcast.net>wrote:

> I subscribe to Yahoo's Real Time Quotes and I would like to take advantage
> of the service using the SMF Add_In. I have installed SMF in Excel 2003,
> Windows XP pro. The Add-In works fine, and I did find mention of the ECNs
> in the Yahoo Codes used for column headings, but I found no mention of how
> to set the update frequency (1 sec, 10 sec, 30 sec, ...). I installed SMF
> after the market closed, so I haven't seen it in action yet, but the static
> condition looks okay.
>

Tidak ada komentar:

Posting Komentar