Help
<% -- --------------------------------------------------------- -- %> <% -- Filename: SWEA-help.htm -- %> <% -- --------------------------------------------------------- -- %>
 HELP


Contents
Print   Close
Simple search
Advanced search
Advanced search of interest rates and exchange rates
Monthly average for exchange rates
Annual averages for exchange rates
Cross rates
Presentation format
Help
Series information





Simple search
Back   Print   Close
A simple search can be used to collect observations during a selected period for all available series within an interest rate or exchange rate group. By clicking on a heading in the menu on the left at www.riksbank.com/statistics/interest & exchange rates you can select a group from the time series available. The following menu alternatives and groups lead to Simple search:

Riksbank rates
Swedish market rates
International market rates
Exchange rates
Exchange rates against the Swedish krona
SDR, Special Drawing Right
TCW-index



Use the function Advanced search för att lägga till ytterligare sökvillkor.

Use the function Advanced search of interest rates and exchange rates in the menu on the left to combine interest rate series with exchange rate series.

Instructions


Fill in the required date in the box marked “From”.

This date marks the first date in the selected time period. The grey letters yyyy-mm-dd indicate how the date should be written. Years should be written using four figures, followed by a hyphen, months should be written with two figures followed by a hyphen and then the day with two figures.
For instance "2005-09-01”.

Fill in the required date in the box marked “To”.

This date marks the last date in the selected time period.
For instance “2005-09-25”.

Select whether the result of the search should show daily observations, weekly averages, monthly averages, quarterly averages or annual averages. It is only possible to select one result alternative at a time. The system will automatically select daily observations if no other choice is made.

Please note that when selecting weekly, monthly, quarterly and annual averages, the calculation is only based on whole weeks (Monday-Sunday) and complete time periods.

The selected time period in the example above (2005-09-01 – 2005-09-25) will therefore not show any values in the results if you select monthly, quarterly or annual averages, as neither the month of September, the third quarter nor the year 2005 are complete periods within this time scale.

When weekly, monthly, quarterly or annual average is selected, the display will show not only the average value for the period, but also the lowest listing (Min) and highest listing (Max). When monthly average is selected, the final listing for the month is also shown (Ultimo).

Select the character for the “Decimal separator”.

This indicates how the decimals in the result figures will be separated. When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator. Comma as decimal separator will give “1,5432”. Full stop as decimal separator will give “1.5432”.

Click on “Search” to fetch the data.

The result of a simple search will be displayed in an Excel file. In addition to observations of interest rate or exchange rate series, the Excel file also contains a footnote. The footnote is described in a separate section.

Please note that in the section Frequently Asked Questions in the left-hand menu there are suggestions for measures that can be taken if the search does not show the desired result. 






Advanced search
Back   Print   Close
It is possible to change from simple search to Advanced search. The difference between Advanced search within a group and Simple search is that the advanced search allows you greater options as to how the results should be calculated and presented.
 


Click on the plus sign in the window “Series” to make more time series visible and selectable. It is also possible to select calculation method, various presentation formats and decimal separator with an advanced search.
 
The following menu alternatives and groups are available for Advanced search within a group:
Riksbank rates
Swedish market rates
International market rates
Exchange rates
Exchange rates against the Swedish krona
SDR, Special Drawing Right
TCW-index

Use the function Advanced search of interest rates and exchange rates in the menu on the left to combine interest rate series with exchange rate series.
 
Instructions



Fill in the required date in the box marked “From”.

This date marks the first date in the selected time period. The grey letters yyyy-mm-dd indicate how the date should be written. Years should be written using four figures, followed by a hyphen, months should be written with two figures followed by a hyphen and then the day with two figures.
For instance “2004-01-01”.

Fill in the required date in the box marked “To”.

This date marks the last date in the selected time period.
For instance “2004-12-31”.

Select which series you want included in the search.

The box “Series” displays all available time series within the current group, for instance, “Government Bonds”, as shown in the picture above. A plus sign in front of a group indicates that there are several sub-groups or time series under this heading.

Mark the desired group or series by clicking a tick in the box in front of the group “Government Bonds” (this automatically selects all time series in this group) or by clicking on the individual series. All groups or series marked with a tick will be included in the search.

