4 Messages
Digest #4602
Messages
Sat Aug 17, 2019 12:48 pm (PDT) . Posted by:
coffeesandbox
Randy,
Thanks.
Is there an easy way without delving too deep into your macros to add from Yahoo Key Stats (=RCHGetElementNumber(Ticker,941) a few of the same elements to Yahoo Portfolio Stock Quotes ( =smfGetYahooPortfolioView) such as:
- Beta
- Total debt
- Yahoo Enterprise Value
- Profit Margin
- Operating Margin
- Book Value Equity
- Total Cash
A single down and across setup as you now have with YahooPortfolioView with the ability to add a few Yahoo key-stat elements for, say, a 1,000 companies would make it an easy update vs the impossibility of opening a 1,000 key-stat excel pages simply to update and link to few other key excel workbooks.
Excel apparently will not auto-update data stored on a thumb drive unless the file is open.
Thanks.
Is there an easy way without delving too deep into your macros to add from Yahoo Key Stats (=RCHGetElementNumb
- Beta
- Total debt
- Yahoo Enterprise Value
- Profit Margin
- Operating Margin
- Book Value Equity
- Total Cash
A single down and across setup as you now have with YahooPortfolioView with the ability to add a few Yahoo key-stat elements for, say, a 1,000 companies would make it an easy update vs the impossibility of opening a 1,000 key-stat excel pages simply to update and link to few other key excel workbooks.
Excel apparently will not auto-update data stored on a thumb drive unless the file is open.
Sat Aug 17, 2019 1:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, new fields cannot simply be added to
smfGetYahooPortfolioView(). It is retrieving a file from Yahoo and can only
offer the fields that Yahoo has decided to provide through their online
portfolio platform.
On Sat, Aug 17, 2019 at 12:48 PM coffeesandbox@... wrote:
>
> Is there an easy way without delving too deep into your macros to add from
> Yahoo Key Stats (=RCHGetElementNumber(Ticker,941) a few of the same
> elements to Yahoo Portfolio Stock Quotes ( =smfGetYahooPortfolioView) such
> as:
>
> - Beta
> - Total debt
> - Yahoo Enterprise Value
> - Profit Margin
> - Operating Margin
> - Book Value Equity
> - Total Cash
>
> A single down and across setup as you now have with YahooPortfolioView
> with the ability to add a few Yahoo key-stat elements for, say, a 1,000
> companies would make it an easy update vs the impossibility of opening a
> 1,000 key-stat excel pages simply to update and link to few other key excel
> workbooks.
>
> Excel apparently will not auto-update data stored on a thumb drive unless
> the file is open.
>
>
>
smfGetYahooPortfoli
offer the fields that Yahoo has decided to provide through their online
portfolio platform.
On Sat, Aug 17, 2019 at 12:48 PM coffeesandbox@
>
> Is there an easy way without delving too deep into your macros to add from
> Yahoo Key Stats (=RCHGetElementNumb
> elements to Yahoo Portfolio Stock Quotes ( =smfGetYahooPortfol
> as:
>
> - Beta
> - Total debt
> - Yahoo Enterprise Value
> - Profit Margin
> - Operating Margin
> - Book Value Equity
> - Total Cash
>
> A single down and across setup as you now have with YahooPortfolioView
> with the ability to add a few Yahoo key-stat elements for, say, a 1,000
> companies would make it an easy update vs the impossibility of opening a
> 1,000 key-stat excel pages simply to update and link to few other key excel
> workbooks.
>
> Excel apparently will not auto-update data stored on a thumb drive unless
> the file is open.
>
>
>
Sat Aug 17, 2019 3:23 pm (PDT) . Posted by:
descormiersg@videotron.ca
Hi Randy
Since 2 years, I have a file that extract once a week the earning call for
the next week . For that I use
RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXTE(Date
;"aaaa-mm-jj")&"&market=All";">Company Name").
It does not work anymore. I am wonderinf if you know why.
Thanks in advance for your help.
Have a good day
Guy
Since 2 years, I have a file that extract once a week the earning call for
the next week . For that I use
RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXTE(
;"aaaa-
It does not work anymore. I am wonderinf if you know why.
Thanks in advance for your help.
Have a good day
Guy
Sat Aug 17, 2019 4:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The data is no longer delivered within the web page. They build the web
page based on a JSON file retrieved from QuoteMedia, which requires
credentials.
Right now, they are only displaying 10 results per page.
On Sat, Aug 17, 2019 at 3:24 PM descormiersg@... wrote:
>
>
> Since 2 years, I have a file that extract once a week the earning call
> for the next week . For that I use RCHGetHTMLTable("
> https://web.tmxmoney.com/earnings_cal.php?date="&TEXTE(Date;"aaaa-mm-jj")&"&market=All";">Company
> Name").
>
>
>
> It does not work anymore. I am wonderinf if you know why.
>
>
>
page based on a JSON file retrieved from QuoteMedia, which requires
credentials.
Right now, they are only displaying 10 results per page.
On Sat, Aug 17, 2019 at 3:24 PM descormiersg@... wrote:
>
>
> Since 2 years, I have a file that extract once a week the earning call
> for the next week . For that I use RCHGetHTMLTable("
> https://web.tmxmoney.com/earnings_cal.php?date="&TEXTE(
> Name").
>
>
>
> It does not work anymore. I am wonderinf if you know why.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar