Export specific day

[eirini]

Hello,

i have daily 5day -week prices for my variables. Is there any way to export only the prices for wednesdays beacuse i need to work only with them ?

Thank you!!

[EViews Gareth]

Export to what?

[eirini]

By sayng exprot i mean that I want to create another variable which will contain only the prices for Wednesdays.

[EViews Gareth]

You have a 5 day daily page. You want to create a new series in that same page that only has data on Wednesdays (the other days are NA)?

If so:

Code: Select all

smpl if @weekday = 3 series newseries = x

where X is the name of the original series.

[eirini]

My target is to take from the initial series which is daily(5 day week) the prices for wednesdays in order to calculate the returns betteen them. More specific i have 5 day prices for financial indexes and i want to calculate the returns from Wednesday to Wednesday.

[EViews Gareth]

Isn't that exactly what you asked (and received a reply to) here:
http://forums.eviews.com/viewtopic.php? ... 362#p47362

[eirini]

I followed these steps but when i did the special copy i cannot use the option "Frequency coneversion options". it is not highlighted.

[EViews Gareth]

Are you sure you created a new weekly page properly?

http://www.eviews.com/Learning/freqconv_a.html

[eirini]

I followed these steps but when i choose below the choice "Merge by" the choice "Date" the selection " Frequency conversion options" is not highlighted. Even when i choose the choice " General match merge criteria" at the right comes up "Match merge options" with the options that you can see in the image that i attached to you. I choose then " Contaction method" the option last but as a weekly page i get the initial daily page.

Capture.PNG (12.76 KiB) Viewed 10803 times

[EViews Gareth]

Post your workfile with both the daily and weekly pages.

[eirini]

untitled1.WF1

(251.42 KiB) Downloaded 386 times

[EViews Gareth]

Your weekly page is not weekly. It is daily.

[eirini]

This is my issue...i cannot create it....what am i doing wrong?

[EViews Gareth]

Click on the New Page tab, select Specify by Frequency/Range..., then change the frequency to be weekly.

[eirini]

I followed exactly what you proposed me to do but i noticed that in my new weekly page although the prices are for Wednesdays the dates are not right. More specific for example the price for 1/10/1997 now has a different date which is 4 days earlier, in my example becomes 1/04/1997. I noticed also that changing the start date each time the new weekly page that is created has prices for different days each time. For example when i choose as a start date 1/1/1980(tuesday) then the weekly page contains all the prices for Mondays, but when i choose as a start date 1/2/1980 then the weekly page contains all the prices for Tuesdays and when i choose as a start date 1/3/1980(tuesday) then the weekly page contains all the prices for Wednesdays. In three cases the prices are not follow the right date. What am i missing?
Thank you a lot!!