15 New Messages
Digest #2391
4b
Re: Option Chain Variable DDE formula Help Randy if you are able? by "Randy Harmelink" rharmelink
4d
Re: Option Chain Variable DDE formula Help Randy if you are able? by "tambourman2001" tambourman2001
Messages
Sun Nov 4, 2012 4:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Looks like a straight-forward extraction to me:
=RCHGetTableCell("
http://www.cpordevises.com/gold/quotations/rates?day=31&month=10&year=2012
",2,"Poids","Lingot")
On Sat, Nov 3, 2012 at 8:06 PM, drsues02 <drsues02@hotmail.com > wrote:
> Here is the website in question:
>
> http://www.cpordevises.com/gold/quotations/rates?day=31&month=10&year=2012
>
> I'd like to pull information for several different items in the table (for
> example: Lingot, Lingotin oR ® 10g, Krugerrand Sud Afrique, etc).
>
> I'd like to enter in a long series of dates in Excel in Column A, with the
> different items in columns B, C, D, etc - and have it pull in the info
> automatically.
>
> Basically, I'm trying to re-create the charts on the Graphics page, but
> with the actual data:
>
> http://www.cpordevises.com/gold/expertise-value/ingots-coins-quotation/lingot
>
=RCHGetTableCell(
http://www.cpordevi
",2,"Poids",
On Sat, Nov 3, 2012 at 8:06 PM, drsues02 <drsues02@hotmail.
> Here is the website in question:
>
> http://www.cpordevi
>
> I'd like to pull information for several different items in the table (for
> example: Lingot, Lingotin oR ® 10g, Krugerrand Sud Afrique, etc).
>
> I'd like to enter in a long series of dates in Excel in Column A, with the
> different items in columns B, C, D, etc - and have it pull in the info
> automatically.
>
> Basically, I'm trying to re-create the charts on the Graphics page, but
> with the actual data:
>
> http://www.cpordevi
>
Sun Nov 4, 2012 5:21 pm (PST) . Posted by:
"drsues02" drsues02
Thanks for the prompt reply. I could get the initial extraction to work,
but it seems to only be pulling the most current date, even if I modify
the day/month/year.
For example:
=RCHGetTableCell("http://www.cpordevises.com/gold/quotations/rates?day=2\
8&month=09&year=2012 ",2,"Poids","Lingot")
Still pulls the info from 11/2/2012 (42,870) and not the info from
9/28/2012 (43,610)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> Looks like a straight-forward extraction to me:
>
> =RCHGetTableCell("
>
http://www.cpordevises.com/gold/quotations/rates?day=31&month=10&year=20\
12
> ",2,"Poids","Lingot")
>
> On Sat, Nov 3, 2012 at 8:06 PM, drsues02 drsues02@... wrote:
>
> > Here is the website in question:
> >
> >
http://www.cpordevises.com/gold/quotations/rates?day=31&month=10&year=20\
12
> >
> > I'd like to pull information for several different items in the
table (for
> > example: Lingot, Lingotin oR ® 10g, Krugerrand Sud Afrique,
etc).
> >
> > I'd like to enter in a long series of dates in Excel in Column A,
with the
> > different items in columns B, C, D, etc - and have it pull in the
info
> > automatically.
> >
> > Basically, I'm trying to re-create the charts on the Graphics page,
but
> > with the actual data:
> >
> >
http://www.cpordevises.com/gold/expertise-value/ingots-coins-quotation/l\
ingot
> >
>
but it seems to only be pulling the most current date, even if I modify
the day/month/year.
For example:
=RCHGetTableCell(
8&month=09&year=
Still pulls the info from 11/2/2012 (42,870) and not the info from
9/28/2012 (43,610)
--- In smf_addin@yahoogrou
wrote:
>
> Looks like a straight-forward extraction to me:
>
> =RCHGetTableCell(
>
http://www.cpordevi
12
> ",2,"Poids",
>
> On Sat, Nov 3, 2012 at 8:06 PM, drsues02 drsues02@... wrote:
>
> > Here is the website in question:
> >
> >
http://www.cpordevi
12
> >
> > I'd like to pull information for several different items in the
table (for
> > example: Lingot, Lingotin oR ® 10g, Krugerrand Sud Afrique,
etc).
> >
> > I'd like to enter in a long series of dates in Excel in Column A,
with the
> > different items in columns B, C, D, etc - and have it pull in the
info
> > automatically.
> >
> > Basically, I'm trying to re-create the charts on the Graphics page,
but
> > with the actual data:
> >
> >
http://www.cpordevi
ingot
> >
>
Mon Nov 5, 2012 2:38 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Wouldn't your URL/formula need to be:
=RCHGetTableCell("
http://www.cpordevises.com/or/cotations/cours?jour=28&mois=9&annee=2012
",2,"Poids","Lingot")
On Sun, Nov 4, 2012 at 6:21 PM, drsues02 <drsues02@hotmail.com > wrote:
>
> Thanks for the prompt reply. I could get the initial extraction to work,
> but it seems to only be pulling the most current date, even if I modify the
> day/month/year.
>
> For example:
>
> =RCHGetTableCell("http://www.cpordevises.com/gold/quotations/rates?day=*28
> *&month=*09*&year=*2012*",2,"Poids","Lingot")
>
> Still pulls the info from 11/2/2012 (42,870) and not the info from
> 9/28/2012 (43,610)
>
=RCHGetTableCell(
http://www.cpordevi
",2,"Poids",
On Sun, Nov 4, 2012 at 6:21 PM, drsues02 <drsues02@hotmail.
>
> Thanks for the prompt reply. I could get the initial extraction to work,
> but it seems to only be pulling the most current date, even if I modify the
> day/month/year.
>
> For example:
>
> =RCHGetTableCell(
> *&month=*09*
>
> Still pulls the info from 11/2/2012 (42,870) and not the info from
> 9/28/2012 (43,610)
>
Sun Nov 4, 2012 12:09 pm (PST) . Posted by:
"José Azevedo" jma_resende
Hello!
I think it possible to simple, but I have some problems here:
- I want the number of "Shares Outstanding" of some stock, but in page fo
yahoo there a upperscript number.
Shares Outstanding"5"
How I can resolve this problem?
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=WMT+Key+Statistics ";1;"Shares
Outstanding*???*:")
- I want to change in link, the symbol of stock (WMT) by symbol in cell.
If I put WMT in D4, the code instead the WMT what are?
I try:
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=* "D4"*+Key+Statistics";1;"Shares
Outstanding*...*:")
I think it possible to simple, but I have some problems here:
- I want the number of "Shares Outstanding" of some stock, but in page fo
yahoo there a upperscript number.
Shares Outstanding"
How I can resolve this problem?
=RCHGetTableCell(
Outstanding*
- I want to change in link, the symbol of stock (WMT) by symbol in cell.
If I put WMT in D4, the code instead the WMT what are?
I try:
=RCHGetTableCell(
Outstanding*
Sun Nov 4, 2012 1:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just do:
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s= "&D4,1,"Shares
Outstanding")
On Sun, Nov 4, 2012 at 1:09 PM, José Azevedo <jmazevedo@gmail.com > wrote:
>
> I think it possible to simple, but I have some problems here:
>
> - I want the number of "Shares Outstanding" of some stock, but in page fo
> yahoo there a upperscript number.
>
> Shares Outstanding"5"
>
> How I can resolve this problem?
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=WMT+Key+Statistics ";1;"Shares
> Outstanding*???*:")
>
> - I want to change in link, the symbol of stock (WMT) by symbol in cell.
> If I put WMT in D4, the code instead the WMT what are?
> I try:
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=* "D4"*+Key+Statistics";1;"Shares
> Outstanding*...*:")
>
=RCHGetTableCell(
Outstanding"
On Sun, Nov 4, 2012 at 1:09 PM, José Azevedo <jmazevedo@gmail.
>
> I think it possible to simple, but I have some problems here:
>
> - I want the number of "Shares Outstanding" of some stock, but in page fo
> yahoo there a upperscript number.
>
> Shares Outstanding"
>
> How I can resolve this problem?
> =RCHGetTableCell(
> Outstanding*
>
> - I want to change in link, the symbol of stock (WMT) by symbol in cell.
> If I put WMT in D4, the code instead the WMT what are?
> I try:
> =RCHGetTableCell(
> Outstanding*
>
Sun Nov 4, 2012 1:06 pm (PST) . Posted by:
"José Azevedo" jma_resende
Aplogise for the not subject.
I want, for me, automatic this google doc:
https://docs.google.com/spreadsheet/ccc?key=0Avpd5UxEPqKddHAtQnlZRDF4dVpuNnVPM2RoZW4wc0E#gid=0
but without google.
thanks
Jose
On 4 November 2012 20:09, José Azevedo <jmazevedo@gmail.com > wrote:
> Hello!
>
> I think it possible to simple, but I have some problems here:
>
> - I want the number of "Shares Outstanding" of some stock, but in page fo
> yahoo there a upperscript number.
>
> Shares Outstanding"5"
>
> How I can resolve this problem?
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=WMT+Key+Statistics ";1;"Shares
> Outstanding*???*:")
>
> - I want to change in link, the symbol of stock (WMT) by symbol in cell.
> If I put WMT in D4, the code instead the WMT what are?
> I try:
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=* "D4"*+Key+Statistics";1;"Shares
> Outstanding*...*:")
>
I want, for me, automatic this google doc:
https://docs.
but without google.
thanks
Jose
On 4 November 2012 20:09, José Azevedo <jmazevedo@gmail.
> Hello!
>
> I think it possible to simple, but I have some problems here:
>
> - I want the number of "Shares Outstanding" of some stock, but in page fo
> yahoo there a upperscript number.
>
> Shares Outstanding"
>
> How I can resolve this problem?
> =RCHGetTableCell(
> Outstanding*
>
> - I want to change in link, the symbol of stock (WMT) by symbol in cell.
> If I put WMT in D4, the code instead the WMT what are?
> I try:
> =RCHGetTableCell(
> Outstanding*
>
Sun Nov 4, 2012 1:56 pm (PST) . Posted by:
"millerd1_smf" millerd1_smf
Randy,
I have been able to construct and algorithem to prepare a TOS DDE Option
chain specific varaible data call but have been stymied by a seemingly
simple issue and hope you have discovered a remedy.
The following concatenation formula (using range names for the
variables) prepares a DDE data call sequence, but I have not been able
to convert the valuation of this formula text string directly into a
formula result.
The concatention formula looks like this:
=CONCATENATE(
(RIGHT(Current_
ymmdd"),"C",
Opening_Character= "!'."
Closing_Character= "'"
Valuation of this concatention results in a text string that looks like
this, (note the leading apostrophe):
'=TOS|PERCENT_
There does not seem to be a way to pull or replace the leading
apostrophe characters at the front of the concatenation algorithem
result.
Asking for a value() of this character string results in a error caused
by that very front apostrophe. Have you got a way to converted a string
with a leading apostrophe text string directly into a variable formula?
=value(TOS|PERCENT_
trim the apostrophe= characters off the front using Mid gets an error
caused by the leading apostrophe:
=mid('=TOS|PERCENT_
I have also found that Excel search and replace refuses to find the
leading apostrophe string to convert this character string into a
variable formula. (could have sworn I could find and removed leading
apostrophes with Lotus123 and Quattro decades ago). To convert that
valuation result to a formula I find I have to manually edit each string
to delete that leading apostrophe. Certainly a macro could be written to
remove that leading apostrophe from a block of cells containing these
formula. I would prefer to produce a method to do this without having
to custom block an formula matrix area to remove that pesky apostrophe.
Any thoughts Randy would be appreciated and I will be glad to provide
the finished spreadsheet, or the sheet in its current developmental
condition.
Sun Nov 4, 2012 2:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The leading apostrophe is an indication that the value in the cell is a
text string. Otherwise, the "=" sign as a first byte would try to evaluate
it as a formula.
I think the solution is to format the cell as text BEFORE using it.
On Sun, Nov 4, 2012 at 2:56 PM, millerd1_smf <millerd1_airmail_net@yahoo.com
> wrote:
> I have been able to construct and algorithem to prepare a TOS DDE Option
> chain specific varaible data call but have been stymied by a seemingly
> simple issue and hope you have discovered a remedy.
>
> The following concatenation formula (using range names for the variables)
> prepares a DDE data call sequence, but I have not been able to convert the
> valuation of this formula text string directly into a formula result.
>
> The concatention formula looks like this:
>
> =CONCATENATE("=TOS|",Variable_DDE_Name,Opening_Character,Symbol,IF(VALUE(RIGHT(Current_Expiration,1))<>3,"W",""),TEXT(Current_Expiration_Date,"yymmdd"),"C",TEXT(Strike,0),Closing_Character)
>
> Opening_Character= "!'."
> Closing_Character= "'"
>
> Valuation of this concatention results in a text string that looks like
> this, (note the leading apostrophe):
> '=TOS|PERCENT_CHANGE!'.SPXW121109C1520'
>
> There does not seem to be a way to pull or replace the leading apostrophe
> characters at the front of the concatenation algorithem result.
>
> Asking for a value() of this character string results in a error caused by
> that very front apostrophe. Have you got a way to converted a string with
> a leading apostrophe text string directly into a variable formula?
>
> =value(TOS|PERCENT_CHANGE!'.SPXW121109C1520') does work but trying to trim
> the apostrophe= characters off the front using Mid gets an error caused by
> the leading apostrophe:
>
> =mid('=TOS|PERCENT_CHANGE!'.SPXW121109C1520',2,50)
>
> I have also found that Excel search and replace refuses to find
> the leading apostrophe string to convert this character string into a
> variable formula. (could have sworn I could find and removed leading
> apostrophes with Lotus123 and Quattro decades ago). To convert that
> valuation result to a formula I find I have to manually edit each string to
> delete that leading apostrophe. Certainly a macro could be written to
> remove that leading apostrophe from a block of cells containing these
> formula. I would prefer to produce a method to do this without having to
> custom block an formula matrix area to remove that pesky apostrophe.
>
> Any thoughts Randy would be appreciated and I will be glad to provide the
> finished spreadsheet, or the sheet in its current developmental condition.
>
text string. Otherwise, the "=" sign as a first byte would try to evaluate
it as a formula.
I think the solution is to format the cell as text BEFORE using it.
On Sun, Nov 4, 2012 at 2:56 PM, millerd1_smf <millerd1_airmail_
> wrote:
> I have been able to construct and algorithem to prepare a TOS DDE Option
> chain specific varaible data call but have been stymied by a seemingly
> simple issue and hope you have discovered a remedy.
>
> The following concatenation formula (using range names for the variables)
> prepares a DDE data call sequence, but I have not been able to convert the
> valuation of this formula text string directly into a formula result.
>
> The concatention formula looks like this:
>
> =CONCATENATE(
>
> Opening_Character= "!'."
> Closing_Character= "'"
>
> Valuation of this concatention results in a text string that looks like
> this, (note the leading apostrophe):
> '=TOS|PERCENT_
>
> There does not seem to be a way to pull or replace the leading apostrophe
> characters at the front of the concatenation algorithem result.
>
> Asking for a value() of this character string results in a error caused by
> that very front apostrophe. Have you got a way to converted a string with
> a leading apostrophe text string directly into a variable formula?
>
> =value(TOS|PERCENT_
> the apostrophe= characters off the front using Mid gets an error caused by
> the leading apostrophe:
>
> =mid('=TOS|PERCENT_
>
> I have also found that Excel search and replace refuses to find
> the leading apostrophe string to convert this character string into a
> variable formula. (could have sworn I could find and removed leading
> apostrophes with Lotus123 and Quattro decades ago). To convert that
> valuation result to a formula I find I have to manually edit each string to
> delete that leading apostrophe. Certainly a macro could be written to
> remove that leading apostrophe from a block of cells containing these
> formula. I would prefer to produce a method to do this without having to
> custom block an formula matrix area to remove that pesky apostrophe.
>
> Any thoughts Randy would be appreciated and I will be glad to provide the
> finished spreadsheet, or the sheet in its current developmental condition.
>
Sun Nov 4, 2012 4:32 pm (PST) . Posted by:
"millerd1_smf" millerd1_smf
Appreciated your fast comeback.
Well I wanted the data number as a result, so cell was formated as a number. I just tried formatting as text with no joy, and general for no joy either. Both reformatted concatenation formula values still start with that apostrophe. Find and replace still cannot find that apostrophe or the other two in that character string.
Any other ideas?
Millerd1
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The leading apostrophe is an indication that the value in the cell is a
> text string. Otherwise, the "=" sign as a first byte would try to evaluate
> it as a formula.
>
> I think the solution is to format the cell as text BEFORE using it.
>
> On Sun, Nov 4, 2012 at 2:56 PM, millerd1_smf <millerd1_airmail_net@...
> > wrote:
>
> > I have been able to construct and algorithem to prepare a TOS DDE Option
> > chain specific varaible data call but have been stymied by a seemingly
> > simple issue and hope you have discovered a remedy.
> >
> > The following concatenation formula (using range names for the variables)
> > prepares a DDE data call sequence, but I have not been able to convert the
> > valuation of this formula text string directly into a formula result.
> >
> > The concatention formula looks like this:
> >
> > =CONCATENATE("=TOS|",Variable_DDE_Name,Opening_Character,Symbol,IF(VALUE(RIGHT(Current_Expiration,1))<>3,"W",""),TEXT(Current_Expiration_Date,"yymmdd"),"C",TEXT(Strike,0),Closing_Character)
> >
> > Opening_Character= "!'."
> > Closing_Character= "'"
> >
> > Valuation of this concatention results in a text string that looks like
> > this, (note the leading apostrophe):
> > '=TOS|PERCENT_CHANGE!'.SPXW121109C1520'
> >
> > There does not seem to be a way to pull or replace the leading apostrophe
> > characters at the front of the concatenation algorithem result.
> >
> > Asking for a value() of this character string results in a error caused by
> > that very front apostrophe. Have you got a way to converted a string with
> > a leading apostrophe text string directly into a variable formula?
> >
> > =value(TOS|PERCENT_CHANGE!'.SPXW121109C1520') does work but trying to trim
> > the apostrophe= characters off the front using Mid gets an error caused by
> > the leading apostrophe:
> >
> > =mid('=TOS|PERCENT_CHANGE!'.SPXW121109C1520',2,50)
> >
> > I have also found that Excel search and replace refuses to find
> > the leading apostrophe string to convert this character string into a
> > variable formula. (could have sworn I could find and removed leading
> > apostrophes with Lotus123 and Quattro decades ago). To convert that
> > valuation result to a formula I find I have to manually edit each string to
> > delete that leading apostrophe. Certainly a macro could be written to
> > remove that leading apostrophe from a block of cells containing these
> > formula. I would prefer to produce a method to do this without having to
> > custom block an formula matrix area to remove that pesky apostrophe.
> >
> > Any thoughts Randy would be appreciated and I will be glad to provide the
> > finished spreadsheet, or the sheet in its current developmental condition.
> >
>
Well I wanted the data number as a result, so cell was formated as a number. I just tried formatting as text with no joy, and general for no joy either. Both reformatted concatenation formula values still start with that apostrophe. Find and replace still cannot find that apostrophe or the other two in that character string.
Any other ideas?
Millerd1
--- In smf_addin@yahoogrou
>
> The leading apostrophe is an indication that the value in the cell is a
> text string. Otherwise, the "=" sign as a first byte would try to evaluate
> it as a formula.
>
> I think the solution is to format the cell as text BEFORE using it.
>
> On Sun, Nov 4, 2012 at 2:56 PM, millerd1_smf <millerd1_airmail_
> > wrote:
>
> > I have been able to construct and algorithem to prepare a TOS DDE Option
> > chain specific varaible data call but have been stymied by a seemingly
> > simple issue and hope you have discovered a remedy.
> >
> > The following concatenation formula (using range names for the variables)
> > prepares a DDE data call sequence, but I have not been able to convert the
> > valuation of this formula text string directly into a formula result.
> >
> > The concatention formula looks like this:
> >
> > =CONCATENATE(
> >
> > Opening_Character= "!'."
> > Closing_Character= "'"
> >
> > Valuation of this concatention results in a text string that looks like
> > this, (note the leading apostrophe):
> > '=TOS|PERCENT_
> >
> > There does not seem to be a way to pull or replace the leading apostrophe
> > characters at the front of the concatenation algorithem result.
> >
> > Asking for a value() of this character string results in a error caused by
> > that very front apostrophe. Have you got a way to converted a string with
> > a leading apostrophe text string directly into a variable formula?
> >
> > =value(TOS|PERCENT_
> > the apostrophe= characters off the front using Mid gets an error caused by
> > the leading apostrophe:
> >
> > =mid('=TOS|PERCENT_
> >
> > I have also found that Excel search and replace refuses to find
> > the leading apostrophe string to convert this character string into a
> > variable formula. (could have sworn I could find and removed leading
> > apostrophes with Lotus123 and Quattro decades ago). To convert that
> > valuation result to a formula I find I have to manually edit each string to
> > delete that leading apostrophe. Certainly a macro could be written to
> > remove that leading apostrophe from a block of cells containing these
> > formula. I would prefer to produce a method to do this without having to
> > custom block an formula matrix area to remove that pesky apostrophe.
> >
> > Any thoughts Randy would be appreciated and I will be glad to provide the
> > finished spreadsheet, or the sheet in its current developmental condition.
> >
>
Sun Nov 4, 2012 6:06 pm (PST) . Posted by:
"tambourman2001" tambourman2001
This may help:
http://www.elitetrader.com/vb/showthread.php?threadid=223105
-dave
--- In smf_addin@yahoogroups.com , "millerd1_smf" <millerd1_airmail_net@...> wrote:
>
> Appreciated your fast comeback.
>
> Well I wanted the data number as a result, so cell was formated as a number. I just tried formatting as text with no joy, and general for no joy either. Both reformatted concatenation formula values still start with that apostrophe. Find and replace still cannot find that apostrophe or the other two in that character string.
>
> Any other ideas?
>
> Millerd1
>
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > The leading apostrophe is an indication that the value in the cell is a
> > text string. Otherwise, the "=" sign as a first byte would try to evaluate
> > it as a formula.
> >
> > I think the solution is to format the cell as text BEFORE using it.
> >
> > On Sun, Nov 4, 2012 at 2:56 PM, millerd1_smf <millerd1_airmail_net@
> > > wrote:
> >
> > > I have been able to construct and algorithem to prepare a TOS DDE Option
> > > chain specific varaible data call but have been stymied by a seemingly
> > > simple issue and hope you have discovered a remedy.
> > >
> > > The following concatenation formula (using range names for the variables)
> > > prepares a DDE data call sequence, but I have not been able to convert the
> > > valuation of this formula text string directly into a formula result.
> > >
> > > The concatention formula looks like this:
> > >
> > > =CONCATENATE("=TOS|",Variable_DDE_Name,Opening_Character,Symbol,IF(VALUE(RIGHT(Current_Expiration,1))<>3,"W",""),TEXT(Current_Expiration_Date,"yymmdd"),"C",TEXT(Strike,0),Closing_Character)
> > >
> > > Opening_Character= "!'."
> > > Closing_Character= "'"
> > >
> > > Valuation of this concatention results in a text string that looks like
> > > this, (note the leading apostrophe):
> > > '=TOS|PERCENT_CHANGE!'.SPXW121109C1520'
> > >
> > > There does not seem to be a way to pull or replace the leading apostrophe
> > > characters at the front of the concatenation algorithem result.
> > >
> > > Asking for a value() of this character string results in a error caused by
> > > that very front apostrophe. Have you got a way to converted a string with
> > > a leading apostrophe text string directly into a variable formula?
> > >
> > > =value(TOS|PERCENT_CHANGE!'.SPXW121109C1520') does work but trying to trim
> > > the apostrophe= characters off the front using Mid gets an error caused by
> > > the leading apostrophe:
> > >
> > > =mid('=TOS|PERCENT_CHANGE!'.SPXW121109C1520',2,50)
> > >
> > > I have also found that Excel search and replace refuses to find
> > > the leading apostrophe string to convert this character string into a
> > > variable formula. (could have sworn I could find and removed leading
> > > apostrophes with Lotus123 and Quattro decades ago). To convert that
> > > valuation result to a formula I find I have to manually edit each string to
> > > delete that leading apostrophe. Certainly a macro could be written to
> > > remove that leading apostrophe from a block of cells containing these
> > > formula. I would prefer to produce a method to do this without having to
> > > custom block an formula matrix area to remove that pesky apostrophe.
> > >
> > > Any thoughts Randy would be appreciated and I will be glad to provide the
> > > finished spreadsheet, or the sheet in its current developmental condition.
> > >
> >
>
http://www.elitetra
-dave
--- In smf_addin@yahoogrou
>
> Appreciated your fast comeback.
>
> Well I wanted the data number as a result, so cell was formated as a number. I just tried formatting as text with no joy, and general for no joy either. Both reformatted concatenation formula values still start with that apostrophe. Find and replace still cannot find that apostrophe or the other two in that character string.
>
> Any other ideas?
>
> Millerd1
>
>
>
>
> --- In smf_addin@yahoogrou
> >
> > The leading apostrophe is an indication that the value in the cell is a
> > text string. Otherwise, the "=" sign as a first byte would try to evaluate
> > it as a formula.
> >
> > I think the solution is to format the cell as text BEFORE using it.
> >
> > On Sun, Nov 4, 2012 at 2:56 PM, millerd1_smf <millerd1_airmail_
> > > wrote:
> >
> > > I have been able to construct and algorithem to prepare a TOS DDE Option
> > > chain specific varaible data call but have been stymied by a seemingly
> > > simple issue and hope you have discovered a remedy.
> > >
> > > The following concatenation formula (using range names for the variables)
> > > prepares a DDE data call sequence, but I have not been able to convert the
> > > valuation of this formula text string directly into a formula result.
> > >
> > > The concatention formula looks like this:
> > >
> > > =CONCATENATE(
> > >
> > > Opening_Character= "!'."
> > > Closing_Character= "'"
> > >
> > > Valuation of this concatention results in a text string that looks like
> > > this, (note the leading apostrophe):
> > > '=TOS|PERCENT_
> > >
> > > There does not seem to be a way to pull or replace the leading apostrophe
> > > characters at the front of the concatenation algorithem result.
> > >
> > > Asking for a value() of this character string results in a error caused by
> > > that very front apostrophe. Have you got a way to converted a string with
> > > a leading apostrophe text string directly into a variable formula?
> > >
> > > =value(TOS|PERCENT_
> > > the apostrophe= characters off the front using Mid gets an error caused by
> > > the leading apostrophe:
> > >
> > > =mid('=TOS|PERCENT_
> > >
> > > I have also found that Excel search and replace refuses to find
> > > the leading apostrophe string to convert this character string into a
> > > variable formula. (could have sworn I could find and removed leading
> > > apostrophes with Lotus123 and Quattro decades ago). To convert that
> > > valuation result to a formula I find I have to manually edit each string to
> > > delete that leading apostrophe. Certainly a macro could be written to
> > > remove that leading apostrophe from a block of cells containing these
> > > formula. I would prefer to produce a method to do this without having to
> > > custom block an formula matrix area to remove that pesky apostrophe.
> > >
> > > Any thoughts Randy would be appreciated and I will be glad to provide the
> > > finished spreadsheet, or the sheet in its current developmental condition.
> > >
> >
>
Sun Nov 4, 2012 2:22 pm (PST) . Posted by:
"corbanbates" corbanbates
All,
Thanks for the quick replies. A sample page from the FDIC website would be this...
http://www2.fdic.gov/idasp/StruReportNew.aspinCert1=31286&ReportName=10&From=EzFind
The URL is exactly the same for every bank with the exception of its FDIC Certificate number. In this case it is 31286.
I have the FDIC certificate number for each bank so I could input their exact URL to get to their page. Is there some type of formula that I can input the webpage and then tell it to extract certain numbers from that webpage?
Thanks again!!!!
Corban
Thanks for the quick replies. A sample page from the FDIC website would be this...
http://www2.
The URL is exactly the same for every bank with the exception of its FDIC Certificate number. In this case it is 31286.
I have the FDIC certificate number for each bank so I could input their exact URL to get to their page. Is there some type of formula that I can input the webpage and then tell it to extract certain numbers from that webpage?
Thanks again!!!!
Corban
Sun Nov 4, 2012 2:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I get a "Page Not Found" for your URL...
It appears to be the same issue we had when you asked the question several
years ago:
http://finance.groups.yahoo.com/group/smf_addin/messages/7352?threaded=1&m=e&var=1&tidx=1
The data is presented within a frame, but the frame content won't display
as its own web page.
On Sun, Nov 4, 2012 at 3:22 PM, corbanbates <corbanbates@yahoo.com > wrote:
>
> Thanks for the quick replies. A sample page from the FDIC website would be
> this...
>
>
> http://www2.fdic.gov/idasp/StruReportNew.aspinCert1=31286&ReportName=10&From=EzFind
>
> The URL is exactly the same for every bank with the exception of its FDIC
> Certificate number. In this case it is 31286.
>
> I have the FDIC certificate number for each bank so I could input their
> exact URL to get to their page. Is there some type of formula that I can
> input the webpage and then tell it to extract certain numbers from that
> webpage?
>
It appears to be the same issue we had when you asked the question several
years ago:
http://finance.
The data is presented within a frame, but the frame content won't display
as its own web page.
On Sun, Nov 4, 2012 at 3:22 PM, corbanbates <corbanbates@
>
> Thanks for the quick replies. A sample page from the FDIC website would be
> this...
>
>
> http://www2.
>
> The URL is exactly the same for every bank with the exception of its FDIC
> Certificate number. In this case it is 31286.
>
> I have the FDIC certificate number for each bank so I could input their
> exact URL to get to their page. Is there some type of formula that I can
> input the webpage and then tell it to extract certain numbers from that
> webpage?
>
Sun Nov 4, 2012 3:28 pm (PST) . Posted by:
"corbanbates" corbanbates
Randy,
Sorry. It looks like one letter was left off the link I gave you before. Try this link.
http://www2.fdic.gov/idasp/StruReportNew.asp?inCert1=31286&ReportName=10&From=EzFind
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I get a "Page Not Found" for your URL...
>
> It appears to be the same issue we had when you asked the question several
> years ago:
>
> http://finance.groups.yahoo.com/group/smf_addin/messages/7352?threaded=1&m=e&var=1&tidx=1
>
> The data is presented within a frame, but the frame content won't display
> as its own web page.
>
> On Sun, Nov 4, 2012 at 3:22 PM, corbanbates <corbanbates@...> wrote:
>
> >
> > Thanks for the quick replies. A sample page from the FDIC website would be
> > this...
> >
> >
> > http://www2.fdic.gov/idasp/StruReportNew.aspinCert1=31286&ReportName=10&From=EzFind
> >
> > The URL is exactly the same for every bank with the exception of its FDIC
> > Certificate number. In this case it is 31286.
> >
> > I have the FDIC certificate number for each bank so I could input their
> > exact URL to get to their page. Is there some type of formula that I can
> > input the webpage and then tell it to extract certain numbers from that
> > webpage?
> >
>
Sorry. It looks like one letter was left off the link I gave you before. Try this link.
http://www2.
--- In smf_addin@yahoogrou
>
> I get a "Page Not Found" for your URL...
>
> It appears to be the same issue we had when you asked the question several
> years ago:
>
> http://finance.
>
> The data is presented within a frame, but the frame content won't display
> as its own web page.
>
> On Sun, Nov 4, 2012 at 3:22 PM, corbanbates <corbanbates@
>
> >
> > Thanks for the quick replies. A sample page from the FDIC website would be
> > this...
> >
> >
> > http://www2.
> >
> > The URL is exactly the same for every bank with the exception of its FDIC
> > Certificate number. In this case it is 31286.
> >
> > I have the FDIC certificate number for each bank so I could input their
> > exact URL to get to their page. Is there some type of formula that I can
> > input the webpage and then tell it to extract certain numbers from that
> > webpage?
> >
>
Sun Nov 4, 2012 4:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Same problem as before -- the data you want is within a frame, but the
frame can't be addressed directly.
On Sun, Nov 4, 2012 at 4:28 PM, corbanbates <corbanbates@yahoo.com > wrote:
>
> Sorry. It looks like one letter was left off the link I gave you before.
> Try this link.
>
>
> http://www2.fdic.gov/idasp/StruReportNew.asp?inCert1=31286&ReportName=10&From=EzFind
>
frame can't be addressed directly.
On Sun, Nov 4, 2012 at 4:28 PM, corbanbates <corbanbates@
>
> Sorry. It looks like one letter was left off the link I gave you before.
> Try this link.
>
>
> http://www2.
>
Mon Nov 5, 2012 12:14 am (PST) . Posted by:
"wongkayau" wongkayau
Hi Randy,
May you please guide us on how to extract the "Open High Low CLose VOl" from the flash chart? Thank you so much.
Cheers,
Laurent
--- In smf_addin@yahoogroups.com , R Marshal <rmarshal78@...> wrote:
>
> Hi Randy,
> Essentially looking to get the Open High Low CLose VOlume data points into the excel for the time period selected .
>
> http://charts.reuters.com/reuters/enhancements/US/interactiveChart/chart.asp?symbol=MSFT.OQ
>
> regards,
> Marshal.
>
>
>
>
> ________________________________
> From: Randy Harmelink <rharmelink@...>
> To: smf_addin@yahoogroups.com
> Sent: Tuesday, 19 June 2012 12:53 PM
> Subject: Re: [smf_addin] Getting Chart data to excel ( Reuters)
>
>
> ��
> What data in particular are you trying to extract?
>
>
> On Mon, Jun 18, 2012 at 11:45 PM, Viju Joseph <josephviju@...> wrote:
>
>
> >How do i go about extracting data from the frame. Can you guide plz ?
> >
> >
> >On Tue, Jun 19, 2012 at 12:12 PM, Randy Harmelink <rharmelink@...> wrote:
> >
> >
> >>I'm not quite sure exactly what you're after, but you'd need to extract the data from the frame. Not a trivial task:
> >>
> >>http://charts.reuters.com/reuters/enhancements/US/interactiveChart/chart.asp?symbol=MSFT.OQ
> >>
>
May you please guide us on how to extract the "Open High Low CLose VOl" from the flash chart? Thank you so much.
Cheers,
Laurent
--- In smf_addin@yahoogrou
>
> Hi Randy,
> Essentially looking to get the Open High Low CLose VOlume data points into the excel for the time period selected .
>
> http://charts.
>
> regards,
> Marshal.
>
>
>
>
> ____________
> From: Randy Harmelink <rharmelink@
> To: smf_addin@yahoogrou
> Sent: Tuesday, 19 June 2012 12:53 PM
> Subject: Re: [smf_addin] Getting Chart data to excel ( Reuters)
>
>
> ��
> What data in particular are you trying to extract?
>
>
> On Mon, Jun 18, 2012 at 11:45 PM, Viju Joseph <josephviju@
>
>
> >How do i go about extracting data from the frame. Can you guide plz ?
> >
> >
> >On Tue, Jun 19, 2012 at 12:12 PM, Randy Harmelink <rharmelink@
> >
> >
> >>I'm not quite sure exactly what you're after, but you'd need to extract the data from the frame. Not a trivial task:
> >>
> >>http://charts.
> >>
>
Tidak ada komentar:
Posting Komentar