Messages In This Digest (19 Messages)
- 1a.
- Re: FX Rates From: bushpilote
- 1b.
- Re: FX Rates From: Randy Harmelink
- 2a.
- Re: Incorrect Ex-Dividend Date extraction From: Phil
- 3.1.
- Re: RCHGetYahooQuotes() From: rajeshparsekar1972
- 3.2.
- Re: RCHGetYahooQuotes() From: Randy Harmelink
- 4a.
- Advice and guidence on smf functions From: rajeshparsekar1972
- 4b.
- Re: Advice and guidence on smf functions From: Randy Harmelink
- 5a.
- Keep getting can't find SMF add in folder. From: colobuyer123
- 5b.
- Re: Keep getting can't find SMF add in folder. From: Randy Harmelink
- 5c.
- Re: Keep getting can't find SMF add in folder. From: Keys Tinney
- 5d.
- Re: Keep getting can't find SMF add in folder. From: Randy Harmelink
- 5e.
- Re: Keep getting can't find SMF add in folder. From: Keys Tinney
- 5f.
- Re: Keep getting can't find SMF add in folder. From: Randy Harmelink
- 5g.
- Re: Keep getting can't find SMF add in folder. From: Keys Tinney
- 5h.
- Re: Keep getting can't find SMF add in folder. From: Randy Harmelink
- 5i.
- Re: Keep getting can't find SMF add in folder. From: Keys Tinney
- 5j.
- Re: Keep getting can't find SMF add in folder. From: Keys Tinney
- 6a.
- Historical US GDP by Quarter From: mad money
- 6b.
- Re: Historical US GDP by Quarter From: Randy Harmelink
Messages
- 1a.
-
Re: FX Rates
Posted by: "bushpilote" bushpilote@yahoo.ca bushpilote
Tue Jun 7, 2011 5:13 am (PDT)
Thanks for the quick reply Randy.
Works fine for you meaning that you are getting USDEUR rate of .6848?
At my end the formula results in "Jul.Day". Formatting the cell in not an issue.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That works fine for me...
>
> On Mon, Jun 6, 2011 at 7:50 AM, bushpilote <bushpilote@...> wrote:
>
> >
> > I'm been unable to retrieve FX rates for specific dates (not a range)from
> > http://fx.sauder. ubc.ca/data using the following formula:
> >
> > RCHGetHTMLTable("
> > http://fx.sauder.ubc.ca/cgi/ fxdata?b= USD&c=EUR& rd=&fd=3& fm=6&fy=2011& ld=3&lm=6& ly=2011&y= daily&q=p& f=HTML
> > ","Wdy",-1,"",1).
> >
> > I've read all of the previous comments posted on your site on how to go
> > about doing it and still can't get it to work.
> >
> > What am I missing here?
> >
>
- 1b.
-
Re: FX Rates
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 7:13 am (PDT)
You need to array-enter the formula over a range -- here's the result I get:
Jul.Day YYYY/MM/DD Wdy EUR/USD 2455716 2011/06/03 Fri 0.68475
But if you only enter the formula in a single cell, all you'd get is the
value for the first row and first column of the table.
On Tue, Jun 7, 2011 at 5:12 AM, bushpilote <bushpilote@yahoo.ca > wrote:
>
> Works fine for you meaning that you are getting USDEUR rate of .6848?
>
> At my end the formula results in "Jul.Day". Formatting the cell in not an
> issue.
>
- 2a.
-
Re: Incorrect Ex-Dividend Date extraction
Posted by: "Phil" philgiz@zoominternet.net philgiz_2000
Tue Jun 7, 2011 5:25 am (PDT)
Thanks Randy for your reply.
From: Randy Harmelink
Sent: Monday, June 06, 2011 11:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Incorrect Ex-Dividend Date extraction
You can extract it from the Key Statistics page. However, it's going to be much slower, since you need to retrieve a new web page for each ticker symbol. I have quite often found the ex-dividend date on that page to not be current as well.
I haven't found a reliable source for ex-dividend dates, or at least a free one. The best method to me seems to be to estimate it from the payout from the previous year, at least for stocks that have a regular history of paying dividends.
Maybe you'll need to use a paid service for such data, where they have a financial incentive to keep the data current?
On Mon, Jun 6, 2011 at 8:39 PM, PhillipG <philgiz@zoominternet.net > wrote:
Hi Randy. I am using the 'rchgetyahooquotes' function to extract the ex-dividend date for GE stock. The 'q' code is pulling up 2/24/11 as the date. That was the date for the 1st qrt. The date showing in the Yahoo 'key statistics' is 6/16/11. Any idea why and what I should do to get the latest date?
- 3.1.
-
Re: RCHGetYahooQuotes()
Posted by: "rajeshparsekar1972" rajeshparsekar1972@hotmail.com rajeshparsekar1972
Tue Jun 7, 2011 7:08 am (PDT)
Dear Sir,
I tried your given example and it really worked very will which was in response to my first post after joining this group.
Plesae let me know from where I can get these yahoo codes to update in excel ?
Awaiting eagerly !!
Thanks and regards,
Rajesh P
--- In smf_addin@yahoogroups.com , "investor952" <investor952@...> wrote:
>
> Hello, I am a newbee at this..just found this fantastic tool on internet last night...
>
> I just tried this..and the o and l (open and low price) show up as NA for all the tickers. Looks like Yahoo doesn't have this data?
> I use an older version of Excel..2002 I think.
>
>
>
> --- In smf_addin@yahoogroups.com , "Randy Harmelink" <rharmelink@> wrote:
> >
> > Here's a little template for you. Typically, when I want some Yahoo
> > quotes data, I'll start out like this:
> >
> > 1. Put ticker symbols in cells A2, A3, A4. (e.g. "IBM", "JNJ", and
> > "MOT").
> > 2. Put Yahoo codes in cells B1, C1, D1 (e.g. "o", "h", and "l1").
> > 3. Highlight a range -- let's say B2 to M100.
> > 4. Type (into B2): "=RCHGetYahooQuotes(A2:A100, B1:M1)"
> > 5. Hit Ctrl-Shift-Enter (to array-enter the formula)
> >
> > After a second or so, I will see:
> >
> > A B C D E 1 o h l1 2 IBM 75.83 77.29 76.15 3 JNJ
> > 62.15 62.57 62.56 4 MOT 22 22.24 22.11 5 6
> > However, since I set the symbol range to be A2:A100 and the Yahoo code
> > range to be B1:M1, I can easily extend the table in either direction .
> > For example, I can type "v" in cell E1. And I can type "MMM" in cell
> > A5. I would then see:
> >
> > A B C D E 1 o h l1 v 2 IBM 75.83 77.29 76.15 6422900 3 JNJ
> > 62.15 62.57 62.56 7658600 4 MOT 22 22.24 22.11 21180900 5 MMM 69.89
> > 70.7 69.75 6141000 6
> > And I can keep putting more symbols in, down to cell A100. Or I can
> > put in more Yahoo codes, out to cell M1.
> >
> > Hopefully that helps a bit?
> >
>
- 3.2.
-
Re: RCHGetYahooQuotes()
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 7:14 am (PDT)
Check the "Documentation" folder of the "Files" area of the group. The Yahoo
codes are listed there.
On Tue, Jun 7, 2011 at 5:35 AM, rajeshparsekar1972 <
rajeshparsekar1972@hotmail.com > wrote:
>
> I tried your given example and it really worked very will which was in
> response to my first post after joining this group.
> Plesae let me know from where I can get these yahoo codes to update in
> excel ?
>
- 4a.
-
Advice and guidence on smf functions
Posted by: "rajeshparsekar1972" rajeshparsekar1972@hotmail.com rajeshparsekar1972
Tue Jun 7, 2011 7:08 am (PDT)
Dear all,
Today I joined this expert group and really happy for it for gaining more advance knowledge about advanced functions.
My query is, I would like to make my own excel sheet where I wanted to update my stock under format of
Company Name - Symbol - Last traded price - 52wk high - 52wk low
These are few basic information require from our indian stock market of BSES and NSE , also top 10 gainers and 10 loosers with sectorwise.
I would appreciate for giving me ready made formatted xls file to update my data for future tracking. Also let me know how to enter company name and to retrive data for new entries in file.
Also I would be more happy to learn these functions in Excel. So in future I will not bother you all and learn from you experts to harness my little knowledge.
If you can give me sufficient material to use theseSMF functions would be great help for me.
Have a great day.
you can even mail to my rajeshparsekar1972@hotmail.com
- 4b.
-
Re: Advice and guidence on smf functions
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 7:15 am (PDT)
Take a look at the documentation for the RCHGetTableCell() and
smfGetTagContent() functions.
On Tue, Jun 7, 2011 at 5:20 AM, rajeshparsekar1972 <
rajeshparsekar1972@hotmail.com > wrote:
>
> Today I joined this expert group and really happy for it for gaining more
> advance knowledge about advanced functions.
> My query is, I would like to make my own excel sheet where I wanted to
> update my stock under format of
> Company Name - Symbol - Last traded price - 52wk high - 52wk low
> These are few basic information require from our indian stock market of
> BSES and NSE , also top 10 gainers and 10 loosers with sectorwise.
> I would appreciate for giving me ready made formatted xls file to update my
> data for future tracking. Also let me know how to enter company name and to
> retrive data for new entries in file.
> Also I would be more happy to learn these functions in Excel. So in future
> I will not bother you all and learn from you experts to harness my little
> knowledge.
> If you can give me sufficient material to use theseSMF functions would be
> great help for me.
>
- 5a.
-
Keep getting can't find SMF add in folder.
Posted by: "colobuyer123" keystin@gmail.com colobuyer123
Tue Jun 7, 2011 10:00 am (PDT)
Help! Every time I ooen up I keep getting errors that the folder can't be found. I've tried al the suggestion but can't get it fixed. Help!
- 5b.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 10:16 am (PDT)
Even on a workbook you've created from scratch yourself?
On Tue, Jun 7, 2011 at 9:32 AM, colobuyer123 <keystin@gmail.com > wrote:
> Help! Every time I ooen up I keep getting errors that the folder can't be
> found. I've tried al the suggestion but can't get it fixed. Help!
>
- 5c.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Keys Tinney" keystin@gmail.com colobuyer123
Tue Jun 7, 2011 10:34 am (PDT)
Well what happened was I installed on my desktop naming the program files/SMF add-in just like the instructions say, but when I installed on my laptop I named the folder Stock Market Addin vs SMF Add-in like I'm supposed to. I changed the laptop but it doesn't seem to be retaining the new file location. Everything works fine on desktop but get error each time I open file on laptop.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, June 07, 2011 11:16 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Keep getting can't find SMF add in folder.
Even on a workbook you've created from scratch yourself?
On Tue, Jun 7, 2011 at 9:32 AM, colobuyer123 <keystin@gmail.com > wrote:
Help! Every time I ooen up I keep getting errors that the folder can't be found. I've tried al the suggestion but can't get it fixed. Help!
- 5d.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 11:02 am (PDT)
See this item from the "Links" area of the group:
http://finance.groups.yahoo. com/group/ smf_addin/ message/11346
On Tue, Jun 7, 2011 at 10:34 AM, Keys Tinney <keystin@gmail.com > wrote:
>
> Well what happened was I installed on my desktop naming the program
> files/SMF add-in just like the instructions say, but when I installed on my
> laptop I named the folder Stock Market Addin vs SMF Add-in like I'm supposed
> to. I changed the laptop but it doesn't seem to be retaining the new file
> location. Everything works fine on desktop but get error each time I open
> file on laptop.
>
- 5e.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Keys Tinney" keystin@gmail.com colobuyer123
Tue Jun 7, 2011 11:57 am (PDT)
I can't get it fixed. Is there a way to globally uninstall and reinstall so it reset everything the new folder?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, June 07, 2011 12:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Keep getting can't find SMF add in folder.
See this item from the "Links" area of the group:
http://finance.groups.yahoo. com/group/ smf_addin/ message/11346
On Tue, Jun 7, 2011 at 10:34 AM, Keys Tinney <keystin@gmail.com > wrote:
Well what happened was I installed on my desktop naming the program files/SMF add-in just like the instructions say, but when I installed on my laptop I named the folder Stock Market Addin vs SMF Add-in like I'm supposed to. I changed the laptop but it doesn't seem to be retaining the new file location. Everything works fine on desktop but get error each time I open file on laptop.
- 5f.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 1:20 pm (PDT)
You still haven't made clear to me what error you are getting. The add-in
can be located anywhere you want it to be. However, if you have it in a
different location than the saved workbook had it located, you're going to
have to manually fix the locations. That's just the way it is, the way
MicroSoft has implemented add-in usage. There is no way to globally reset
the add-in folder locations that are within saved workbooks. They are
independent of EXCEL and the add-in itself.
If you create a new workbook from scratch, using just this formula:
=RCHGetElementNumber("Version" )
...and then save the workbook, do you get location errors when you open the
workbook?
On Tue, Jun 7, 2011 at 11:57 AM, Keys Tinney <keystin@gmail.com > wrote:
>
> I can't get it fixed. Is there a way to globally uninstall and reinstall so
> it reset everything the new folder?
>
- 5g.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Keys Tinney" keystin@gmail.com colobuyer123
Tue Jun 7, 2011 1:49 pm (PDT)
Sorry for the hassle,
When I open ANY excel spreadsheet I get the error below. Once I click okay ,the excel file opens and the file is usable, including the file (I only have 1 that I'm using the Add-in with). The add in works once logged in as well.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, June 07, 2011 2:21 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Keep getting can't find SMF add in folder.
You still haven't made clear to me what error you are getting. The add-in can be located anywhere you want it to be. However, if you have it in a different location than the saved workbook had it located, you're going to have to manually fix the locations. That's just the way it is, the way MicroSoft has implemented add-in usage. There is no way to globally reset the add-in folder locations that are within saved workbooks. They are independent of EXCEL and the add-in itself.
If you create a new workbook from scratch, using just this formula:
=RCHGetElementNumber("Version" )
...and then save the workbook, do you get location errors when you open the workbook?
On Tue, Jun 7, 2011 at 11:57 AM, Keys Tinney <keystin@gmail.com > wrote:
I can't get it fixed. Is there a way to globally uninstall and reinstall so it reset everything the new folder?
- 5h.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 2:21 pm (PDT)
OK. Try this process, which has cleared up some issues for others in the
past:
1. Go to the add-in manager and uncheck the add-in.
2. Exit EXCEL (which should remove any references to the add-in from the
registry)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL
Now try opening the workbook and see if you get the same message?
On Tue, Jun 7, 2011 at 1:49 PM, Keys Tinney <keystin@gmail.com > wrote:
>
> Sorry for the hassle,
>
>
>
> When I open ANY excel spreadsheet I get the error below. Once I click okay
> ,the excel file opens and the file is usable, including the file (I only
> have 1 that I'm using the Add-in with). The add in works once logged in as
> well.
>
>
>
- 5i.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Keys Tinney" keystin@gmail.com colobuyer123
Tue Jun 7, 2011 2:35 pm (PDT)
Okay, message gone. I checked the add ins after reopening and its still in
there just not checked.
On Tue, Jun 7, 2011 at 3:21 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>
> OK. Try this process, which has cleared up some issues for others in the
> past:
>
> 1. Go to the add-in manager and uncheck the add-in.
> 2. Exit EXCEL (which should remove any references to the add-in from
> the registry)
> 3. Restart EXCEL
> 4. Go to the add-in manager and put the add-in back into the list
> 5. Exit EXCEL (to save the new settings)
> 6. Restart EXCEL
>
> Now try opening the workbook and see if you get the same message?
>
>
> On Tue, Jun 7, 2011 at 1:49 PM, Keys Tinney <keystin@gmail.com > wrote:
>
>>
>> Sorry for the hassle,
>>
>>
>>
>> When I open ANY excel spreadsheet I get the error below. Once I click
>> okay ,the excel file opens and the file is usable, including the file (I
>> only have 1 that I�m using the Add-in with). The add in works once logged
>> in as well.
>>
>>
>>
>
>
--
Keys Tinney
keystin@gmail.com
- 5j.
-
Re: Keep getting can't find SMF add in folder.
Posted by: "Keys Tinney" keystin@gmail.com colobuyer123
Tue Jun 7, 2011 2:53 pm (PDT)
Looks like that fixed it. When I opened the file that uses the add-in it
asked to update links. I said yes and no more errors!
THANKS!!!
On Tue, Jun 7, 2011 at 3:35 PM, Keys Tinney <keystin@gmail.com > wrote:
> Okay, message gone. I checked the add ins after reopening and its still in
> there just not checked.
>
>
> On Tue, Jun 7, 2011 at 3:21 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>>
>>
>> OK. Try this process, which has cleared up some issues for others in the
>> past:
>>
>> 1. Go to the add-in manager and uncheck the add-in.
>> 2. Exit EXCEL (which should remove any references to the add-in from
>> the registry)
>> 3. Restart EXCEL
>> 4. Go to the add-in manager and put the add-in back into the list
>> 5. Exit EXCEL (to save the new settings)
>> 6. Restart EXCEL
>>
>> Now try opening the workbook and see if you get the same message?
>>
>>
>> On Tue, Jun 7, 2011 at 1:49 PM, Keys Tinney <keystin@gmail.com > wrote:
>>
>>>
>>> Sorry for the hassle,
>>>
>>>
>>>
>>> When I open ANY excel spreadsheet I get the error below. Once I click
>>> okay ,the excel file opens and the file is usable, including the file (I
>>> only have 1 that I�m using the Add-in with). The add in works once logged
>>> in as well.
>>>
>>>
>>>
>>
>>
>
>
>
> --
> Keys Tinney
> keystin@gmail.com
>
>
--
Keys Tinney
keystin@gmail.com
- 6a.
-
Historical US GDP by Quarter
Posted by: "mad money" ev4n89@yahoo.com ev4n89
Tue Jun 7, 2011 9:02 pm (PDT)
Hello,
Does anyone have an excel sheet with US GDP data dating back to at least the 80s?
Many Thanks,
Evan
- 6b.
-
Re: Historical US GDP by Quarter
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 7, 2011 9:04 pm (PDT)
You can get the data from FRED -- http://research.stlouisfed. org/fred2/
On Tue, Jun 7, 2011 at 8:16 PM, mad money <ev4n89@yahoo.com > wrote:
>
> Does anyone have an excel sheet with US GDP data dating back to at least
> the 80s?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar