Table for data releases

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

GFXFTS
Posts: 42
Joined: Wed Nov 21, 2018 10:33 am

Table for data releases

Postby GFXFTS » Tue Mar 30, 2021 1:38 am

Hello,

Hope all well.

Is it in theory possible to replicate the attached screenshot of a Bloomberg data release in Eviews as a table? I have also attached the .prg and .wf for the underlying data.

Would be great if you could point me in the right direction.

Thanks a lot.

Best wishes,

Günter
Attachments
BBG Data Calendar.PNG
BBG Data Calendar.PNG (17.23 KiB) Viewed 3355 times
usd_cpi_report.wf1
(49.78 KiB) Downloaded 148 times
usd_cpi_report.prg
(706 Bytes) Downloaded 177 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: Table for data releases

Postby EViews Gareth » Tue Mar 30, 2021 7:20 am

Not sure I understand the question.

Are the data contained in that table available in the series you have in the workfile?
Follow us on Twitter @IHSEViews

GFXFTS
Posts: 42
Joined: Wed Nov 21, 2018 10:33 am

Re: Table for data releases

Postby GFXFTS » Wed Mar 31, 2021 3:33 am

Hi Gareth,

The raw data is in the workfile.

So for the first row for example the data is

cpi_chng series US CPI Urban Consumers MoM SA for "Actual"
cpi_chng_bn_survey_median series US CPI Urban Consumers MoM SA for "Surv(M)"
cpi_chng series LAG minus 1 US CPI Urban Consumers MoM SA for "Actual" for "Prior"
cpi_chng_first_revision series US CPI Urban Consumers MoM SA for "Revised"

I have created a group for the series above with a sample range for February 2021.

I don't know yet how to create a similar table as in the screenshot for row one for example.

Thanks a lot for your help.

Best wishes,

Günter
Attachments
usd_cpi_report.wf1
(50.53 KiB) Downloaded 154 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: Table for data releases

Postby EViews Gareth » Wed Mar 31, 2021 5:59 am

ok, got it.

Not easy.

There's two ways I can think of. One would be to stack the data in a new page with each group being a row on the new page. This is complex.

The other way is to manually create a table object and copy the data into the cells of the table one by one. Something like:

Code: Select all

table mytable
mytable(1,1) = "CPI MoM"
freeze(tmp) cpi_mom.sheet
tmp.copyrange b3 e3 mytable b1
d tmp
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 30 guests