Click on the tick again to remove selection. This means that the group or time series is no longer included in the search.

The date in brackets beside the series name shows the period during which there are observations for this series. If there is no final date in the brackets, the series is open. This means that it is usually updated with a new listing every day.

Then select “Result per”. This specifies whether the result of the search should be shown per day or grouped per week, per month, per quarter or per year.

The system will automatically select “Day” if no other choice is made. It is only possible to select one result alternative at a time.

“Result per" is linked to the selection made later under the heading “Calculation method”. See further information below.

Please note that when selecting “Week”, “Month”, “Quarter” or “Year”, the calculation only covers whole weeks (Monday-Sunday) or whole months, quarters, and so on. In the time period selected in the picture and the example above (2004-01-01 – 2004-12-31) all of the above selections ("Week", "Month", "Quarter" or "Year") will be available as the time period covers a whole, completed year.

Select “Calculation method”. The calculation method is linked to the selection made above in "Result per" and states whether the result of the search shall be calculated as an "Average value", should show the lowest value for the period (“Min value”), or the highest value ("Max value") or show the last listing for the period ("Ultimo").

For instance, a combination of the selections “Results per week” and “Calculation method Average value” for the time period 2004-01-01 – 2004-12-31 will give a result showing the weekly average for the whole year 2004.

Please note that if results per “Day” are selected, it is not possible to select a “Calculation method”.

Ultimo can only be selected for “Results per Month”.

Select “Presentation”. This indicates the format the results of the search will be presented in. See the description of the various presentation formats under the section Presentation format. The system will automatically select “HTML” if no other choice is made.

Select the sign for the “Decimal separator”.
This indicates how the decimals in the result figures will be separated.
If no other selection is made, the result will be shown with a comma as decimal separator; for instance, “1,5432”. A full stop as decimal separator will give “1.5432”.

When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator.

Click on “Search” to fetch the data.

Please note that in the section Frequently Asked Questions in the left-hand menu there are suggestions for measures that can be taken if the search does not show the desired result.






Advanced search of interest rates and exchange rates
Back   Print   Close
Clicking on the heading Advanced search of interest rates and exchange rates in the left-hand menu at www.riksbank.com/statistics/interest & exchange rates enables you to search observations of all available interest rate and exchange rate series.
 


Click on the plus sign in the window “Series” to make more sub-groups and time series visible and selectable. It is also possible to select calculation method, various presentation formats and decimal separator with a detailed search.
 
Instructions



Fill in the required date in the box marked “From”.

This date marks the first date in the selected time period. The grey letters yyyy-mm-dd indicate how the date should be written. Years should be written using four figures, followed by a hyphen, months should be written with two figures followed by a hyphen and then the day with two figures.
For instance ”2004-01-01”.

Fill in the required date in the box marked “To”.

This date marks the last date in the selected time period.
For instance ”2004-12-31”.

Select which series you want included in the search.

The box entitled “Series” displays all of the available time series, for instance, “Fixing rates” and “AUD” as shown in the picture above. A plus sign in front of a group indicates that there are several sub-groups or time series under this heading.

Mark your selection by clicking a tick in the box in front of either a group or individual series. All groups or series marked with a tick will be included in the search.

Please note that by clicking a tick in a box in front of a group, all related time series will automatically be marked.

Click on the tick again to remove selection. This means that the group or time series is no longer included in the search.

The date in brackets beside the series name shows the period during which there are observations for this series. If there is no final date in the brackets, the series is open. This means that it is usually updated with a new listing every day.

Then select “Result per”. This specifies whether the result of the search should be shown per day or grouped per week, per month, per quarter or per year.

The system will automatically select “Day” if no other choice is made. It is only possible to select one result alternative at a time.

“Result per" is linked to the selection made later under the heading “Calculation method”. See further information below.

Please note that when selecting “Week”, “Month”, “Quarter” or “Year”, the calculation only covers whole weeks (Monday-Sunday) or whole months, quarters, and so on. In the time period selected in the picture and the example above (2004-01-01 – 2004-12-31) all of the above selections ("Week", "Month", "Quarter" or "Year") will be available as the time period covers a whole, completed year.

