R75 SNB Sight Deposits and CHF Spec Position

Overview

Link to SNBCHF page

In the weekly sight deposits and speculative position we copy data from 3 sources.

• Sight Deposits (from SNB.ch)
• Speculative Position (from graph in post)
• FX Rates (from Investing.com or Financial Times)

Sight Deposit in TablePress

- Click to enlarge

Table Checklist

• Edit the page
• Euro/Swiss Franc FX Cross Rate, October 08 – we change this graph once a week
• Change in SNB Sight Deposits September 2018 – we change this graph once a month

TablePress

• Edit the TablePress at the middle of the page
• First Column Add: Link to the PDF and type the date of the PDF <a href=”http://www.snb.ch/en/mmr/reference/gwd_20160530/source/gwd_201509147.en.pdf”>05 October, 2018</a>
• Second Column Add: Average change of EUR/CHF pair from last week. This can be found in Investing.com. Choose last week as dates.
• Third Column Add: Average change of EUR/USD pair from last week. This can be found in Investing.com. Choose last week as dates.
• Fourth Column Add: Events – George writes about the events
• Fifth Column Add: Net Speculative Position CHF vs USD – This information we took from the existing page, which we are editing at the moment.
• Sixth Column Add: Delta sight deposits if >0 then SNB intervention – this result comes from Total Sight Deposit difference with last week
• Seventh Column Add: Total Sight Deposit – comes directly from PDF
• Eighth Column Add: Sight Deposits @SNB from Swiss banks – comes directly from PDF
• Ninth Column Add: “Other Sight Deposits” @SNB (other than Swiss banks) – Comes directly from PDF

TinyTable

• Top Table in the page – we keep in this table only information about the last 5 weeks: new week added, oldest week deleted (in table)
• Whole Information from TablePress Table should be added in the table at the top of the page
• in this table we have one more column: Net speculative Position EUR vs USD – we take information for this column from Investing.com

TablePress

• Go to tablepress Table, and press edit (see screenshot). Copy first row with tablepress, we will modify this row now.

Edit table press

- Click to enlarge

Sight Deposit

