Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
Hello! I have a thing that I want to do but I do not know if this is possible. I have a spreadsheet on a Blommberg PC that has Excel. I download prespecified data from Bloomberg to the spreadsheet at a certain time once every day. The data that I am dowloadning to the spreadsheet is different ratings for different banks. Now I want to send out an email (automatically) if a rating has changed. In this email I want to show: 1) what bank has a new rating 2) what the old rating was 3) what the new rating is I use the DDE to connect Bloomberg to the spreadsheet and this works fine. Now what I do not know is how (if possible) you send out en email if any rating has changed. Is this best done from Excel or Bloomberg? Any assistance is very much appreciated. I can post some more detalied info concerning this at request. Thank you very much for your time. -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
How much money you going to pay me for the code to do this? =) Good
luck with that one btw...I'm sure someone out there will be able to come up with some extremely long VBA code to get that to work... freddie mac wrote: Hello! I have a thing that I want to do but I do not know if this is possible. I have a spreadsheet on a Blommberg PC that has Excel. I download prespecified data from Bloomberg to the spreadsheet at a certain time once every day. The data that I am dowloadning to the spreadsheet is different ratings for different banks. Now I want to send out an email (automatically) if a rating has changed. In this email I want to show: 1) what bank has a new rating 2) what the old rating was 3) what the new rating is I use the DDE to connect Bloomberg to the spreadsheet and this works fine. Now what I do not know is how (if possible) you send out en email if any rating has changed. Is this best done from Excel or Bloomberg? Any assistance is very much appreciated. I can post some more detalied info concerning this at request. Thank you very much for your time. -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
I do not mean to sound rude but I am not going "pay" you anything no was I asking for a complete code. If my message gave that impression apologize. I was merely asking if anyone knew how to solve it on conceptual level -- freddie ma ----------------------------------------------------------------------- freddie mac's Profile: http://www.excelforum.com/member.php...fo&userid=3610 View this thread: http://www.excelforum.com/showthread.php?threadid=56057 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
If you have the data in Excel, it should be easy enough to trigger an email
from the WS_change event. See http://www.rondebruin.nl/mail/add-in.htm for sending a WB. If you only want to send the text see http://www.vb-helper.com/howto_shell_mail.html You would have continually save the "old" values somewhere, so could include the old rating, possibly just in an array. I have no idea what Bloomberg offers in its package, but as someone else advised recently, contact their help desk and ask. NickHK "freddie mac" wrote in message ... Hello! I have a thing that I want to do but I do not know if this is possible. I have a spreadsheet on a Blommberg PC that has Excel. I download prespecified data from Bloomberg to the spreadsheet at a certain time once every day. The data that I am dowloadning to the spreadsheet is different ratings for different banks. Now I want to send out an email (automatically) if a rating has changed. In this email I want to show: 1) what bank has a new rating 2) what the old rating was 3) what the new rating is I use the DDE to connect Bloomberg to the spreadsheet and this works fine. Now what I do not know is how (if possible) you send out en email if any rating has changed. Is this best done from Excel or Bloomberg? Any assistance is very much appreciated. I can post some more detalied info concerning this at request. Thank you very much for your time. -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
Thank you very much Nick! That was what I was looking for! Regards, Freddie -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
Freddie Mac eh? At least you're not calling yourself Fannie Mae...
Anyhow, your firm will be paying about $1500 per bloomberg per month, so get onto their helpdesk and ask them to help you. Here are a few things to beware of: 1. You are not allowed to distribute Bloomberg data to PCs that do not have a full Bloomberg license installed. 2. You will need to keep the "old" rating and the new rating. 3. Which rating are you interested in? Moody, S&P, Fitch? 4. Best place to do this is in Excel 5. Best not to do this automatically, since Excel is not a server component and neither is Bloomberg. Either schedule this if you must or just create a simple front end sheet with a button to click to fire the code. 6. Don't get cute and try and use event code - it will not always work. KISS is the principle to maintain when dealing with this sort of problem. Have a crack at it and post back if you get stuck. Good luck -- www.alignment-systems.com "freddie mac" wrote: Hello! I have a thing that I want to do but I do not know if this is possible. I have a spreadsheet on a Blommberg PC that has Excel. I download prespecified data from Bloomberg to the spreadsheet at a certain time once every day. The data that I am dowloadning to the spreadsheet is different ratings for different banks. Now I want to send out an email (automatically) if a rating has changed. In this email I want to show: 1) what bank has a new rating 2) what the old rating was 3) what the new rating is I use the DDE to connect Bloomberg to the spreadsheet and this works fine. Now what I do not know is how (if possible) you send out en email if any rating has changed. Is this best done from Excel or Bloomberg? Any assistance is very much appreciated. I can post some more detalied info concerning this at request. Thank you very much for your time. -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
Hello Nick (and everyone else that reads this message)! I contacted the Bloomberg helpdesk but they said that the only email alert the Bloomberg offers concerns price changes on securities. Thus I will have to send the email from Excel. I was just wondering how the WS_Change works? The worksheet is updated every day meaning the "new" but identical info is downloaded onto the spreadsheet. Is that a problem for the WS_Change or does react only to "real" changes? To clarify on date 2001-01-01 the rating for ABN Amro is AA. Now the spreadsheet is updated 2001-01-02 but ABN Amro has the same rating. Is this going to be a problem? If so is there any way of solving that or different solution approach? I have very grateful for any assistance. Thank you ver much! -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
Fannie Mae is his wife :)
"John.Greenan" wrote: Freddie Mac eh? At least you're not calling yourself Fannie Mae... Anyhow, your firm will be paying about $1500 per bloomberg per month, so get onto their helpdesk and ask them to help you. Here are a few things to beware of: 1. You are not allowed to distribute Bloomberg data to PCs that do not have a full Bloomberg license installed. 2. You will need to keep the "old" rating and the new rating. 3. Which rating are you interested in? Moody, S&P, Fitch? 4. Best place to do this is in Excel 5. Best not to do this automatically, since Excel is not a server component and neither is Bloomberg. Either schedule this if you must or just create a simple front end sheet with a button to click to fire the code. 6. Don't get cute and try and use event code - it will not always work. KISS is the principle to maintain when dealing with this sort of problem. Have a crack at it and post back if you get stuck. Good luck -- www.alignment-systems.com "freddie mac" wrote: Hello! I have a thing that I want to do but I do not know if this is possible. I have a spreadsheet on a Blommberg PC that has Excel. I download prespecified data from Bloomberg to the spreadsheet at a certain time once every day. The data that I am dowloadning to the spreadsheet is different ratings for different banks. Now I want to send out an email (automatically) if a rating has changed. In this email I want to show: 1) what bank has a new rating 2) what the old rating was 3) what the new rating is I use the DDE to connect Bloomberg to the spreadsheet and this works fine. Now what I do not know is how (if possible) you send out en email if any rating has changed. Is this best done from Excel or Bloomberg? Any assistance is very much appreciated. I can post some more detalied info concerning this at request. Thank you very much for your time. -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending automatic email + Bloomberg
I guess that makes Ginnie Mae his mistress then??? Sallie Mae is the
daughter?? -- www.alignment-systems.com "Charlie" wrote: Fannie Mae is his wife :) "John.Greenan" wrote: Freddie Mac eh? At least you're not calling yourself Fannie Mae... Anyhow, your firm will be paying about $1500 per bloomberg per month, so get onto their helpdesk and ask them to help you. Here are a few things to beware of: 1. You are not allowed to distribute Bloomberg data to PCs that do not have a full Bloomberg license installed. 2. You will need to keep the "old" rating and the new rating. 3. Which rating are you interested in? Moody, S&P, Fitch? 4. Best place to do this is in Excel 5. Best not to do this automatically, since Excel is not a server component and neither is Bloomberg. Either schedule this if you must or just create a simple front end sheet with a button to click to fire the code. 6. Don't get cute and try and use event code - it will not always work. KISS is the principle to maintain when dealing with this sort of problem. Have a crack at it and post back if you get stuck. Good luck -- www.alignment-systems.com "freddie mac" wrote: Hello! I have a thing that I want to do but I do not know if this is possible. I have a spreadsheet on a Blommberg PC that has Excel. I download prespecified data from Bloomberg to the spreadsheet at a certain time once every day. The data that I am dowloadning to the spreadsheet is different ratings for different banks. Now I want to send out an email (automatically) if a rating has changed. In this email I want to show: 1) what bank has a new rating 2) what the old rating was 3) what the new rating is I use the DDE to connect Bloomberg to the spreadsheet and this works fine. Now what I do not know is how (if possible) you send out en email if any rating has changed. Is this best done from Excel or Bloomberg? Any assistance is very much appreciated. I can post some more detalied info concerning this at request. Thank you very much for your time. -- freddie mac ------------------------------------------------------------------------ freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101 View this thread: http://www.excelforum.com/showthread...hreadid=560577 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
Sending automatic e-mail from Xl | Excel Programming | |||
Sending Email | Excel Programming | |||
Email sending | Excel Discussion (Misc queries) | |||
Sending an email | Excel Programming |