Bloomberg data download with special tickers

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

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

Bloomberg data download with special tickers

Postby GFXFTS » Thu Feb 18, 2021 1:24 pm

Hello,

Hope all well.

For some reason, Eviews doesn't pull the already available February data via the attached .prg into the attached .wf. To check if the data is available I downloaded the data also into Excel and got this:

Start Date 18.01.2021
End Date 18.01.2022

MPMIDEMA Index
#N/A Requesting Data...
Dates BN_SURVEY_MEDIAN
31.01.2021 57
28.02.2021 56.5


Thanks a lot for your help.

Best,

Günter
Attachments
Test_BBG_Survey.wf1
(13.59 KiB) Downloaded 181 times
test_bbg_survey.prg
(129 Bytes) Downloaded 220 times

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Bloomberg data download with special tickers

Postby EViews Jason » Thu Feb 18, 2021 2:56 pm

Unfortunately, we do currently do not have access to Bloomberg. We are working on re-obtaining access but in the meantime we cannot tell internally what exactly is occurring.

Until we do get access, can you modify your program to create a daily workfile and then attempt to fetch the series. If you see values for the beginning of February 2021, I suspect the series is being brought in as a daily and then due the frequency conversion method, the month of February is converted to NA.

Assuming the above is true, try specifying a conversion method in the fetch command that ignores NAs. For example,

Code: Select all

fetch(d=bbg,link, c=a) "mpmidema index"  "mpmidema Index BN_SURVEY_MEDIAN"


More information on setting the conversion method can be found here http://www.eviews.com/help/helpintro.html#page/content/commandcmd-fetch.html

javiersan
Posts: 184
Joined: Mon Jan 19, 2009 8:18 am

Re: Bloomberg data download with special tickers

Postby javiersan » Tue Feb 23, 2021 5:55 am

That works.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 14 guests