• Go to first column in first line: the DATE
• <a href=”http://www.snb.ch/en/mmr/reference/gwd_20160530/source/gwd_201509147.en.pdf”>June 01, 2016</a>
• Change 20160530 into 20160606 … June 08, 2016 (both 7 days more) and save the table
• Reload the post and click on the link that you just edited
• you open (CHANGING URL by date) http://www.snb.ch/en/mmr/reference/gwd_20170102/source/gwd_201509147.en.pdf or similar URL (See screenshot, upload 6/1/2016)
• Copy the numbers into 3 columns to the right (total, Swiss and other sight deposit

Sight Deposit Info from PDF

- Click to enlarge

New Graph

Input for DataWrapper

Videos about data wrapper:

in the SNB Results videos

Step1: Data Wrapper

Example for this is an old graph in data wrapper with

1. EUR/CHF
2. Sight Deposits and additionally
3. Speculative Position

step2: Snippet

Do the same as in this post about SNB Results.

• Put the data wrapper snippet
• Create featured image which is screenshot of Data Wrapper Graph

Expected Result1: 

EUR/CHF left descending scale

SNB Sight Deposits right rising scale

EUR/CHF left descending scale

CHF speculative Position (Net Speculative CFTC Position CHF against USD)

Old Graph

• Update the Excel and create a new graph
• Create copy in internet archive https://archive.org/web/ and save page NOW https://snbchf.com/snb/history-of-snb-sight-deposits/
• Verify that under archive you have create a new save of our page.
• TablePress: Delete Week 1 to Week3 of previous month in TablePress. Example: September 23, Sept 16, Sept 9. The end of month remains
• Remember also to save the table in Monthly (biweekly)

Monthly Sight Deposit Graph

- Click to enlarge

Speculative Position

• Fixed URL or take it from our graph
• Choose Swiss Franc and Scroll to the right (latest data), see picture “speculative position”
• Copy the “Net non-commercial Position” into the table in column speculative position with “x125”

New Imported CFTC CHF Non-Commercial Net Positions

The old Non-Commercial Net Positions Graph stopped working, thats why we took another one and replace the old one.

CFTC CHF Non-Commercial Net Positions

- Click to enlarge

FX Rates

• EUR/CHF do the same for this and column “avg. EUR/CHF during period”
• Choose last week (from Monday to Friday),–> see picture, and click apply
• Find average rate for the FX pair –> picture “average rate” and put in the table “avg. EUR/USD during period”
• EUR/USD (do the same like EUR/CHF) Go to this
• Send George a message that Table is ready. Headlines? Events?

FX Rates in Sight Deposit

- Click to enlarge

Headlines and Events

• Headlines: Copy from confluence what George writes for sight deposits/ FX (first row) and speculative position (second row), Override text from last week.
• Write events into the tables

Headlines and Events

- Click to enlarge

Excerpt and Date

• Copy the headlines into the excerpt, you can remove the titles (FX, Spec. Pos.)
• Change Post date to today (Monday), 10 am

Update Date

- Click to enlarge

Effort

Time needed:

1h

Done still today: yes

Last Post: today

Improvement, Less Work:

coping new content to our 2 tables

calculating

Only for this feed:

Weekly Sight Deposits and Speculative Position

main change: We have now 3 graphs,

• FX
• Sight Deposits
• Speculative Position

Sight Deposit

Weekly Sight Deposits

(no trello card)

Trello Summary: Empty

Weekly Sight Deposits Page: Date when George has no time

when George has no time, then do not change in Headlines or of the page itself.

Sight Deposits when George has No Time

.

Monday: Weekly Sight Deposits Post

Copy Post

Copy the beginning of this page

Weekly Spec Position without George

Understand the number

Number on 1000 (k)
3 667 => 3.7 k (contracts)

202 => 0.2 k

Short means –

Long means +

Initial Sentence in Swiss Franc

(do not use bold, here only for explanation)

Last data as of July 18:

Case1: Changing Sign: Last Week CHF X < 0 and This Week: Y > 0

The net speculative CHF position has changed (or turned) from X k contracts short to Y k contracts long.

Case2: Changing Sign: Last Week X > 0, this week < 0

The net speculative CHF position has changed (or turned) from X k contracts long to Y k contracts short.

Case 3: Last week and this week < 0:

The net CHF speculative position has risen/fallen from X k short to Y k contracts short (against USD).

Case4: Last week and this week > 0:

The net CHF speculative position has risen/fallen from X k to Y k contracts long (against USD).

Remove text from last week

Move text on Swiss Franc from Chandler into Swiss Franc Chapter

Excerpt

Copy the initial sentence from CHF Chapter and 30-40 words from Chandler text, stop at end sentence.

• Excerpt:

The net speculative CHF position has changed from -0.2K long to 3.7K contracts short (against USD).

Since the beginning of May the Canadian dollar has been the strongest of the major currencies. However, until the most recent CFTC reporting week ending July 18, speculators in the futures market were net short.

Date speculative position

- Click to enlarge

Spec Position

Weekly Spec Position without George

(no trello card)

Trello Summary: Empty

Chandler Speculative Position

Chandler’s speculative position comes on Sunday

I have to correct the posts:
Corrected version:

Old Post: See image
Net and Prior
Net = Gross Long – Gross Short (for this week)
Prior is more complicated, we do not do this exercise
Prior = (Gross Long + Change) – (Gross Short + Change)

• Title: “Weekly Speculative Positions:” then shorten old text a bit
• Manual Editing Box
• add tag: “Speculative Positions”
• add
  next to author box
• Remove all newlines so that the layout is ok. One way is paste pure text (see old text pic), because his bold text is not so helpful
• Create H3 bold Chapters for the currencies, oil and treasuries (5 words main headlines)
• Add chapter for Swiss Franc: Write a text for table values Net (10.9) and Prior (6.4) like “The net speculative position in CHF increased from 6.4k contracts to 10.9k contracts.”
• Table: Verify that the numbers for Net and Prior did not move to left (see correct table attached). Sometimes the table is corrupt. (see corrupt table)
• Table: When the table is corrupt, you must copy the euro row, paste it before, and override the euro row with Nothing, Net , Prior, Gross Long, Change,… then you can delete the corrupt row
• Table: Add two new rows for crude oil and treasuries. If the Table is corrupt you better copy the Mexican Peso and paste it after
• Write the row texts based on text on oil and treasuries. See the screen “Text for Crude Oil into table”
• Make screenshot of table and store it under p cloud –> FX Trends –> Speculative Positions (Saturday) with name “Commitments of Traders” + date in the table
• Set the table image as featured image ALT TEXT= Commitments of Traders July Speculative Position + Date
• Add [OandaSpecPos] and
  and bold “Graphs and additional information on Swiss Franc by the snbchf team.”
• at the end
• italic, bold: Graphs and additional information on Swiss Franc by the snbchf team.

Text for Crude Oil into table

- Click to enlarge

Correct Table

- Click to enlarge

Table Corrupt

- Click to enlarge

Old Version Speculative Position

- Click to enlarge

Weekly Speculative Position and Weekly Review

Chandler uses bold, then you should start a new paragraph.

Bold text - new paragraph

- Click to enlarge

Date of Weekly Spec Position

Problem

CHF Spec Position Same Values

CHF Spec Position Same Values

- Click to enlarge

CHF Spec Position Missing Data

CHF Spec Position Missing Data

- Click to enlarge

Speculative Position CHF (no audio)

Speculative Position Number Format (no audio)