6 Messages
Digest #4488
3b
Re: What is the VBA Function to Refresh all SMF Formulas in a Workbo by "Randy Harmelink" rharmelink
Messages
Sat Feb 23, 2019 10:40 am (PST) . Posted by:
"Rhonda Federman" rhonda.federman@gmail.com
Thanks, Randy.
I am looking for the information on a ticker by ticker basis. I was hoping
for an easier solution but I can just do the calculations myself.
Rhonda Federman
2522 <%28973%29%20992-2522>
(201) 341-9123
rhonda.federman@gmail.com
On Fri, Feb 22, 2019 at 2:08 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The best method depends entirely on what you're trying to do. If you're
> doing some sort of screening, I would suggest just using BarChart's stock
> screener and exporting the results.
>
> If you want the data on a ticker by ticker basis for a number of stocks,
> it's going to be a lot of processing to get the data, since I'm not aware
> of a source that has all of those data items on a single page that is
> available to the add-in.
>
> On Fri, Feb 22, 2019 at 11:21 AM Rhonda Federman rhonda.federman@...
> wrote:
>
>>
>> Is it possible to pull the data into smfGetYahooPortfolioView that used
>> to be available on smfGetBarchartPortfolioView? Specifically,
>> - 5 year dividend growth rate
>> - 5 year earnings growth rate
>> - relative strength 14 day
>> - industry
>>
>> Or is there another way to pull this data into Excel?
>>
>>
>
I am looking for the information on a ticker by ticker basis. I was hoping
for an easier solution but I can just do the calculations myself.
Rhonda Federman
2522 <%28973%29%20992-2522>
(201) 341-9123
rhonda.federman@gmail.com
On Fri, Feb 22, 2019 at 2:08 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The best method depends entirely on what you're trying to do. If you're
> doing some sort of screening, I would suggest just using BarChart'
> screener and exporting the results.
>
> If you want the data on a ticker by ticker basis for a number of stocks,
> it's going to be a lot of processing to get the data, since I'm not aware
> of a source that has all of those data items on a single page that is
> available to the add-in.
>
> On Fri, Feb 22, 2019 at 11:21 AM Rhonda Federman rhonda.federman@
> wrote:
>
>>
>> Is it possible to pull the data into smfGetYahooPortfoli
>> to be available on smfGetBarchartPortf
>> - 5 year dividend growth rate
>> - 5 year earnings growth rate
>> - relative strength 14 day
>> - industry
>>
>> Or is there another way to pull this data into Excel?
>>
>>
>
Sat Feb 23, 2019 12:04 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
If it's for a fixed set of tickers, you could create a portfolio on
BarChart and then export the portfolio with a view that contains those
items.
Symbol Name Industry Last 14D Rel Str 5Y Earn% 5Y Div%
ABT Abbott Laboratories Medical Products 76.13 64.37% 43.28% -96.81%
ADM Archer Daniels Midland Company Agriculture Operations 42.49 47.27%
50.21% 76.32%
BP BP Plc Oil - International Integrated 42.46 60.44% -10.80% 10.05%
But a free account only gets 5 downloads per day. And I think a limit on
the number of ticker symbols?
On Sat, Feb 23, 2019 at 11:40 AM Rhonda Federman rhonda.federman@... wrote:
>
> I am looking for the information on a ticker by ticker basis. I was hoping
> for an easier solution but I can just do the calculations myself.
>
>
>
>
BarChart and then export the portfolio with a view that contains those
items.
Symbol Name Industry Last 14D Rel Str 5Y Earn% 5Y Div%
ABT Abbott Laboratories Medical Products 76.13 64.37% 43.28% -96.81%
ADM Archer Daniels Midland Company Agriculture Operations 42.49 47.27%
50.21% 76.32%
BP BP Plc Oil - International Integrated 42.46 60.44% -10.80% 10.05%
But a free account only gets 5 downloads per day. And I think a limit on
the number of ticker symbols?
On Sat, Feb 23, 2019 at 11:40 AM Rhonda Federman rhonda.federman@
>
> I am looking for the information on a ticker by ticker basis. I was hoping
> for an easier solution but I can just do the calculations myself.
>
>
>
>
Sat Feb 23, 2019 1:16 pm (PST) . Posted by:
"Rhonda Federman" rhonda.federman@gmail.com
Yes, you are right, Barchart limits you to 5. Even a paid account is
limited to 100. I can access some of this information from a very handy
chart updated monthly. The RSI is easy enough to calculate.
http://www.dripinvesting.org/Tools/Tools.asp
Rhonda Federman
On Sat, Feb 23, 2019 at 3:04 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> If it's for a fixed set of tickers, you could create a portfolio on
> BarChart and then export the portfolio with a view that contains those
> items.
>
> Symbol Name Industry Last 14D Rel Str 5Y Earn% 5Y Div%
> ABT Abbott Laboratories Medical Products 76.13 64.37% 43.28% -96.81%
> ADM Archer Daniels Midland Company Agriculture Operations 42.49 47.27%
> 50.21% 76.32%
> BP BP Plc Oil - International Integrated 42.46 60.44% -10.80% 10.05%
>
> But a free account only gets 5 downloads per day. And I think a limit on
> the number of ticker symbols?
>
>
>
> On Sat, Feb 23, 2019 at 11:40 AM Rhonda Federman rhonda.federman@...
> wrote:
>
>>
>> I am looking for the information on a ticker by ticker basis. I was
>> hoping for an easier solution but I can just do the calculations myself.
>>
>>
>>
>>
>
limited to 100. I can access some of this information from a very handy
chart updated monthly. The RSI is easy enough to calculate.
http://www.dripinvesting.org/Tools/Tools.asp
Rhonda Federman
On Sat, Feb 23, 2019 at 3:04 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> If it's for a fixed set of tickers, you could create a portfolio on
> BarChart and then export the portfolio with a view that contains those
> items.
>
> Symbol Name Industry Last 14D Rel Str 5Y Earn% 5Y Div%
> ABT Abbott Laboratories Medical Products 76.13 64.37% 43.28% -96.81%
> ADM Archer Daniels Midland Company Agriculture Operations 42.49 47.27%
> 50.21% 76.32%
> BP BP Plc Oil - International Integrated 42.46 60.44% -10.80% 10.05%
>
> But a free account only gets 5 downloads per day. And I think a limit on
> the number of ticker symbols?
>
>
>
> On Sat, Feb 23, 2019 at 11:40 AM Rhonda Federman rhonda.federman@
> wrote:
>
>>
>> I am looking for the information on a ticker by ticker basis. I was
>> hoping for an easier solution but I can just do the calculations myself.
>>
>>
>>
>>
>
Sat Feb 23, 2019 1:03 pm (PST) . Posted by:
gz_cp
What is the VBA function to refresh all SMF formulas in a workbook (so that they reflect the latest values of webpages)?
Is it a simple Application.
Thanks.
Sat Feb 23, 2019 1:57 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to run the smfForceRecalculation macro.
On Sat, Feb 23, 2019 at 2:03 PM gz_cp@... wrote:
> What is the VBA function to refresh all SMF formulas in a workbook (so
> that they reflect the latest values of webpages)?
>
> Is it a simple Application.Calculate, or something more complicated like
> clearing cache etc?
>
>
>
On Sat, Feb 23, 2019 at 2:03 PM gz_cp@... wrote:
> What is the VBA function to refresh all SMF formulas in a workbook (so
> that they reflect the latest values of webpages)?
>
> Is it a simple Application.
> clearing cache etc?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar