[smf_addin] Digest Number 4643

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4643

1a

getyahooportfolioview issue by thadmalley

1b

Re: getyahooportfolioview issue by "Randy Harmelink" rharmelink

2a

Net Worth Non Financial Corp Business from FRED by waterboy5555

2b

Re: Net Worth Non Financial Corp Business from FRED by "Randy Harmelink" rharmelink

Messages

1a

getyahooportfolioview issue

Fri Nov 8, 2019 7:28 am (PST) . Posted by:

thadmalley

For some reason, if I have a list of say 20 to 30 stocks, using the array for both the name and the price of each stock, at some point, not only do I get errors both in price and name for all entries above the current stock. All the formulas are the same for every point above the array, which is weird.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: getyahooportfolioview issue

Fri Nov 8, 2019 10:50 am (PST) . Posted by:

"Randy Harmelink" rharmelink

In the past, the culprit has usually been a delisted stock. Sometimes,
Yahoo returns all the other data fine. But other times, it just stops and
returns whatever it has.

On Fri, Nov 8, 2019 at 8:39 AM cooler_king@... wrote:

> For some reason, if I have a list of say 20 to 30 stocks, using the array
> for both the name and the price of each stock, at some point, not only do I
> get errors both in price and name for all entries above the current stock.
> All the formulas are the same for every point above the array, which is
> weird.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Net Worth Non Financial Corp Business from FRED

Fri Nov 8, 2019 11:00 am (PST) . Posted by:

waterboy5555

Hi,


Can someone please help me with pulling data from the st louis fred. I'd like a formula for the total net worth non financial corporate business from the following link:


https://fred.stlouisfed.org/series/TNWMVBSNNCB#0 https://fred.stlouisfed.org/series/TNWMVBSNNCB#0



Thanks in advance.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Net Worth Non Financial Corp Business from FRED

Fri Nov 8, 2019 11:22 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Just grab the CSV file:

Put this is cell D4:

https://fred.stlouisfed.org/graph/fredgraph.csv?bgcolor=#e1e9f0&chart_type=line&drp=0&fo=open
sans&graph_bgcolor=#ffffff&height=450&mode=fred&recession_bars=on&txtcolor=#444444&ts=12&tts=12&width=1168&nt=0&thu=0&trc=0&show_legend=yes&show_axis_titles=yes&show_tooltip=yes&id=TNWMVBSNNCB&scale=left&cosd=1945-10-01&coed=2019-04-01&line_color=#4572a7&link_values=false&line_style=solid&mark_type=none&mw=3&lw=2&ost=-99999&oet=99999&mma=0&fml=a&fq=Quarterly,
End of
Period&fam=avg&fgst=lin&fgsnd=2009-06-01&line_index=1&transformation=lin&vintage_date=2019-11-08&revision_date=2019-11-08&nd=1945-10-01

And then array-enter this over a range:

=smfGetCSVFile(D4)

On Fri, Nov 8, 2019 at 12:02 PM bopha99@... wrote:

> Can someone please help me with pulling data from the st louis fred. I'd
> like a formula for the total net worth non financial corporate business
> from the following link:
>
> https://fred.stlouisfed.org/series/TNWMVBSNNCB#0
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use