15 Messages
Digest #4375
Messages
Sun Aug 5, 2018 8:13 am (PDT) . Posted by:
s_trader888
Thanks, Randy. Tried inserting (copy & paste) that formula, but getting a blank cell. (Worksheet appears to be pulling in other Finviz data fine.)
Also noticed that every time I click on that cell, it opens a new Finviz tab in the browser. If the browser's not open already, it will open it to the Finviz page.
Some miscellaneous notes that may have nothing to do with this, but just in case:
- Using Office 2013 on Windows 7 Home Premium
- Happened with both Firefox and IE 11 as default browsers.
Initially asked how to do this using Finviz because my stock watchlist is set up to use that as its data source, and has worked great all these years.. Although company names were never crucial for that watchlist, it would've been a nice addition... and thought I could kill two birds with one stone in addressing this new need.
But I'd be fine with using a site other than Finviz, and/or using any other SMF Addin function to generate the company names, if that would be easier. My current need is just to generate company names from an existing list of stock symbols.
When I skimmed thru "recent" SMF Addin developments, it appeared that the common sources like Yahoo Finance or MSN are no longer viable as alternatives to Finviz for getting something simple like company names. Is a convenient substitute (or more direct approach) available if I can't get the formula you provided to work?
Also noticed that every time I click on that cell, it opens a new Finviz tab in the browser. If the browser'
Some miscellaneous notes that may have nothing to do with this, but just in case:
- Using Office 2013 on Windows 7 Home Premium
- Happened with both Firefox and IE 11 as default browsers.
Initially asked how to do this using Finviz because my stock watchlist is set up to use that as its data source, and has worked great all these years.. Although company names were never crucial for that watchlist, it would've been a nice addition... and thought I could kill two birds with one stone in addressing this new need.
But I'd be fine with using a site other than Finviz, and/or using any other SMF Addin function to generate the company names, if that would be easier. My current need is just to generate company names from an existing list of stock symbols.
When I skimmed thru "recent" SMF Addin developments, it appeared that the common sources like Yahoo Finance or MSN are no longer viable as alternatives to Finviz for getting something simple like company names. Is a convenient substitute (or more direct approach) available if I can't get the formula you provided to work?
Sun Aug 5, 2018 8:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If it's opening a browser, you're probably pasting it incorrectly. If you
just go to EXCEL and hit ctrl+v, you're pasting it as HTML. Try alt+e+s+t
to paste it as text. What do you get if you just paste:
=smfGetTagContent("https://finviz.com/quote.ashx?t="&$A1,"title",1)
I usually copy everything AFTER the "=" sign, then go to an EXCEL cell,
type "=" and then paste the formula.
Any browser selection would be irrelevant to add-in function processing.
The best way to get a bunch of names would be an array-entered
smfGetYahooPortfolioView() function. It could get hundreds of them with one
Internet access.
On Sun, Aug 5, 2018 at 8:13 AM, 888hitrader@
....
wrote:
>
> Thanks, Randy. Tried inserting (copy & paste) that formula, but getting a
> blank cell. (Worksheet appears to be pulling in other Finviz data fine.)
>
> Also noticed that every time I click on that cell, it opens a new Finviz
> tab in the browser. If the browser's not open already, it will open it to
> the Finviz page.
>
> Some miscellaneous notes that may have nothing to do with this, but just
> in case:
> - Using Office 2013 on Windows 7 Home Premium
> - Happened with both Firefox and IE 11 a
> s default browsers.
>
> Initially asked how to do this using Finviz because my stock watchlist is
> set up to use that as its data source, and has worked great all these
> years. Although company names were never crucial for that watchlist, it
> would've been a nice addition... and thought I could kill two birds with
> one stone in addressing this new need.
>
> But I'd be fine with using a site other than Finviz, and/or using any
> other SMF Addin function to generate the company names, if that would be
> easier. My current need is just to generate company names from an
> existing list of stock symbols.
>
> When I skimmed thru "recent" SMF Addin developments, it appeared that the
> common sources like Yahoo Finance or MSN are no longer viable as
> alternatives to Finviz for getting something simple like company names.. Is
> a convenient substitute (or more direct approach) available if I can't get
> the formula you provided to work?
>
just go to EXCEL and hit ctrl+v, you're pasting it as HTML. Try alt+e+s+t
to paste it as text. What do you get if you just paste:
=smfGetTagContent("https://finviz.com/quote.ashx?t="&$A1,"
I usually copy everything AFTER the "=" sign, then go to an EXCEL cell,
type "=" and then paste the formula.
Any browser selection would be irrelevant to add-in function processing.
The best way to get a bunch of names would be an array-entered
smfGetYahooPortfoli
Internet access.
On Sun, Aug 5, 2018 at 8:13 AM, 888hitrader@
....
wrote:
>
> Thanks, Randy. Tried inserting (copy & paste) that formula, but getting a
> blank cell. (Worksheet appears to be pulling in other Finviz data fine.)
>
> Also noticed that every time I click on that cell, it opens a new Finviz
> tab in the browser. If the browser'
> the Finviz page.
>
> Some miscellaneous notes that may have nothing to do with this, but just
> in case:
> - Using Office 2013 on Windows 7 Home Premium
> - Happened with both Firefox and IE 11 a
> s default browsers.
>
> Initially asked how to do this using Finviz because my stock watchlist is
> set up to use that as its data source, and has worked great all these
> years. Although company names were never crucial for that watchlist, it
> would've been a nice addition... and thought I could kill two birds with
> one stone in addressing this new need.
>
> But I'd be fine with using a site other than Finviz, and/or using any
> other SMF Addin function to generate the company names, if that would be
> easier. My current need is just to generate company names from an
> existing list of stock symbols.
>
> When I skimmed thru "recent" SMF Addin developments, it appeared that the
> common sources like Yahoo Finance or MSN are no longer viable as
> alternatives to Finviz for getting something simple like company names.. Is
> a convenient substitute (or more direct approach) available if I can't get
> the formula you provided to work?
>
Sun Aug 5, 2018 9:53 am (PDT) . Posted by:
s_trader888
Yep, got your original suggestion to work -- must've been doing the copy/paste incorrectly, doh!
Haven't been able to get the second approach, "=smfGetTagContent(....)" to work yet -- resulting in "Error." I'll try experimenting more with that later, probably making some other silly mistake, lol.
And yes -- a long while back, in response to another question I posted, believe you indicated that my current approach using SMF Addin is inefficient, and that I should consider using arrays. My Excel knowledge is very limited -- I'm able to achieve what I need to do, but mostly via brute force. So I'll revisit that suggestion again as well.
Trading itself has always been my #1 focus and challenge... but it's amazing how much other stuff I've had to learn in support of that pursuit, especially with regard to apps, software, coding, etc.
Thanks again!
Haven't been able to get the second approach, "=smfGetTagCon
And yes -- a long while back, in response to another question I posted, believe you indicated that my current approach using SMF Addin is inefficient, and that I should consider using arrays. My Excel knowledge is very limited -- I'm able to achieve what I need to do, but mostly via brute force. So I'll revisit that suggestion again as well.
Trading itself has always been my #1 focus and challenge... but it's amazing how much other stuff I've had to learn in support of that pursuit, especially with regard to apps, software, coding, etc.
Thanks again!
Sun Aug 5, 2018 8:58 am (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Hi
I am tring to extract some data from tmxmoney.com. I need the Est. EPS data. for a specific date. I tried this
RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date="&E11&"market=TSX";7)
where range E11 = the date.
It send me the column name Est. EPS. I want the data under (row under)
I'm not able (and I dont understand how) to put the row number I want.
Maybe there is another way to get those data from the tmxmoney.com Earnings Calendar,
If somebody can help me I would be very thankful.
Thanks in advance.
I am tring to extract some data from tmxmoney.com. I need the Est. EPS data. for a specific date. I tried this
RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date="&E11&"
where range E11 = the date.
It send me the column name Est. EPS. I want the data under (row under)
I'm not able (and I dont understand how) to put the row number I want.
Maybe there is another way to get those data from the tmxmoney.com Earnings Calendar,
If somebody can help me I would be very thankful.
Thanks in advance.
Sun Aug 5, 2018 9:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your problem is that you need to format the date for the URL. If you just
reference it, you'll get the EXCEL serial date (a numeric value).
You can grab the whole table with:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company
Name")
On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
....
wrote:
>
> I am tring to extract some data from tmxmoney.com. I need the Est. EPS
> data. for a specific date. I tried this
>
> *RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date=
> <https://web.tmxmoney.com/earnings_cal.php?date=>"&E11&"market=TSX";7)*
>
> where range E11 = the date.
>
> It send me the column name *Est. EPS. I* want the data under (row under)
>
> I'm not able (and I dont understand how) to put the row number I want.
>
> Maybe there is another way to get those data from the tmxmoney.com
> Earnings Calendar,
>
> If somebody can help me I would be very thankful.
>
>
>
reference it, you'll get the EXCEL serial date (a numeric value).
You can grab the whole table with:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company
Name")
On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
....
wrote:
>
> I am tring to extract some data from tmxmoney.com. I need the Est. EPS
> data. for a specific date. I tried this
>
> *RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date=
> <https://web.tmxmoney.com/earnings_cal.php?date=>"&E11&&quo
>
> where range E11 = the date.
>
> It send me the column name *Est. EPS. I* want the data under (row under)
>
> I'm not able (and I dont understand how) to put the row number I want.
>
> Maybe there is another way to get those data from the tmxmoney.com
> Earnings Calendar,
>
> If somebody can help me I would be very thankful.
>
>
>
Sun Aug 5, 2018 11:41 am (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Thanks for the fast answer
I put in a matrice the formula
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
but the only thing I get is the name of field (Symbol Company name Period....).
No data
What am I doing wrong !
Very thankful to you
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 12:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Your problem is that you need to format the date for the URL. If you just reference it, you'll get the EXCEL serial date (a numeric value).
You can grab the whole table with:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
....
wrote:
I am tring to extract some data from tmxmoney.com. I need the Est. EPS data. for a specific date. I tried this
RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date="&E11&"market=TSX";7)
where range E11 = the date.
It send me the column name Est. EPS. I want the data under (row under)
I'm not able (and I dont understand how) to put the row number I want.
Maybe there is another way to get those data from the tmxmoney.com Earnings Calendar,
If somebody can help me I would be very thankful.
I put in a matrice the formula
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
but the only thing I get is the name of field (Symbol Company name Period....).
No data
What am I doing wrong !
Very thankful to you
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 12:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Your problem is that you need to format the date for the URL. If you just reference it, you'll get the EXCEL serial date (a numeric value).
You can grab the whole table with:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
....
wrote:
I am tring to extract some data from tmxmoney.com. I need the Est. EPS data. for a specific date. I tried this
RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date="&E11&"
where range E11 = the date.
It send me the column name Est. EPS. I want the data under (row under)
I'm not able (and I dont understand how) to put the row number I want.
Maybe there is another way to get those data from the tmxmoney.com Earnings Calendar,
If somebody can help me I would be very thankful.
Sun Aug 5, 2018 11:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What do you have in cell E11? It needs to be an EXCEL serial date, not a
text string.
On Sun, Aug 5, 2018 at 11:41 AM, 'Guy' descormiersg@videotron.ca
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Thanks for the fast answer
>
> I put in a matrice the formula
>
> *=RCHGetHTMLTable("*
> *https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company*
> <https://web.tmxmoney.com/earnings_cal.php?date=%22&TEXT(E11,%22yyyy-mm-dd%22)&%22&market=TSX%22,%22%3ECompany>*
> Name")*
>
> but the only thing I get is the name of field (Symbol Company name
> Period...).
> No data
>
> What am I doing wrong !
>
> Very thankful to you
>
> Guy
>
> *From:* Randy Harmelink rharmelink@gmail.com [smf_addin]
> *Sent:* Sunday, August 5, 2018 12:31 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] RCHGetTableCell
>
>
>
> Your problem is that you need to format the date for the URL. If you just
> reference it, you'll get the EXCEL serial date (a numeric value).
>
> You can grab the whole table with:
>
> =RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date=
> "&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
>
> On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
> ...
> wrote:
>
>>
>> I am tring to extract some data from tmxmoney.com. I need the Est.. EPS
>> data. for a specific date. I tried this
>>
>>
>> *RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date=
>> <https://web.tmxmoney.com/earnings_cal.php?date=>"&E11&"market=TSX";7)*
>>
>> where range E11 = the date.
>>
>> It send me the column name *Est. EPS. I* want the data under (row under)
>>
>> I'm not able (and I dont understand how) to put the row number I want.
>>
>> Maybe there is another way to get those data from the tmxmoney.com
>> Earnings Calendar,
>>
>> If somebody can help me I would be very thankful.
>>
>>
>>
>
>
>
>
text string.
On Sun, Aug 5, 2018 at 11:41 AM, 'Guy' descormiersg@videotron.ca
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Thanks for the fast answer
>
> I put in a matrice the formula
>
> *=RCHGetHTMLTable("*
> *https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company*
> <https://web.tmxmoney.com/earnings_cal.php?date=%22&TEXT(E11,%22yyyy-mm-dd%22)&%22&market=TSX%22,%22%3ECompany>*
> Name")*
>
> but the only thing I get is the name of field (Symbol Company name
> Period...).
> No data
>
> What am I doing wrong !
>
> Very thankful to you
>
> Guy
>
> *From:* Randy Harmelink rharmelink@gmail.com [smf_addin]
> *Sent:* Sunday, August 5, 2018 12:31 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] RCHGetTableCell
>
>
>
> Your problem is that you need to format the date for the URL. If you just
> reference it, you'll get the EXCEL serial date (a numeric value).
>
> You can grab the whole table with:
>
> =RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date=
> "&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
>
> On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
> ...
> wrote:
>
>>
>> I am tring to extract some data from tmxmoney.com. I need the Est.. EPS
>> data. for a specific date. I tried this
>>
>>
>> *RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date=
>> <https://web.tmxmoney.com/earnings_cal.php?date=>"&E11&&quo
>>
>> where range E11 = the date.
>>
>> It send me the column name *Est. EPS. I* want the data under (row under)
>>
>> I'm not able (and I dont understand how) to put the row number I want.
>>
>> Maybe there is another way to get those data from the tmxmoney.com
>> Earnings Calendar,
>>
>> If somebody can help me I would be very thankful.
>>
>>
>>
>
>
>
>
Sun Aug 5, 2018 12:26 pm (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Hi randy
It is a serial date in E11
I tried 2 ways : One give me only the fields (sheets EPS) and the others #Valeur
Thank you in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 2:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
What do you have in cell E11? It needs to be an EXCEL serial date, not a text string.
On Sun, Aug 5, 2018 at 11:41 AM, 'Guy' descormiersg@videotron.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:
Thanks for the fast answer
I put in a matrice the formula
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
but the only thing I get is the name of field (Symbol Company name Period....).
No data
What am I doing wrong !
Very thankful to you
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 12:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Your problem is that you need to format the date for the URL. If you just reference it, you'll get the EXCEL serial date (a numeric value).
You can grab the whole table with:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
...
wrote:
I am tring to extract some data from tmxmoney.com. I need the Est. EPS data. for a specific date. I tried this
RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date="&E11&"market=TSX";7)
where range E11 = the date.
It send me the column name Est. EPS. I want the data under (row under)
I'm not able (and I dont understand how) to put the row number I want.
Maybe there is another way to get those data from the tmxmoney.com Earnings Calendar,
If somebody can help me I would be very thankful.
It is a serial date in E11
I tried 2 ways : One give me only the fields (sheets EPS) and the others #Valeur
Thank you in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 2:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
What do you have in cell E11? It needs to be an EXCEL serial date, not a text string.
On Sun, Aug 5, 2018 at 11:41 AM, 'Guy' descormiersg@videotron.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:
Thanks for the fast answer
I put in a matrice the formula
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
but the only thing I get is the name of field (Symbol Company name Period....).
No data
What am I doing wrong !
Very thankful to you
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 12:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Your problem is that you need to format the date for the URL. If you just reference it, you'll get the EXCEL serial date (a numeric value).
You can grab the whole table with:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
On Sun, Aug 5, 2018 at 8:58 AM, 'Guy' descormiersg@
...
wrote:
I am tring to extract some data from tmxmoney.com. I need the Est. EPS data. for a specific date. I tried this
RCHGetTableCell("https://web.tmxmoney.com/earnings_cal.php?date="&E11&"
where range E11 = the date.
It send me the column name Est. EPS. I want the data under (row under)
I'm not able (and I dont understand how) to put the row number I want.
Maybe there is another way to get those data from the tmxmoney.com Earnings Calendar,
If somebody can help me I would be very thankful.
Attachment(s) from Guy
1 of 1 File(s)
Sun Aug 5, 2018 12:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You're not using the TEXT() function to format the serial date as I
indicated. It worked fine for me when I changed your formula to:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company
Name")
On Sun, Aug 5, 2018 at 12:26 PM, 'Guy' descormiersg@
>
>
> It is a serial date in E11
>
> I tried 2 ways : One give me only the fields (sheets EPS) and the others
> #Valeur
>
> Thank you in advance
>
>
indicated. It worked fine for me when I changed your formula to:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(
Name")
On Sun, Aug 5, 2018 at 12:26 PM, 'Guy' descormiersg@
>
>
> It is a serial date in E11
>
> I tried 2 ways : One give me only the fields (sheets EPS) and the others
> #Valeur
>
> Thank you in advance
>
>
Sun Aug 5, 2018 12:38 pm (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Hi Randy
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
You're not using the TEXT() function to format the serial date as I indicated. It worked fine for me when I changed your formula to:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
On Sun, Aug 5, 2018 at 12:26 PM, 'Guy' descormiersg@
It is a serial date in E11
I tried 2 ways : One give me only the fields (sheets EPS) and the others #Valeur
Thank you in advance
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
You're not using the TEXT() function to format the serial date as I indicated. It worked fine for me when I changed your formula to:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(
On Sun, Aug 5, 2018 at 12:26 PM, 'Guy' descormiersg@
It is a serial date in E11
I tried 2 ways : One give me only the fields (sheets EPS) and the others #Valeur
Thank you in advance
Attachment(s) from Guy
1 of 1 File(s)
Sun Aug 5, 2018 12:43 pm (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Hi Randy
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
You're not using the TEXT() function to format the serial date as I indicated. It worked fine for me when I changed your formula to:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX",">Company Name")
On Sun, Aug 5, 2018 at 12:26 PM, 'Guy' descormiersg@
It is a serial date in E11
I tried 2 ways : One give me only the fields (sheets EPS) and the others #Valeur
Thank you in advance
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
You're not using the TEXT() function to format the serial date as I indicated. It worked fine for me when I changed your formula to:
=RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(
On Sun, Aug 5, 2018 at 12:26 PM, 'Guy' descormiersg@
It is a serial date in E11
I tried 2 ways : One give me only the fields (sheets EPS) and the others #Valeur
Thank you in advance
Attachment(s) from Guy
1 of 1 File(s)
Sun Aug 5, 2018 12:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry. I missed the other worksheet.
That's very strange. If I select your range, hit F2 to edit the formula,
and hit ctrl+shift+enter, it works fine. Without me changing anything in
the formula.
If I use the "evaluate function" process on cell E13, it gives me a #NAME?
error when it tries to use the TEXT() function. That's why #VALEUR? (or,
for me #VALUE?) is being returned for the entire range. I have no idea why
that would occur. Is the function name different for your version of EXCEL?
What do you get in these cells with these formulas:
F11: =TEXT(E11,"YYYY-mm-dd")
G11: ="https://web.tmxmoney.com/earnings_cal.php?date=
"&TEXT(E11,"yyyy-mm-dd")&"&market=TSX"
On Sun, Aug 5, 2018 at 12:38 PM, 'Guy' descormiersg@
>
>
> If you choose sheets EPS(2) you will see that I use exactly your formula
> and the answer is #Valeur.
> Thank you in advance
>
>
That's very strange. If I select your range, hit F2 to edit the formula,
and hit ctrl+shift+enter, it works fine. Without me changing anything in
the formula.
If I use the "evaluate function" process on cell E13, it gives me a #NAME?
error when it tries to use the TEXT() function. That's why #VALEUR? (or,
for me #VALUE?) is being returned for the entire range. I have no idea why
that would occur. Is the function name different for your version of EXCEL?
What do you get in these cells with these formulas:
F11: =TEXT(E11,"YYYY-mm-dd")
G11: ="https://web.tmxmoney.com/earnings_cal.php?date=
"&TEXT(
On Sun, Aug 5, 2018 at 12:38 PM, 'Guy' descormiersg@
>
>
> If you choose sheets EPS(2) you will see that I use exactly your formula
> and the answer is #Valeur.
> Thank you in advance
>
>
Sun Aug 5, 2018 1:05 pm (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Very strange.
In F11 I put =TEXT(E11,"YYYY-mm-dd") and the answer is yyyy-08-dd instead of 2018-08-06
Thanks in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Sorry. I missed the other worksheet.
That's very strange. If I select your range, hit F2 to edit the formula, and hit ctrl+shift+enter, it works fine. Without me changing anything in the formula.
If I use the "evaluate function" process on cell E13, it gives me a #NAME? error when it tries to use the TEXT() function. That's why #VALEUR? (or, for me #VALUE?) is being returned for the entire range. I have no idea why that would occur. Is the function name different for your version of EXCEL?
What do you get in these cells with these formulas:
F11: =TEXT(E11,"YYYY-mm-dd")
G11: ="https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX"
On Sun, Aug 5, 2018 at 12:38 PM, 'Guy' descormiersg@
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
In F11 I put =TEXT(E11,"YYYY-mm-dd") and the answer is yyyy-08-dd instead of 2018-08-06
Thanks in advance
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Sorry. I missed the other worksheet.
That's very strange. If I select your range, hit F2 to edit the formula, and hit ctrl+shift+enter, it works fine. Without me changing anything in the formula.
If I use the "evaluate function" process on cell E13, it gives me a #NAME? error when it tries to use the TEXT() function. That's why #VALEUR? (or, for me #VALUE?) is being returned for the entire range. I have no idea why that would occur. Is the function name different for your version of EXCEL?
What do you get in these cells with these formulas:
F11: =TEXT(E11,"YYYY-mm-dd")
G11: ="https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(
On Sun, Aug 5, 2018 at 12:38 PM, 'Guy' descormiersg@
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
Sun Aug 5, 2018 1:12 pm (PDT) . Posted by:
"Guy" descormiersg@videotron.ca
Hi Randy
I found the problem. It is the "french" problem. Instead of yyyy-mm-dd I put aaaa-mm-jj AND IT WORK
Thank you so much
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Sorry. I missed the other worksheet.
That's very strange. If I select your range, hit F2 to edit the formula, and hit ctrl+shift+enter, it works fine. Without me changing anything in the formula.
If I use the "evaluate function" process on cell E13, it gives me a #NAME? error when it tries to use the TEXT() function. That's why #VALEUR? (or, for me #VALUE?) is being returned for the entire range. I have no idea why that would occur. Is the function name different for your version of EXCEL?
What do you get in these cells with these formulas:
F11: =TEXT(E11,"YYYY-mm-dd")
G11: ="https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(E11,"yyyy-mm-dd")&"&market=TSX"
On Sun, Aug 5, 2018 at 12:38 PM, 'Guy' descormiersg@
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
I found the problem. It is the "french" problem. Instead of yyyy-mm-dd I put aaaa-mm-jj AND IT WORK
Thank you so much
Guy
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Sunday, August 5, 2018 3:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
Sorry. I missed the other worksheet.
That's very strange. If I select your range, hit F2 to edit the formula, and hit ctrl+shift+enter, it works fine. Without me changing anything in the formula.
If I use the "evaluate function" process on cell E13, it gives me a #NAME? error when it tries to use the TEXT() function. That's why #VALEUR? (or, for me #VALUE?) is being returned for the entire range. I have no idea why that would occur. Is the function name different for your version of EXCEL?
What do you get in these cells with these formulas:
F11: =TEXT(E11,"YYYY-mm-dd")
G11: ="https://web.tmxmoney.com/earnings_cal.php?date="&TEXT(
On Sun, Aug 5, 2018 at 12:38 PM, 'Guy' descormiersg@
If you choose sheets EPS(2) you will see that I use exactly your formula and the answer is #Valeur.
Thank you in advance
Sun Aug 5, 2018 1:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Great! Certainly explains why things worked fine here...
On Sun, Aug 5, 2018 at 1:12 PM, 'Guy' descormiersg@
....
wrote:
>
> I found the problem. It is the "french" problem. Instead of yyyy-mm-dd I
> put aaaa-mm-jj AND IT WORK
>
> Thank you so much
>
>
On Sun, Aug 5, 2018 at 1:12 PM, 'Guy' descormiersg@
....
wrote:
>
> I found the problem. It is the "french" problem. Instead of yyyy-mm-dd I
> put aaaa-mm-jj AND IT WORK
>
> Thank you so much
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar