Suppose that you do the following trades:
- On Monday 2008-06-23 11AM buy EUR 100,000 at 1.2853
- On Tuesday 2008-06-24 11AM sell EUR 100,000 at 1.2873
Congratulations! You’ve made 20 pips, for a profit of (1.2873-1.2853)*100,000 = $200.
But wait… there is more. The trades above have the following settlements:
- Wednesday 2008-06-25
- Thursday 2008-06-26
That means that while you closed the position on Tuesday 2008-06-24, you still need to roll from Wednesday to Thursday.
The function ssCurrencyRoll(currency,BPSpread ) calculates the rolls, using the appropriate LIBOR curves.
select top 5 *
from dbo.ssCurrencyRoll('EUR', 12.5)
where DateS>'2008-06-19' order by DateS asc
We can see that the bid side of the roll is $9.20 for every 100,000.
Then, the final P&L of the trade described above will actually be $209.20.
The good news is that SAMOA can take care of these steps automatically.
- First, let’s create the book with the function ssBookXml and store it in the table variable @EURUSD_Long_20Pips_TradingBook_Xml (for more information on this function, please read this blog)
declare @EURUSD_Long_20Pips_XmlCalls_Inline table (
Seq bigint IDENTITY(1,1)
,TimeS datetime
,XmlCall nvarchar(max)
);
insert into @EURUSD_Long_20Pips_XmlCalls_Inline (TimeS, XmlCall) VALUES
('2008-06-23 11:00', '<Trade TimeS="2008-06-23 11:00" Instrument="EUR" Q="100000" P="1.2853" Comment="Open" />' ),
('2008-06-23', '<Mark DateS="2008-06-23" Instrument="EUR" P="1.3" />' ),
(’2008-06-24 11:00', '<Trade TimeS="2008-06-24 11:00" Instrument="EUR" Q="-100000" P="1.2873" Comment="Close" />' ),
('2008-06-24', '<Mark DateS="2008-06-24" Instrument="EUR" P="1.28" />' ),
('2008-06-25', '<Mark DateS="2008-06-25" Instrument="EUR" P="1.28" />' );
----SQLTable: EURUSD_Long_20Pips_XmlCalls----
declare @EURUSD_Long_20Pips_XmlCalls table (
[Seq] bigint
,[XmlCall] nvarchar(1024)
);
insert into @EURUSD_Long_20Pips_XmlCalls
select * from dbo.ssXmlCalls(
(select TS.* from @EURUSD_Long_20Pips_XmlCalls_Inline TS FOR XML AUTO, xmlschema('type'), root ('ROOT'), TYPE),
NULL,NULL,NULL,NULL
);
declare @EURUSD_Long_20Pips_TradingBook_Xml xml;
select @EURUSD_Long_20Pips_TradingBook_Xml = dbo.ssBookXml(
(select TS.* from @EURUSD_Long_20Pips_XmlCalls TS FOR XML AUTO, xmlschema('type'), root ('ROOT'), TYPE)
);
Select @EURUSD_Long_20Pips_TradingBook_Xml as ScalarVariable;
- Now let’s query the final P&L:
select
MarkMonth.value('@DateS', 'datetime') as DateS,
MarkMonth.value('@AccPL', 'decimal(38,10)') as AccPL
from @EURUSD_Long_20Pips_TradingBook_Xml.nodes('/Book/MarkMonth') MarkMonths(MarkMonth)
We can wee that the P&L is correct, because the roll was added automatically.
-
If we list the income streams we’ll see the roll:
select
Income.value('@Seq', 'bigint') as [Seq],
Income.value('@DateS', 'datetime') as DateS,
Income.value('@Amount', 'decimal(38,10)') as Amount,
Income.value('@Comment', 'nvarchar(100)') as Comment
from @EURUSD_Long_20Pips_TradingBook_Xml.nodes('/Book/MarkMonth/MarkDay/Income') Incomes(Income);
Full Movie Downloads…
[...]here are some links to sites that we link to because we think they are worth visiting[...]…
Free Movie Downloads…
[...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…
Download Full Movies…
[...]below you’ll find the link to some sites that we think you should visit[...]…
Earthquake in Japan, or was it a tsunami?!…
[...]Earthquakes happend very often these days, but do they resolve in a tsunami?[...]…
Friday the day got shrinked with 1 minisecond?!…
[...]Can you speed up time? In Japan it recently happend with 1 nanosecond![...]…
Like girls more then you should?!…
[...]Don’t bother that you are having this. This is natural. Just like any other guy you are having this[...]…
Why do you want to buy this stuff?!…
[...]Buy an iphone for more then 600 dollars, you are crazy! check it here why[...]…
Pregnancy Periods informations…
[...]the time for you to study or go to the content or web sites we’ve connected to below the[...]…
casino en ligne…
[...] Anyone who tells you differently is a blatent liar. [...]…
Looking forward to move into another hous?!…
[...]Real estate busines is getting more and more less protitable, check out why[...]…
Looking forward to move into another hous?!…
[...]Real estate busines is getting more and more less protitable, check out why[...]…
Stay infroaimtve, San Diego, yeah boy!
kXjyDM ymmsylpjobdw
2YSvsc , [url=http://uesutrwjtmry.com/]uesutrwjtmry[/url], [link=http://dibqlgncmmcs.com/]dibqlgncmmcs[/link], http://mqwjgrridbnu.com/
IrncT6 mbzsruipqkoi
Zpphnq , [url=http://vkpukytloxgb.com/]vkpukytloxgb[/url], [link=http://suczhasobcrw.com/]suczhasobcrw[/link], http://jlqeblrfxhqz.com/
Recommended websites……
[...]take time to read or check out the content of these sites we have linked to below[...]……
2012 Fashion ideas22…
If at first you don’t succeed, find out if the loser gets anything….
Friday the day got shrinked with 1 minisecond?…
[...]Can you speed up time? In Japan it recently happend with 1 nanosecond[...]…
2012 Fashion ideas h…
Coming home from very lonely places, all of us go a little mad: whether from great personal success, or just an all-night drive, we are the sole survivors of a world no one else has ever seen….
Sites You Should Check Out…
http://www.jagkitchens.getlisted.co.nz/nz-kitchen...
Sites You Should Check Out…
http://www.rotarydirect.getlisted.co.nz/rx7-rx...
Yesturdays Arbeit für Morgen – ein Blick auf einige Beispiele…
Beachtet dieses Beispiel, über gezeigt jon McCormick an Phasenjournal und glauben Sie ihm vor um zu sein extrem informativ und auch der Punkt…
Sites You Should Check Out…
http://www.jucy.getlisted.co.nz/hire-a-car-auckland...
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
Angry Birds Online…
[...]listed below are some listings to web sites which I connect to since we think they will be worthy of checking out[...]…
Sites You Should Check Out…
http://www.myhuntingnews.com...
Sites You Should Check Out…
http://www.melrosevillage.getlisted.co.nz/rest-homes-tauranga...
Entry Level Mechanical Engineering Jobs…
Entry Level Mechanical Engineering Jobs…
Het werk van Yesturdays voor morgen – een blik op sommige voorbeelden…
Opgemerkt dit voorbeeld, via jon halign Leef Dagboek en geloof het om te zijn enigszins informatief en ook het punt…
Sites You Should Check Out…
http://www.shoppingcashsaver.com/which-kitchenaid-mixer...
Sites You Should Check Out…
http://www.hyspecs.getlisted.co.nz/pumps...
Funny article…
Really interesting post…
Sites You Should Check Out…
http://www.pentlands.getlisted.co.nz/auckland-accommodation...
How to Do Seo…
Hi, just wanted to mention, I liked this blog post. It was practical. Keep on posting!…
Enjoyed every bit of it…
I should say, as a lot as I enjoyed reading what you had to say, I couldnt support but lose interest following a although….
tramadol xr bluelight…
This is interesting, post more often! I do have a couple of questions though, will think more in depth…
Sites You Should Check Out…
http://www.exhibitgroup.getlisted.co.nz/...
Sites You Should Check Out…
http://www.lighthouse.getlisted.co.nz...
Sites You Should Check Out…
http://www.techrentals.getlisted.co.nz/equipment-rental...
… [Trackback]…
[...] Read More here: nestorsulikowski.com/index.php/2009/05/currency-rolls/ [...]…
Lavoro per il domani – uno sguardo di Yesturdays ad alcuni esempi…
È stato indicato questo esempio, via Megan McCormick sopra Facebook e immaginilo per essere piuttosto informativo ed ugualmente il punto…
Just keep looking…
this blog appears not to be so well maintained these days but I like the post…
Sites You Should Check Out…
http://www.eurotec.getlisted.co.nz/ice-machine-maker...
Sites You Should Check Out…
http://www.greenvalleylodge.getlisted.co.nz/rest-homes...
Solar Lights…
[...]the pursuing are several references to places which we connect to seeing as we think they are worthy of checking out[...]…
Sites You Should Check Out…
http://www.aucklandforktruckhire.getlisted.co.nz/forklift-hire-auckland...
No Deposit Poker…
hi!,I love your writing so a lot! percentage we keep up a correspondence more about your post on AOL? I require a specialist in this area to resolve my problem. Maybe that’s you! Taking a look forward to look you….
Best articles…
[..] More info about this article creator Click Here [..]…
Websites You Should Visit…
[...]very few websites that happen to be detailed below, from our point of view are undoubtedly well worth checking out[...]…
Travail de Yesturdays pour le demain – un regard à quelques exemples…
Noté cet exemple, par l’intermédiaire de David hardvalder dessus Twitter et croyez-le pour être légèrement instructif et trop le point…
yahoo answer service provider…
Answers provider with url…
Articles…
[..] More info Here [..]…
Adult Cloud Tube…
The hottest adult tube site available on the whole internet. Check it out!…
More info…
[..] More info here [..]…
Travail de Yesturdays pour le demain – un regard à quelques exemples…
A été montré cet exemple, par l’intermédiaire de David halign dessus Twitter et croyez-le pour être extrêmement instructif et trop le point…
Great information…
This is certainly amazing. Our company looked at the promise in it therefore we are confused. We are precisely curious about this sort of features. Among appreciate dieters recommend, and worth the effort with this. Please keep cutting. They’re astoni…
pizdy…
Tutaj znajdziesz stosunek seksualny bezplatnie….
… [Trackback]…
Thanks for sharing Sun Damaged to “Sun Virgin”! with us keep update bro love your article about Sun Damaged to “Sun Virgin”! ….
Great information…
This is certainly magnificent. An looked at this finding ease therefore we are surprised. We are attracted to one of these parts. Solitary appreciate one’s recommendations, and value your precious time inside this. Please keep add relevant content. Th…
Great information…
This is marvelous. Experts looked at that particular composition when we are startled. We are fascinated by this type of points. Our team appreciate domestic tape, and charge your precious time in this. Please keep cutting. They are amazingly necessary…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
[...]Here are some of the sites we recommend for our visitors[...]……
………..
My partner and i suppose for the time being i am going to accept book-marking and also incorporating your Feed in order to my Yahoo bank account. My spouse and i enjoy new changes and will share this specific site together with our Fb group….
Great information…
This is often extraordinary. Tip looked at that particular blog posts when we are surprised. We’re interested in one of these circumstances. Both of us appreciate all the memo, and number your time inside this. Please keep updating. They are tremendou…
No Deposit Poker…
I have fun with, result in I found exactly what I used to be taking a look for. You have ended my four day long hunt! God Bless you man. Have a great day. Bye…
Travail de Yesturdays pour le demain – un regard à quelques exemples…
Juste noté cet exemple, par l’intermédiaire de arnold McCormick dessus Journal de phase et imaginez-le pour être extrêmement instructif et trop le point…
My opinion is ……
woh I your blog posts, saved to favorites ! ….
………..
I suppose for the time being i will settle for bookmarking and introducing the RSS feed to be able to my own Yahoo bank account. I anticipate brand new changes and will share this particular blog together with my own Facebook or myspace group….
My opinion is ……
I simply wished to say thanks yet again. I’m not certain what I might have implemented without the type of tricks shared by you over such field. Previously it was a fearsome circumstance in m…
Great information…
This can be extraordinary. Many people checked out a legal case amount therefore we are bowled over. We are precisely interested in this kind of options. United states appreciate yer collect, and evaluate your precious time inside this. Please keep enh…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Viagra…
I saw this really great post today….
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
[...]Here are some of the sites we recommend for our visitors[...]……
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
[...]Here are some of the sites we recommend for our visitors[...]……
cialis…
you are number 1 site for information…
… [Trackback]…
[...] Find More Informations here: nestorsulikowski.com/index.php/2009/05/currency-rolls/ [...]…
cialis…
grest information…
Great information…
This is certainly extraordinary. We stare upon those video content when we are confounded. We are precisely interested in this sort of activities. Type appreciate his collect, and prize doing in this. Please keep enhancing. They’re completely advantag…
levitra…
check it out you will love it…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Alprazolam…
Alprazolam still has dangerous side effects, even when using the recommended dosage….
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
cialis online…
Wide variety of generic and brand CIALIS packages. BEST quality generic CIALIS with 100% satisfaction guaranteed!…
[...]The information mentioned in the article are some of the best available [...]……
[...]below you’ll find the link to some sites that we think you should visit[...]……
order xanax…
Find patient medical information for Xanax Oral on WebMD including its uses, side effects and safety, interactions, pictures, warnings and user ratings….
buy xanax online…
Xanax (alprazolam) is a benzodiazepine used to treat anxiety and panic disorder. Includes Xanax side effects, interactions and indications….
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……