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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
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)

STREAMING OPTIONS.xlsm
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
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.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
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
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
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?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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)"
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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)"
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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.

Diposting oleh EXCEL FEED LEARNING di 20.16

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)