Select “Calculation method”. The calculation method is linked to the selection made above in "Result per" and states whether the result of the search shall be calculated as an "Average value", should show the lowest value for the ”period (“Min value”), or the highest value ("Max value") or show the last listing for the period ("Ultimo").

For instance, a combination of the selections “Results per week” and “Calculation method Average value” for the time period 2004-01-01 – 2004-12-31 will give a result showing the weekly average for the whole year 2004.
Please note that if results per “Day” are selected, it is not possible to select a “Calculation method”.
Ultimo can only be selected for “Results per Month”.

Select “Presentation”. This indicates the format the results of the search will be presented in. See the description of the various presentation formats under the section Presentation format. The system will automatically select “HTML” if no other choice is made.

Select the sign for the “Decimal separator”.
This indicates how the decimals in the result figures will be separated.
If no other selection is made, the result will be shown with a comma as decimal separator; for instance, “1,5432”. A full stop as decimal separator will give “1.5432”.

When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator.

Click on “Search” to fetch the data.

Please note that in the section Frequently Asked Questions in the left-hand menu there are suggestions for measures that can be taken if the search does not show the desired result.






Monthly average for exchange rates
Back   Print   Close
Clicking on the heading Monthly average for exchange rates in the left-hand menu at www.riksbank.com/statistics/interest & exchange rates makes it possible to access the monthly averages for all available exchange rates during the month of your choice.

Instructions

Fill in the required year in the box marked “Year”.

Years must be written as four figures, see the picture above.

Select the month from the drop-down list by clicking on the downward arrow and marking the desired month, see picture above.

If no other choice is made, the previous month is automatically selected.

Please note that monthly averages are not available until the whole month is complete. For instance, it is not possible to see the average value for October 2005 if the search is carried out on 10 October 2005. The monthly average function for exchange rates does not show accumulated average during a current month.

Select the character for the “Decimal separator”.

This indicates how the decimals in the result figures will be separated. When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator. Comma as decimal separator will give “1,5432”. Full stop as decimal separator will give “1.5432”.

Click on “Search” to fetch the data.

The result will be presented in an Excel file. The file can be saved at a selected location in the user’s own computer environment. The actual format for the file is a tab-separated text file with the file ending (.xls).

The result shows, in addition to the average value for the month (“Average”), the lowest value ("Min"), the highest value ("Max") and the listing for the final banking day of the month ("Ultimo").

Please note that the section Currency codes in the left-hand menu explains all currency abbreviations.






Annual averages for exchange rates
Back   Print   Close
Clicking on the heading Annual averages for exchange rates in the left-hand menu at www.riksbank.com/statistics/interest & exchange rates makes it possible to access the accumulated annual averages for all available exchange rates during the year of your choice.

Instructions

Fill in the required year in the box marked “Year”.

Years must be written as four figures, see the picture above.

If no other choice is made, the previous year is automatically selected.

Please note that the accumulated annual average is not available until a whole month has been completed. For instance, it is not possible to see the average value for the period January to October 2005 if the search is carried out on 10 October 2005. The result will instead be calculated for the period January to September 2005.

Select the character for the “Decimal separator”.

This indicates how the decimals in the result figures will be separated. When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator. Comma as decimal separator will give “1,5432”. Full stop as decimal separator will give “1.5432”.

Click on “Search” to fetch the data.

The result will be presented in an Excel file. The file can be saved at a selected location in the user’s own computer environment. The actual format for the file is a tab-separated text file with the file ending (.xls).

The result shows, in addition to the average value for the period (“Average”), the lowest value ("Min"), the highest value ("Max") and the listing for the final banking day of the period ("Ultimo").
Please note that the section Currency codes in the left-hand menu explains all currency abbreviations.





Cross rates
Back   Print   Close
By clicking on the heading Cross rates in the left-hand menu at www.riksbank.com/statistics/interest & exchange rates, it is possible to calculate the cross rate for the currency pair of your choice.
 


By selecting one or more currency pairs listed against Swedish kronor, the currency pairs’ values will be divided by one another for the purpose of obtaining what is known as a cross rate. It is also possible to select how the result should be grouped and presented.
 
Instructions



Fill in the required date in the box marked “From”.

This date marks the first date in the selected time period. The grey letters yyyy-mm-dd indicate how the date should be written. Years should be written using four figures, followed by a hyphen, months should be written with two figures followed by a hyphen and then the day with two figures. For instance “2005-09-01”.

Fill in the required date in the box marked “To”.

This date marks the last date in the selected time period. For instance “2005-09-30”.

Select which currency pairs you want included in the search.

Click on the down arrow in the drop-down lists under “Currency 1” and “Currency 2” and mark the desired currency, see the picture above. For instance USD in “Currency 1” and EUR in “Currency 2”. There will then be a division calculation between the values for USD and EUR and the result will show how many dollars it costs to buy a euro and vice versa.

Select “Result”.

This will specify whether the result of the search will be shown as daily observations or as weekly, monthly, quarterly or annual averages.

The system will automatically select “Daily listing” if no other choice is made. It is only possible to select one result alternative at a time.

Please note that when selecting weekly, monthly, quarterly or annual averages, the calculation only covers whole weeks (Monday-Sunday) or whole months, quarters, and so on. In the time period selected in the picture and the example above (2005-09-01 – 2005-09-30) only the selections “Daily listing”, “Weekly average” and “Monthly average” are possible as the time period only covers one whole, completed month.

Select “Presentation”.

This indicates the format the results of the search will be presented in. See the description of the various presentation formats under the section Presentation format. The system will automatically select “HTML” if no other choice is made.

Select the character for the “Decimal separator”.

This indicates how the decimals in the result figures will be separated. If no other selection is made, the result will be shown with a comma as decimal separator; for instance, “1,5432”. A full stop as decimal separator will give “1.5432”.

When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator.

Click on “Search” to fetch the data.

Please note that in the section Frequently Asked Questions in the left-hand menu there are suggestions for measures that can be taken if the search does not show the desired result.





Presentation format
Back   Print   Close
HTML
When you have clicked on “Search” the result will be shown in a new window formatted as a table.
 
This page can easily be printed.
 
In addition to observations of interest rate or exchange rate series, the HTML file also contains a footnote. The footnote is described in a separate section.
 
Excel table
The actual format for the file is a tab-separated text file with the file ending (.xls).
 
The file can be saved at a selected location in the user’s own computer environment.
 
The result always shows all selected groups or series during the selected time period, even if the database lacks values for the series.
 
In addition to observations of interest rate or exchange rate series, the Excel table also contains a footnote. The footnote is described in a separate section.
 
Footnote
The footnote shows information on all series included in the search and is attached in the presentation format HTML and Excel table.

The first line of the footnote shows the Riksbank’s designation for the series, for instance SE GVB 2Y. The date in brackets shows the period during which there are observations for this series, for example (1987-01-07 -). If there is no final date in the brackets, the series is open. This means that it is usually updated with a new listing every day.

The second line of the footnote describes the series, for instance government bond with 2-year duration.

The third line states the original source of the series, for example Reuters.
 
CSV file
The CSV file is intended to function as a basis for further analysis of data and the result is in the form of a list.

When you have clicked on “Search" the file should be saved and then opened in Excel. It is also possible to open the file in the text-editing program of your choice.
 
The CSV file has the character set as PC/Windows (ANSI).
 
When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator. However, it is possible to select which combination of decimal and column separator the CSV file should have:
Comma(,) as the decimal symbol gives a semicolon (;) as column separator.
Full stop (.) as the decimal symbol gives a comma (,) as column separator.

Text file
The actual format for the file is a tab-separated text file with the file ending (.xls).
 
The text file is intended to function as a basis for further analysis of data and the result is in the form of a list.
It is possible to select whether the file should be opened in the standard program for files with this file ending (.txt), or whether the file should be saved in the user’s own environment.
 
The text file has the same character set as PC/Windows (ANSI).
 
When the search page opens, it indicates the decimal separator that applies for the computer’s web browser. It is rarely necessary to change the suggested decimal separator. 
 





Help
Back   Print   Close
Clicking on the link Help opens a page in a new window with instructions for using the search function.
 





Series information
Back   Print   Close



Clicking on the link Series information opens a new page showing all available information from the database on the selected group and accompanying series. The date in brackets beside the series name shows the period during which there are observations for this series. If there is no final date in the brackets, the series is open. This means that it is usually updated with a new listing every day.