Minggu, 31 Juli 2011

[smf_addin] Digest Number 1904

Messages In This Digest (2 Messages)

Messages

1a.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 8:17 pm (PDT)



I downloaded the example from yahoo group on this function. Now it worked perfectly. Thanks a lot
 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 8:14 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
Which template?

On Sat, Jul 30, 2011 at 8:10 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>I have downloaded the template but that was also not retrieving any data
>

2a.

Re: cia.gov factbook

Posted by: "Gary Funck" gary@intrepid.com   garyfunck

Sat Jul 30, 2011 8:35 pm (PDT)



On 07/30/11 23:15:17, ibd-paluszak@spamex.com wrote:
> FYI. The 2004 represents the data type not the year
> e.g. electricity production is 2038, stock of money is 2209. Etc

Thanks, good to know.

BTW, the per country pages can be accessed through "print"
interface that may be easier to parse.

Clicking United States here:
https://www.cia.gov/library/publications/the-world-factbook/print/textversion.html#U
takes you to:
https://www.cia.gov/library/publications/the-world-factbook/geos/countrytemplate_us.html

Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need traffic?

Drive customers

With search ads

on Yahoo!

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
READ MORE....

[belajar-excel] Digest Number 1272

Messages In This Digest (4 Messages)

1a.
Conditional Formatting From: Riska Wahyu Nirmalasari
1b.
Re: Conditional Formatting From: agung_widodo@sanyo.com
1c.
Re: Conditional Formatting From: utthank abe
1d.
Re: Conditional Formatting From: STDEV(i)

Messages

1a.

Conditional Formatting

Posted by: "Riska Wahyu Nirmalasari" Riska.Nirmalasari@danone.com

Sat Jul 30, 2011 12:48 am (PDT)



Dear All,
Mau tanya2 lagi. Conditional Formatting apakah tidak berfungsi jika pada
suatu sheet ada rumusnya?
Contoh berikut;

Terimakasih bantuannya.

Regards,

Riska Wahyu N.
1b.

Re: Conditional Formatting

Posted by: "agung_widodo@sanyo.com" agung_widodo@sanyo.com

Sat Jul 30, 2011 12:54 am (PDT)



Dear Riska,
Conditional Formatting kan bisa tergantung dari rumus/ formula atau value.

Kalau maunya berwarna merah jika diatas 2,
bukankah bisa dengan conditional formatting if value greater than 2, Pattern merah?

Salam
Agung W

________________________________
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Riska Wahyu Nirmalasari
Sent: Saturday, July 30, 2011 2:51 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Conditional Formatting

Dear All,
Mau tanya2 lagi. Conditional Formatting apakah tidak berfungsi jika pada suatu sheet ada rumusnya?
Contoh berikut;

Terimakasih bantuannya.

Regards,

Riska Wahyu N.

Ce message x000E9;lectronique et tous les fichiers attachx000E9;s qu'il contient sont confidentiels et destinx000E9;s exclusivement x000E0; l'usage de la personne x000E0; laquelle ils sont adressx000E9;s. Si vous avez rex000E7;u ce message par erreur, merci de le retourner x000E0; son x000E9;metteur. Les idx000E9;es et opinions prx000E9;sentx000E9;es dans ce message sont celles de son auteur, et ne reprx000E9;sentent pas nx000E9;cessairement celles de DANONE ou d'une quelconque de ses filiales. La publication, l'usage, la distribution, l'impression ou la copie non autorisx000E9;e de ce message et des attachements qu'il contient sont strictement interdits.

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of DANONE or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

1c.

Re: Conditional Formatting

Posted by: "utthank abe" abeutthank@gmail.com   abe_utthank

Sat Jul 30, 2011 2:11 am (PDT)



mungkin masalahnya ada di sel yang agank abzolutkan di conditional
formatting agank tulis =$C$1 (harusnya $C1) karena yang di nili sel c1
melulu... zemoga membantu. salam R125
beriku za lampirkan filenya. tq
On 7/30/11, agung_widodo@sanyo.com <agung_widodo@sanyo.com> wrote:
> Dear Riska,
> Conditional Formatting kan bisa tergantung dari rumus/ formula atau value.
>
> Kalau maunya berwarna merah jika diatas 2,
> bukankah bisa dengan conditional formatting if value greater than 2, Pattern
> merah?
>
> Salam
> Agung W
>
> ________________________________
> From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
> On Behalf Of Riska Wahyu Nirmalasari
> Sent: Saturday, July 30, 2011 2:51 PM
> To: belajar-excel@yahoogroups.com
> Subject: [belajar-excel] Conditional Formatting
>
>
>
> Dear All,
> Mau tanya2 lagi. Conditional Formatting apakah tidak berfungsi jika pada
> suatu sheet ada rumusnya?
> Contoh berikut;
>
>
> Terimakasih bantuannya.
>
> Regards,
>
> Riska Wahyu N.
>
> Ce message x000E9;lectronique et tous les fichiers attachx000E9;s qu'il
> contient sont confidentiels et destinx000E9;s exclusivement x000E0; l'usage
> de la personne x000E0; laquelle ils sont adressx000E9;s. Si vous avez
> rex000E7;u ce message par erreur, merci de le retourner x000E0; son
> x000E9;metteur. Les idx000E9;es et opinions prx000E9;sentx000E9;es dans ce
> message sont celles de son auteur, et ne reprx000E9;sentent pas
> nx000E9;cessairement celles de DANONE ou d'une quelconque de ses filiales.
> La publication, l'usage, la distribution, l'impression ou la copie non
> autorisx000E9;e de ce message et des attachements qu'il contient sont
> strictement interdits.
>
> This e-mail and any files transmitted with it are confidential and intended
> solely for the use of the individual to whom it is addressed. If you have
> received this email in error please send it back to the person that sent it
> to you. Any views or opinions presented are solely those of its author and
> do not necessarily represent those of DANONE or any of its subsidiary
> companies. Unauthorized publication, use, dissemination, forwarding,
> printing or copying of this email and its associated attachments is strictly
> prohibited.
>
>
>

--
R125
1d.

Re: Conditional Formatting

Posted by: "STDEV(i)" setiyowati.devi@gmail.com   siti_vi

Sat Jul 30, 2011 2:12 am (PDT)



[image: condit format riska.GIF]

(1)
di dalam workbook / worksheet yg sudah berisi formula, tetap bisa dikenakan
Conditional Formatting
(2)
COndtitional Formatting yg ditunukkan lewat contoh, salah rumusnya
karena C1 dibuat Absoulut
lihat caonatoh terlmpir

On Sat, Jul 30, 2011 at 2:53 PM, <agung_widodo@sanyo.com> wrote:

> **
>
>
> **
> Dear Riska,
> Conditional Formatting kan bisa tergantung dari rumus/ formula atau value.
>
> Kalau maunya berwarna merah jika diatas 2,
> bukankah bisa dengan conditional formatting if value greater than 2,
> Pattern merah?
>
> Salam
> Agung W
>
> ------------------------------
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com] *On Behalf Of *Riska Wahyu Nirmalasari
> *Sent:* Saturday, July 30, 2011 2:51 PM
> *To:* belajar-excel@yahoogroups.com
> *Subject:* [belajar-excel] Conditional Formatting
>
>
>
>
> Dear All,
> Mau tanya2 lagi. Conditional Formatting apakah tidak berfungsi jika pada
> suatu sheet ada rumusnya?
> Contoh berikut;
>
>
> Terimakasih bantuannya.
>
> Regards,
>
> Riska Wahyu N.
>
> Ce message x000E9;lectronique et tous les fichiers attachx000E9;s qu'il
> contient sont confidentiels et destinx000E9;s exclusivement x000E0; l'usage
> de la personne x000E0; laquelle ils sont adressx000E9;s. Si vous avez
> rex000E7;u ce message par erreur, merci de le retourner x000E0; son
> x000E9;metteur. Les idx000E9;es et opinions prx000E9;sentx000E9;es dans ce
> message sont celles de son auteur, et ne reprx000E9;sentent pas
> nx000E9;cessairement celles de DANONE ou d'une quelconque de ses filiales.
> La publication, l'usage, la distribution, l'impression ou la copie non
> autorisx000E9;e de ce message et des attachements qu'il contient sont
> strictement interdits.
>
> This e-mail and any files transmitted with it are confidential and intended
> solely for the use of the individual to whom it is addressed. If you have
> received this email in error please send it back to the person that sent it
> to you. Any views or opinions presented are solely those of its author and
> do not necessarily represent those of DANONE or any of its subsidiary
> companies. Unauthorized publication, use, dissemination, forwarding,
> printing or copying of this email and its associated attachments is strictly
> prohibited.
>
>
>
Recent Activity
Visit Your Group
Give Back

Yahoo! for Good

Get inspired

by a good cause.

Y! Toolbar

Get it Free!

easy 1-click access

to your groups.

Yahoo! Groups

Start a group

in 3 easy steps.

Connect with others.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke:
belajar-excel@yahoogroups.com

berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran
http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....

Sabtu, 30 Juli 2011

[smf_addin] Digest Number 1903[1 Attachment]

Messages In This Digest (25 Messages)

1a.
difficulty getting this to work, details From: rd88elw
1b.
Re: difficulty getting this to work, details From: Randy Harmelink
2a.
Re: Quotes on Stock Options including Greeks From: MIGUEL ANGEL GONZALEZ
2b.
Re: Quotes on Stock Options including Greeks From: MIGUEL ANGEL GONZALEZ
2c.
Re: Quotes on Stock Options including Greeks [1 Attachment] From: Randy Harmelink
2d.
Re: Quotes on Stock Options including Greeks From: MIGUEL ANGEL GONZALEZ
3a.
New Computer with Excel 2007 and Vista From: jwoll99
3b.
Re: New Computer with Excel 2007 and Vista From: Randy Harmelink
4a.
Re: cia.gov factbook From: Gary Funck
4b.
Re: cia.gov factbook From: ibd-paluszak@spamex.com
5a.
Want to download financial statements data from reuters.com From: Amir
5b.
Re: Want to download financial statements data from reuters.com From: Randy Harmelink
5c.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5d.
Re: Want to download financial statements data from reuters.com From: Randy Harmelink
5e.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5f.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5g.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5h.
Re: Want to download financial statements data from reuters.com From: Randy Harmelink
5i.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5j.
Re: Want to download financial statements data from reuters.com From: Randy Harmelink
5k.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5l.
Re: Want to download financial statements data from reuters.com From: Amir Rehman
5m.
Re: Want to download financial statements data from reuters.com From: Randy Harmelink
6a.
call OK, put not ok From: bloteczka
6b.
Re: call OK, put not ok From: Randy Harmelink

Messages

1a.

difficulty getting this to work, details

Posted by: "rd88elw" rd88elw@yahoo.co.uk   rd88elw

Sat Jul 30, 2011 6:58 am (PDT)



-- The specific function(s) or template(s) you are having problems with.
All of them, but specifically tried RCHGetTableCell-Template-Reuters-Insider-Transactions and RCHGetTableCell-Template-Yahoo-Options-Quotes

-- The parameter(s) you are using with the function(s).
Just symbol name in these templates

-- The version of EXCEL you use.
Excel 2010, Microsoft Professional Plus 2010

-- The operating system you're running EXCEL under.
Windows 7 64-bit

-- The steps you took to try to resolve the problem.
tried doing a 'trace' on the formula, but I dont know why it fails and everyone else seems to be using it fine

-- The ticker symbols or URLs that are being used.
SPY

-- The results you expect to get and what you actually get.
numbers, what I actually get: #NAME? invalid name error

1b.

Re: difficulty getting this to work, details

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 8:36 am (PDT)



See item 0.2 in the "Links" area of the group.

On Sat, Jul 30, 2011 at 6:39 AM, rd88elw <rd88elw@yahoo.co.uk> wrote:

> -- The specific function(s) or template(s) you are having problems with.
> All of them, but specifically tried
> RCHGetTableCell-Template-Reuters-Insider-Transactions and
> RCHGetTableCell-Template-Yahoo-Options-Quotes
>
> -- The parameter(s) you are using with the function(s).
> Just symbol name in these templates
>
> -- The version of EXCEL you use.
> Excel 2010, Microsoft Professional Plus 2010
>
> -- The operating system you're running EXCEL under.
> Windows 7 64-bit
>
> -- The steps you took to try to resolve the problem.
> tried doing a 'trace' on the formula, but I dont know why it fails and
> everyone else seems to be using it fine
>
> -- The ticker symbols or URLs that are being used.
> SPY
>
> -- The results you expect to get and what you actually get.
> numbers, what I actually get: #NAME? invalid name error
>
2a.

Re: Quotes on Stock Options including Greeks

Posted by: "MIGUEL ANGEL GONZALEZ" spectratecharchitecture@gmail.com   spectratecharchitecture

Sat Jul 30, 2011 1:30 pm (PDT)



Thank you very much!

On Fri, Jul 29, 2011 at 9:54 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Just replace the "395" with the cell reference itself -- A1.
>
> By the way, if you have the path on the formula like that, your links
> aren't resolving correctly. See:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/11346
>
>
> On Fri, Jul 29, 2011 at 8:45 PM, MIGUEL ANGEL GONZALEZ <
> spectratecharchitecture@gmail.com> wrote:
>
>>
>> I understand now. One more question:
>>
>> How can i get the following formula to replace the strike price (last 3
>> numbers in the formula) with a value in a cell?
>> ='C:\Program Files\SMF
>> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
>> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?
>> Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1",3,"*395*")
>>
>> for example, i would like the formula to get any value that i place in
>> cell A1 and place it where the *395 *is in the formula. I tried the
>> INDIRECT function in excel and I could not get it to work...
>>
>
>
>

--
Miguel Angel Gonzalez
SpectraTech Systems
President/Owner
(915)345-5668
2b.

Re: Quotes on Stock Options including Greeks

Posted by: "MIGUEL ANGEL GONZALEZ" spectratecharchitecture@gmail.com   spectratecharchitecture

Sat Jul 30, 2011 5:06 pm (PDT)

[Attachment(s) from MIGUEL ANGEL GONZALEZ included below]

I managed to make the formula read the value in the cell that i wanted, see
the formula below...

=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
",4,"*" & J7 & "*")

...by entering the extra *" & J7 & "* into the formula, i got it to read
the value. I have one more problem, the value that i placed in cell J7 is *
345.00*, no matter how i enter it, as a number or as text, the formula bar
picks it up as *345*. I need it to pick up the *345.00*
*
*
just to let you know what im trying to do, the chains on OXnettools are not
as streaming as the real OX account, but they are definately more streaming
that anything i've found elsewhere. Everytime i open the excel sheet, new
options prices are shown, i can use the forcerecalulation fucntion like you
said before. What i want to work on now is a way of filling out this option
chains sheet by just entering in one strike price via an input box. The
strike column will have formulas like strikeprice + 5 or strikeprice - 5.
Then each row will fill itself out by looking a the strike price in their
row.

Right now I would have to go to every strike price and manually fill in the
strikes (i.e. 345.00, 350.00, 355.00) in the formula and then go to each
column and change the number of cells to look away from that strike value
(i.e. -17, -16, -15, -14....... 2, 3, 4,). If i can get the formula bar to
pick up a 345.00 value and not a 340 value i think i can take it from there.
I appreciate your help. I looked everywhere for this answer and just ended
up coming back here for help.

On Fri, Jul 29, 2011 at 9:54 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Just replace the "395" with the cell reference itself -- A1.
>
> By the way, if you have the path on the formula like that, your links
> aren't resolving correctly. See:
>
>
>

--
Miguel Angel Gonzalez
SpectraTech Systems
President/Owner
(915)345-5668

Attachment(s) from MIGUEL ANGEL GONZALEZ

1 of 1 File(s)

2c.

Re: Quotes on Stock Options including Greeks [1 Attachment]

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 5:21 pm (PDT)



The value you have in J7 *IS* 345. You just have it formatted as 345.00.
Values and formats are two separate attributes of a cell.

You need to format it in you formula as well. Try:

TEXT(J7,"0.00")

However, note that a strike price alone is a very poor choice for a search
string. If the underlying equity has a last price, a bid price, or an ask
price of that, THAT is the search string you will find. I key off of the URL
for the option, since that will be more likely to be unique, and then go
backwards from the end of the row. For example:

=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
",-6,TEXT(1000*J7,"C00000000"))

But if you want the whole table, why not:

RCHGetHTMLTable("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
",">OpInt",-1,"",2)

Then you don't have to worry if prices increment by $1, $2.50, or $5.

Or just use the RCHGetTableCell() and increment the rows and columns as
necessary to get the whole table.

On Sat, Jul 30, 2011 at 5:05 PM, MIGUEL ANGEL GONZALEZ <
spectratecharchitecture@gmail.com> wrote:

>
> I managed to make the formula read the value in the cell that i wanted, see
> the formula below...
>
> =RCHGetTableCell("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
> ",4,"*" & J7 & "*")
>
> ...by entering the extra *" & J7 & "* into the formula, i got it to read
> the value. I have one more problem, the value that i placed in cell J7 is
> *345.00*, no matter how i enter it, as a number or as text, the formula
> bar picks it up as *345*. I need it to pick up the *345.00*
> *
> *
> just to let you know what im trying to do, the chains on OXnettools are not
> as streaming as the real OX account, but they are definately more streaming
> that anything i've found elsewhere. Everytime i open the excel sheet, new
> options prices are shown, i can use the forcerecalulation fucntion like you
> said before. What i want to work on now is a way of filling out this option
> chains sheet by just entering in one strike price via an input box. The
> strike column will have formulas like strikeprice + 5 or strikeprice - 5.
> Then each row will fill itself out by looking a the strike price in their
> row.
>
> Right now I would have to go to every strike price and manually fill in the
> strikes (i.e. 345.00, 350.00, 355.00) in the formula and then go to each
> column and change the number of cells to look away from that strike value
> (i.e. -17, -16, -15, -14....... 2, 3, 4,). If i can get the formula bar to
> pick up a 345.00 value and not a 340 value i think i can take it from there.
> I appreciate your help. I looked everywhere for this answer and just ended
> up coming back here for help.
>
2d.

Re: Quotes on Stock Options including Greeks

Posted by: "MIGUEL ANGEL GONZALEZ" spectratecharchitecture@gmail.com   spectratecharchitecture

Sat Jul 30, 2011 6:03 pm (PDT)



I COULD KISS YOU IF I WEREN'T STRAIGHT!!, THANKS[?]

On Sat, Jul 30, 2011 at 6:21 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> The value you have in J7 *IS* 345. You just have it formatted as 345.00.
> Values and formats are two separate attributes of a cell.
>
> You need to format it in you formula as well. Try:
>
> TEXT(J7,"0.00")
>
> However, note that a strike price alone is a very poor choice for a search
> string. If the underlying equity has a last price, a bid price, or an ask
> price of that, THAT is the search string you will find. I key off of the URL
> for the option, since that will be more likely to be unique, and then go
> backwards from the end of the row. For example:
>
> =RCHGetTableCell("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
> ",-6,TEXT(1000*J7,"C00000000"))
>
> But if you want the whole table, why not:
>
> RCHGetHTMLTable("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
> ",">OpInt",-1,"",2)
>
> Then you don't have to worry if prices increment by $1, $2.50, or $5.
>
> Or just use the RCHGetTableCell() and increment the rows and columns as
> necessary to get the whole table.
>
>
> On Sat, Jul 30, 2011 at 5:05 PM, MIGUEL ANGEL GONZALEZ <
> spectratecharchitecture@gmail.com> wrote:
>
>>
>> I managed to make the formula read the value in the cell that i wanted,
>> see the formula below...
>>
>> =RCHGetTableCell("
>> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1
>> ",4,"*" & J7 & "*")
>>
>> ...by entering the extra *" & J7 & "* into the formula, i got it to read
>> the value. I have one more problem, the value that i placed in cell J7 is
>> *345.00*, no matter how i enter it, as a number or as text, the formula
>> bar picks it up as *345*. I need it to pick up the *345.00*
>> *
>> *
>> just to let you know what im trying to do, the chains on OXnettools are
>> not as streaming as the real OX account, but they are definately more
>> streaming that anything i've found elsewhere. Everytime i open the excel
>> sheet, new options prices are shown, i can use the forcerecalulation
>> fucntion like you said before. What i want to work on now is a way of
>> filling out this option chains sheet by just entering in one strike price
>> via an input box. The strike column will have formulas like strikeprice + 5
>> or strikeprice - 5. Then each row will fill itself out by looking a the
>> strike price in their row.
>>
>> Right now I would have to go to every strike price and manually fill in
>> the strikes (i.e. 345.00, 350.00, 355.00) in the formula and then go to each
>> column and change the number of cells to look away from that strike value
>> (i.e. -17, -16, -15, -14....... 2, 3, 4,). If i can get the formula bar to
>> pick up a 345.00 value and not a 340 value i think i can take it from there.
>> I appreciate your help. I looked everywhere for this answer and just ended
>> up coming back here for help.
>>
>
>
>

--
Miguel Angel Gonzalez
SpectraTech Systems
President/Owner
(915)345-5668
3a.

New Computer with Excel 2007 and Vista

Posted by: "jwoll99" jwoll98@yahoo.com   jwoll99

Sat Jul 30, 2011 2:03 pm (PDT)



I had to refresh my system due to a harddrive failure and I can't get the plugin to install properly. It seems to go OK but when I try to use the RCHGETELEMENTNUMBER function I get a return of UNDEFINED. Any new twists with Excel 2007 and Vista?

3b.

Re: New Computer with Excel 2007 and Vista

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 2:55 pm (PDT)



That's because, as per the installation instructions, you need to unzip ALL
of the files into the folder with the add-in. The *.txt files contain the
element definitions. If they aren't there, all elements are undefined.

On Sat, Jul 30, 2011 at 12:27 PM, jwoll99 <jwoll98@yahoo.com> wrote:

> I had to refresh my system due to a harddrive failure and I can't get the
> plugin to install properly. It seems to go OK but when I try to use the
> RCHGETELEMENTNUMBER function I get a return of UNDEFINED. Any new twists
> with Excel 2007 and Vista?
>
4a.

Re: cia.gov factbook

Posted by: "Gary Funck" gary@intrepid.com   garyfunck

Sat Jul 30, 2011 5:21 pm (PDT)



On 07/02/11 06:36:08, alexander wrote:
> Just curious,
>
> Has anybody looked up data from cia.gov factbook? I would like to
> pull some economic information about countries particularly their
> ranking system for the different socio-economic and demographic
> indicators which I have yet to find an alternative site where
> all the information is in one place.
>
> here is the website if you are curious.
>
> https://www.cia.gov/library/publications/the-world-factbook/rankorder/rankorderguide.html
>
> If anybody has attempted anything on this, I'd like know what you did. thanks!

If you follow one of those links, for example:
https://www.cia.gov/library/publications/the-world-factbook/rankorder/2004rank.html
(overlooking that is says "2004rank"), there is a "Download Data" link
on that page:
https://www.cia.gov/library/publications/the-world-factbook/rankorder/rawdata_2004.txt
which appears to display the data in an easily accessed form.

- Gary

4b.

Re: cia.gov factbook

Posted by: "ibd-paluszak@spamex.com" ibd-paluszak@spamex.com   rpaluszak

Sat Jul 30, 2011 8:16 pm (PDT)



FYI. The 2004 represents the data type not the year

e.g. electricity production is 2038, stock of money is 2209. Etc

From: Gary Funck [mailto:gary@intrepid.com]
Sent: Saturday, July 30, 2011 8:21 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] cia.gov factbook

* Replies will be sent through Spamex to smf_addin@yahoogroups.com
* For additional info click -> www.spamex.com/i/?v=58681593

On 07/02/11 06:36:08, alexander wrote:
> Just curious,
>
> Has anybody looked up data from cia.gov factbook? I would like to
> pull some economic information about countries particularly their
> ranking system for the different socio-economic and demographic
> indicators which I have yet to find an alternative site where
> all the information is in one place.
>
> here is the website if you are curious.
>
>
https://www.cia.gov/library/publications/the-world-factbook/rankorder/rankor
derguide.html
>
> If anybody has attempted anything on this, I'd like know what you did.
thanks!

If you follow one of those links, for example:
https://www.cia.gov/library/publications/the-world-factbook/rankorder/2004ra
nk.html
(overlooking that is says "2004rank"), there is a "Download Data" link
on that page:
https://www.cia.gov/library/publications/the-world-factbook/rankorder/rawdat
a_2004.txt
which appears to display the data in an easily accessed form.

- Gary

5a.

Want to download financial statements data from reuters.com

Posted by: "Amir" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 6:59 pm (PDT)



Hi,

After searching a long time, I have seen that the financial data about Karachi stock exchange is available on reuters.com. I want to ask that I want how can I download financial statements data from reuters.com.

For example the following link shows the income statement data.

http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=FAUF.KA

How can I access such data from this website. Further, if it require user login detail. how can I account for that.

Looking forward to hear from you.

Thanks
Amir

5b.

Re: Want to download financial statements data from reuters.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 7:47 pm (PDT)



You will need to login first, either using the EXCEL Web Query dialog
(preferred) or IE.

Then, just grab the whole financial data table with something like:

=RCHGetHTMLTable("
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=FAUF.KA","per
share items",-1,"",1)

On Sat, Jul 30, 2011 at 6:59 PM, Amir <amir.rehman@yahoo.com> wrote:

>
> After searching a long time, I have seen that the financial data about
> Karachi stock exchange is available on reuters.com. I want to ask that I
> want how can I download financial statements data from reuters.com.
>
> For example the following link shows the income statement data.
>
>
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=FAUF.KA
>
> How can I access such data from this website. Further, if it require user
> login detail. how can I account for that.
>
5c.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 7:50 pm (PDT)



Thanks. Thanks a lot. How can I use Excel web query dialog?
 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 7:47 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
You will need to login first, either using the EXCEL Web Query dialog (preferred) or IE.

Then, just grab the whole financial data table with something like:

=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=FAUF.KA","per share items",-1,"",1)

On Sat, Jul 30, 2011 at 6:59 PM, Amir <amir.rehman@yahoo.com> wrote:

>After searching a long time, I have seen that the financial data about Karachi stock exchange is available on reuters.com. I want to ask that I want how can I download financial statements data from reuters.com.
>
>For example the following link shows the income statement data.
>
>http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=FAUF.KA
>
>How can I access such data from this website. Further, if it require user login detail. how can I account for that.
>

5d.

Re: Want to download financial statements data from reuters.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 7:52 pm (PDT)



Keyboard shortcut alt+d+d+w. Cancel after logging in. All it does is create
a security cookies that Microsoft's Internet engine will use.

On Sat, Jul 30, 2011 at 7:49 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
> Thanks. Thanks a lot. How can I use Excel web query dialog?
>
5e.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 7:56 pm (PDT)



Fantastic! Its done. Thanks a lot.
 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 7:52 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
Keyboard shortcut alt+d+d+w. Cancel after logging in. All it does is create a security cookies that Microsoft's Internet engine will use.

On Sat, Jul 30, 2011 at 7:49 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>Thanks. Thanks a lot. How can I use Excel web query dialog?
>

5f.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 7:57 pm (PDT)



It is showing this "In Millions of Pakistan Rupee            (except for per share items)"

 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 7:52 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
Keyboard shortcut alt+d+d+w. Cancel after logging in. All it does is create a security cookies that Microsoft's Internet engine will use.

On Sat, Jul 30, 2011 at 7:49 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>Thanks. Thanks a lot. How can I use Excel web query dialog?
>

5g.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 8:01 pm (PDT)



It is showing this "In Millions of Pakistan Rupee            (except for per share items)"

Please help on the syntax of code.
 
Kind Regards
Amir Rehman

________________________________
From: Amir Rehman <amir.rehman@yahoo.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Sunday, July 31, 2011 7:57 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
It is showing this "In Millions of Pakistan Rupee            (except for per share items)"

 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 7:52 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
Keyboard shortcut alt+d+d+w. Cancel after logging in. All it does is create a security cookies that Microsoft's Internet engine will use.

On Sat, Jul 30, 2011 at 7:49 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>Thanks. Thanks a lot. How can I use Excel web query dialog?
>

5h.

Re: Want to download financial statements data from reuters.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 8:02 pm (PDT)



Right. You need to array-enter the formula over a range if you want to get
more than just the first cell of the table. Functions can only return data
to the cells they have been given access to.

On Sat, Jul 30, 2011 at 7:57 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
> It is showing this "In Millions of Pakistan Rupee (except for
> per share items)"
>
>
5i.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 8:05 pm (PDT)



confused :( can you explain a bit.
 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 8:02 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
Right. You need to array-enter the formula over a range if you want to get more than just the first cell of the table. Functions can only return data to the cells they have been given access to.

On Sat, Jul 30, 2011 at 7:57 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>It is showing this "In Millions of Pakistan Rupee            (except for per share items)"
>
>
>

5j.

Re: Want to download financial statements data from reuters.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 8:09 pm (PDT)



You're not gonna make me cut and paste from the documentation, are you?

On Sat, Jul 30, 2011 at 8:04 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
> confused :( can you explain a bit.
>
> Kind Regards
> Amir Rehman
> ------------------------------
> *From:* Randy Harmelink <rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Sunday, July 31, 2011 8:02 AM
> *Subject:* Re: [smf_addin] Want to download financial statements data from
> reuters.com
>
> Right. You need to array-enter the formula over a range if you want to get
> more than just the first cell of the table. Functions can only return data
> to the cells they have been given access to.
>
5k.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 8:11 pm (PDT)



I have downloaded the template but that was also not retrieving any data
 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 8:09 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
You're not gonna make me cut and paste from the documentation, are you?

On Sat, Jul 30, 2011 at 8:04 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>confused :( can you explain a bit.

>Kind Regards
>Amir Rehman
>
>
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Sunday, July 31, 2011 8:02 AM
>Subject: Re: [smf_addin] Want to download financial statements data from reuters.com
>

>Right. You need to array-enter the formula over a range if you want to get more than just the first cell of the table. Functions can only return data to the cells they have been given access to.
>

5l.

Re: Want to download financial statements data from reuters.com

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Sat Jul 30, 2011 8:14 pm (PDT)



got it. thanks
 

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 31, 2011 8:09 AM
Subject: Re: [smf_addin] Want to download financial statements data from reuters.com

 
You're not gonna make me cut and paste from the documentation, are you?

On Sat, Jul 30, 2011 at 8:04 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
>confused :( can you explain a bit.

>Kind Regards
>Amir Rehman
>
>
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Sunday, July 31, 2011 8:02 AM
>Subject: Re: [smf_addin] Want to download financial statements data from reuters.com
>

>Right. You need to array-enter the formula over a range if you want to get more than just the first cell of the table. Functions can only return data to the cells they have been given access to.
>

5m.

Re: Want to download financial statements data from reuters.com

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 8:15 pm (PDT)



Which template?

On Sat, Jul 30, 2011 at 8:10 PM, Amir Rehman <amir.rehman@yahoo.com> wrote:

>
> I have downloaded the template but that was also not retrieving any data
>
>
6a.

call OK, put not ok

Posted by: "bloteczka" akol@rogers.com   bloteczka

Sat Jul 30, 2011 7:46 pm (PDT)



I am using one of your templates to get options data. There is an array with this formula:
=smfGetOptionQuotes(B4:B203,$C$3:$O$3,1,"OX")
If I put in B column call data, for example: AMZN 8/05 2011 $225 CALL, the table works, if on the other side I change CALL to PUT or P - nothing comes out.
What am I doing wrong?

Thank you

6b.

Re: call OK, put not ok

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jul 30, 2011 7:49 pm (PDT)



As noted in the documentation, the "OX" data source only works for calls.

On Sat, Jul 30, 2011 at 7:45 PM, bloteczka <akol@rogers.com> wrote:

> I am using one of your templates to get options data. There is an array
> with this formula:
> =smfGetOptionQuotes(B4:B203,$C$3:$O$3,1,"OX")
> If I put in B column call data, for example: AMZN 8/05 2011 $225 CALL, the
> table works, if on the other side I change CALL to PUT or P - nothing comes
> out.
> What am I doing wrong?
>
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

READ MORE....